pgmp is a PostgreSQL extension module that adds support for the arbitrary precision data types offered by the GMP library. It provides higher performance arithmetic for numbers, only limited by the 1GB varlena maximum size, a rational data type for absolute precision storage and arithmetic, and specialized functions to deal with prime numbers, random numbers, and factorization. The GMP data types can be used in mixed arithmetic with other PostgreSQL numeric types and indexed using the btree or hash methods. The extension is compatible with PostgreSQL 8.4 and later, and the package includes comprehensive documentation and regression tests.
pg_repack is a PostgreSQL extension which lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes. Unlike CLUSTER and VACUUM FULL, it works online, without holding an exclusive lock on the processed tables during processing. pg_repack is efficient, with performance comparable to using CLUSTER directly.
The psycogreen package makes it possible for psycopg2 to work with coroutine libraries, using asynchronous calls internally but offering a blocking interface so that regular code can run unmodified. While Psycopg offers coroutine support, the main module is a C extension that cannot be monkey-patched to become coroutine-friendly. Instead it exposes a hook that coroutine libraries can use to install a function integrating with their event scheduler. Psycopg will call the function whenever it executes a libpq call that may block. psycogreen is a collection of "wait callbacks" that can be used to integrate Psycopg with different coroutine libraries. psycogreen is currently mainly useful for integration with gevent.
py-setproctitle is a library that allows a Python process to change its title, as displayed by system tools such as ps and top. Changing the title is useful in multi-process systems, for example when a master process is forked: changing the child's title allows you to identify the task each process is busy with. It is based on PostgreSQL's multi-platform implementation.