Ports 搜索

PostgreSQL log analyzer with fully detailed reports and charts.

pg_statsinfo is a utility that monitor statistics and the activity of PostgreSQL(and OS). pg_statsinfo gets some statistics information as snapshot. We can check the DB activity and bottleneck analysis by using these snapshot information. This utility provides some function to get the information acquisition easily.

pgloader imports data from a flat file and inserts it into one or more PostgreSQL database tables. It uses a flat file per database table, and you can configure as many Sections as you want, each one associating a table name and a data file. Data are parsed and rewritten, then given to PostgreSQL COPY command. Parsing is necessary for dealing with end of lines and eventual trailing separator characters, and for column reordering: your flat data file may not have the same column order as the database table has. pgloader is also able to load some large objects data into PostgreSQL, as of now only Informix UNLOAD data files are supported. This command gives large objects data location information into the main data file. pgloader parse it add the text or bytea content properly escaped to the COPY data. pgloader issues some timing statistics every "commit_every" commits. At the end of processing each section, a summary of overall operations, numbers of rows copied and commits, time it took in seconds, errors logged and database errors is issued.

This project aims to reduce the size of archive log files by replacing backup blocks (full page writes) marked as "removable" (introduced in 8.3) with corresponding incremental logs.

pgSphere provides spherical data types, functions, and operators for PostgreSQL.

PureDB is a portable and tiny set of libraries for creating and reading constant databases. It manages data files that contains text or binary key/data pairs of arbitrary sizes. Lookups are very fast (normally only one disk access to match a hash value), overhead is low (a database is 1028 bytes plus only 16 extra bytes per record), multiple concurrent read access are supported, and databases can be up to 4 Gb long, and they are portable across architectures.

This is a python client for the Swift API. There's a Python API (the ``swiftclient`` module), and a command-line script (``swift``). This code is based on the original client previously included with OpenStack's swift -- a highly available, distributed, eventually consistent object/blob store.

repmgr allows you to monitor and manage your replicated PostgreSQL databases as a single cluster.

PL/Lua is an implementation of Lua as a loadable procedural language for PostgreSQL: with PL/Lua you can use PostgreSQL functions and triggers written in the Lua programming language.

PL/Proxy is a proxy language used for remote database procedure calls and data partitioning between databases based on hashing field values. Main idea is that proxy function will be created with same signature as remote function to be called, so only destination info needs to be specified inside proxy function body.