PgSql

[HACKERS] Alpha4 Available Now
The fourth alpha release for PostgreSQL version 9.0, 9.0alpha4, is now available. This alpha contains several new major features added since the previous alpha. Please download, install, and test it to give us early feedback on the features being developed for the next version of PostgreSQL. Features added in Al... 24 Feb 2010 00:57

pgsql: Move documentation of all recovery.conf option to a new chapter.
On Wed, Feb 24, 2010 at 8:24 AM, Simon Riggs <simon(a)2ndquadrant.com> wrote: On Mon, 2010-02-22 at 11:47 +0000, Heikki Linnakangas wrote: Log Message: ----------- Move documentation of all recovery.conf option to a new chapter. They used to be scattered between the "backup and restore" and "streaming ... 24 Feb 2010 14:17

[PATCH] backend: compare word-at-a-time in bcTruelen
On Mon, Feb 22, 2010 at 9:35 PM, Bruce Momjian <bruce(a)momjian.us> wrote: Tom Lane wrote: Jeremy Kerr <jk(a)ozlabs.org> writes: Stephen, If the updated function is always faster when the overall string is at least, say, 16 characters long, But that's not the case - the cost of the func... 23 Feb 2010 14:43

pg_stop_backup does not complete
This issue is 100% reproduceable. Oh, btw, this is on Alpha4. --Josh Berkus -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers ... 2 Mar 2010 08:58

[HACKERS] pg_stop_backup does not complete
Simon, Fujii, All: While demoing HS/SR at SCALE, I ran into a problem which is likely to be a commonly encountered bug when people first setup HS/SR. Here's the sequence: 1) Set up a brand new master with an archive-commmand and archive=on. 2) Start the master 3) Do a pg_start_backup() 4) Realize, bas... 23 Feb 2010 13:34

Index-only quals
I added this URL to the existing TODO item. --------------------------------------------------------------------------- Heikki Linnakangas wrote: Here is an updated version of my patch to return data from b-tree indexes, and use it to satisfy quals. I added a new column 'amregurgitate' to pg_am, to... 23 Feb 2010 12:26

tie user processes to postmaster
Jaime Casanova <jcasanov(a)systemguards.com.ec> wrote: integrated_user_processes = 'x, y, z' API would be user_process_startup(), user_process_shutdown(). FYI, pg_statsinfo version 2 emulates the same behavior with shared_preload_libraries and spawn an user process in _PG_init(). But it's still ugly and no... 23 Feb 2010 01:22

More robust pg_hba.conf parsing/error logging
Tom Lane wrote: Alvaro Herrera <alvherre(a)commandprompt.com> writes: Andrew Dunstan wrote: It will affect any dbname or username in mixed or upper case, not just ALL, won't it? No, I am suggesting to change only the comparisons to the literals "all", "sameuser", "samegroup" and "samerol... 23 Feb 2010 17:03

function side effects
"Tatsuo Ishii" <ishii(a)postgresql.org> wrote: VOLATILE functions such as random() and timeofday() apparently do not write and sending those queries that include such functions is overkill. Can we VOLATILE property divide into two categories, say, VOLATILE without write, and VOLATILE with write? I... 2 Mar 2010 05:41

[HACKERS] synchronous commit in dump
Hi, it's safe to set synchrounous_commit to off in a pg_dump generated script? if yes, would this help to the performance of restore a database? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via p... 22 Feb 2010 23:09