memcached is a high-performance, distributed memory object caching
system, generic in nature, but intended for use in speeding up dynamic
web applications by alleviating database load.
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.
pgespresso is an extension to postgresql that adds functions and views
to be used by Barman, the disaster recovery tool
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.
pgpool-II allows multiple PostgreSQL servers (DB nodes) to be
connected, which enables queries to be executed simultaneously on all
servers.
It enables "parallel query" processing. Also, pgpool-II can be started
as pgpool-I by changing configuration parameters. pgpool-II that is
executed in pgpool-I mode enables multiple DB nodes to be connected,
which was not possible in pgpool-I.
pgpool-II allows multiple PostgreSQL servers (DB nodes) to be
connected, which enables queries to be executed simultaneously on all
servers.
It enables "parallel query" processing. Also, pgpool-II can be started
as pgpool-I by changing configuration parameters. pgpool-II that is
executed in pgpool-I mode enables multiple DB nodes to be connected,
which was not possible in pgpool-I.
pgpool-II allows multiple PostgreSQL servers (DB nodes) to be
connected, which enables queries to be executed simultaneously on all
servers.
It enables "parallel query" processing. Also, pgpool-II can be started
as pgpool-I by changing configuration parameters. pgpool-II that is
executed in pgpool-I mode enables multiple DB nodes to be connected,
which was not possible in pgpool-I.
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.