PgSql

Parameter oddness; was HS/SR Assert servercrash
Kevin Grittner wrote: Bruce Momjian <bruce(a)momjian.us> wrote: One odd thing is we have two paramters that mention hot_standby --- on the master we have to do in postgresql.conf: wal_level = hot_standby and on the slave we do in postgresql.conf: hot_standby = on ... 14 May 2010 19:25

Generating Lots of PKs with nextval(): A Feature Proposal
Peter Crabtree <peter.crabtree(a)gmail.com> writes: Now, I was reminded that I could simply do this: SELECT nextval('my_seq') FROM generate_series(1, 500); But of course then I would have no guarantee that I would get a contiguous block of ids, The existing "cache" behavior will already handle that for... 14 May 2010 19:25

recovery consistent != hot standby
Robert Haas <robertmhaas(a)gmail.com> writes: PM_RECOVERY_CONSISTENT -> PM_HOT_STANDBY PMSIGNAL_RECOVERY_CONSISTENT -> PMSIGNAL_BEGIN_HOT_STANDBY +1. From the point of view of the postmaster, whether the state transition happens immediately upon reaching consistency, or at a later time, or perhaps even earlie... 15 May 2010 16:59

Parameter oddness; was HS/SR Assert server crash
bruce wrote: and my slave recovery.conf was: restore_command = 'cp /u/pg/archive/%f %p' # e.g. 'cp /mnt/server/archivedir/%f %p' standby_mode = 'on' primary_conninfo = 'host=localhost port=5432' # e.g. 'host=localhost port=5432' Let me know what additional ... 14 May 2010 18:19

[HACKERS] Generating Lots of PKs with nextval(): A Feature Proposal
Recently, in preparation for migrating an application to postgres, I got to this part of the manual (which is *excellent* so far, by the way): http://www.postgresql.org/docs/8.4/interactive/functions-sequence.html A quick check with the folks on #postgresql confirmed my understanding, which was that the lockin... 14 May 2010 16:08

fillfactor gets set to zero for toast tables
Excerpts from Tom Lane's message of vie may 14 14:19:30 -0400 2010: The problem is that if any reloption is set for the toast table, we build a StdRdOptions struct in which fillfactor is zero, and then all the code that actually uses fillfactor honors that. And the reason fillfactor gets left as zero is t... 4 Jun 2010 00:31

Generalized Inverted Generalized Search Tree
On Fri, May 14, 2010 at 12:03 AM, Takahiro Itagaki <itagaki.takahiro(a)oss.ntt.co.jp> wrote: We can index multiple scalar values per row with GIN access method, and also can index single vector value per row with GiST AM. Is it worth having a new AM to index multiple vector values per row? It will be an A... 14 May 2010 15:01

[HACKERS] fillfactor gets set to zero for toast tables
I've been able to reproduce the problem described here: http://archives.postgresql.org/pgsql-bugs/2010-05/msg00100.php Do this: create table foo(f1 text); alter table foo set (toast.autovacuum_enabled = false); insert into foo values(repeat('xyzzy',100000)); vacuum verbose foo; Notice that the vacuum output ... 14 May 2010 15:01

JSON manipulation functions
Joseph Adams wrote: == array/object conversion == The json_object function converts a tuple to a JSON object. If there are duplicate column names, there will be duplicate keys in the resulting JSON object. json_object([content [AS name] [, ...]]) returns json Likewise, the json_array func... 27 May 2010 17:03

Row-level Locks & SERIALIZABLE transactions, postgres vs. Oracle
On May 14, 2010, at 15:54 , Kevin Grittner wrote: Florian Pflug <fgp(a)phlo.org> wrote: On May 14, 2010, at 12:56 , Kevin Grittner wrote: unless your patch completely removes support for snapshot isolation (what is current called SERIALIZABLE) Both SERIALIZABLE and REPEATABLE READ currently map to s... 14 May 2010 10:35