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.