PgSql

idea - new aggregates median, listagg
On Tue, Dec 15, 2009 at 10:28:49PM +0100, Pavel Stehule wrote: Hello I am looking on new feature - ORDER clause in aggregate, and I thing, so we are able to effectively implement some non standard, but well known aggregates. a) function median - it is relative frequent request - with usually s... 16 Dec 2009 11:15

[HACKERS] Update on true serializable techniques in MVCC
Just to make those who care aware of it, here is Michael Cahill's Doctoral Thesis based on implementing Serializable Snapshot Isolation in InnoDB using a refined version of the techniques previously used in the Berkley DB (and previously discussed on this list): http://hdl.handle.net/2123/5353 For those who... 15 Dec 2009 14:29

[HACKERS] Hot Standby and prepared transactions
I get this when testing prepared transactions, which looks like it is unrelated to Hot Standby. 2009-12-15 17:28:08 GMT[10385]LOG: archive recovery complete 2009-12-15 17:28:08 GMT[10428]LOG: checkpoint starting: end-of-recovery immediate wait 2009-12-15 17:28:08 GMT[10428]DEBUG: creating and filling new WA... 15 Dec 2009 14:29

[HACKERS] Fast or immediate shutdown
running with log_checkpoints = on pg_ctl -D foo -m fast stop log says LOG: received fast shutdown request LOG: aborting any active transactions LOG: shutting down LOG: restartpoint starting: shutdown immediate Some of us know that the "immediate" word refers to the restartpoint request, though that ... 15 Dec 2009 13:22

Range types
Scott Bailey <artacus(a)comcast.net> wrote: CREATE TYPE periodtz AS RANGE (timestamptz, '1 microsecond'::interval); What does the second argument mean? Is it a default interval? So basically I have a pg_range table to store the base typeid, a text field for the granule value and the granule typeid. ... 23 Dec 2009 15:10

Winflex
Magnus Hagander wrote: Using http://www.postgresql.org/ftp/misc/winflex/ on a 64-bit windows, but in 32-bit mode (this certainly used to work), trying to build HEAD. first of all, it returns error code 128 when running "flex -V", which means our script claims it doesn't work. Commenting out ... 14 Dec 2009 07:42

Largeobject Access Controls (r2460)
Hi, I'm reviewing LO-AC patch. KaiGai Kohei <kaigai(a)ak.jp.nec.com> wrote: Nothing are changed in other codes, including something corresponding to in-place upgrading. I'm waiting for suggestion. I have a question about the behavior -- the patch adds ownership management of large objects. Non-privileged use... 20 Dec 2009 20:11

explain output infelicity in psql
On Wed, Dec 9, 2009 at 2:37 PM, Andrew Dunstan <andrew(a)dunslane.net> wrote: I have just noticed while checking the EXPLAIN YAML patch that the non-text explain formats are output as a single line with embedded line feeds, while the text format is delivered as a set of text records, one per line. The prac... 12 Dec 2009 04:51

[HACKERS] explain output infelicity in psql
I have just noticed while checking the EXPLAIN YAML patch that the non-text explain formats are output as a single line with embedded line feeds, while the text format is delivered as a set of text records, one per line. The practical effect of this is that psql decorates the non-text format output with conti... 9 Dec 2009 15:32

[HACKERS] 答复: questions about concurrency control in Postgresql
It's a two step process. An update marks the tuple locked. Another transaction which comes along and wants to lock the tuple waits on the transaction marked on the tuple. When the first transaction commits or aborts then the second transaction can proceed and lock the tuple itself. I agree with it. The ... 9 Dec 2009 08:48