Arrays can be created easily in PostgreSQL using the additional syntax [] when defining a column of a table.
Read more...2011-10-09 02:54:29 +0000
Arrays can be created easily in PostgreSQL using the additional syntax [] when defining a column of a table.
Read more...2011-10-05 07:20:06 +0000
This study is made with PostgreSQL 9.1.1, released a couple of days before this post is written. Unlogged tables are a new performance feature of PostgreSQL 9.1, created by Robert Hass. So, by guessing from this feature name, those tables are not logged in the database system :). More precisely, those tables do not use at all WAL (Write ahead log) that insure a safe database crash. Those tables are a good performance gain to contain data that do not especially need to survive from a crash, they are truncated automatically after a crash or unclean shutdown. Unlogged tables are shared among sessions, and are not deleted when a session ends. Autovacuum runs on them.
Read more...2011-09-18 11:02:39 +0000
Scanning a table in a database can cost a lot in terms of CPU or I/O when calculating statistics in an application. The bigger application tables get, the more resource is necessary to calculate simple statistics for an application. A simple example of that are queries of the type:
Read more...2011-09-05 06:32:00 +0000
In library git-core, git has a command that makes all the commits appearing in graphs. For example:
Read more...2011-08-15 06:56:58 +0000
This post presents some basics when using foreign data wrappers with PostgreSQL for external files. FOREIGN DATA WRAPPER is a part of SQL/MED (Management of external data with SQL) and its implementation has begun since Postgres 8.4. This mechanism is based on COPY FROM to import data files directly into your database. Those tests have been done with 9.2 (development version).
Read more...Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2023 and are licensed for use under CC BY-SA 3.0.