PgSql

[HACKERS] PITR backup history files with identical 2nd part file names
Hello After upgrading to 8.3.9 and moving some our PostgreSQL clusters to a new server yesterday, we have experienced a strange thing this past night. All PITR backup history files created when running a PITR base backup on all PostgreSQL clusters running in this new server (at different hours during the night... 21 Jan 2010 15:45

[HACKERS] Patch: regschema OID type
Hey -hackers, Enclosed is a patch adding a 'regschema' OID type. I'm really just hoping to get this out there, don't worry about committing it at this point. This is something that I've always wanted in the field (yes, I'm lazy). Many thanks to RhodiumToad for pointers about the necessary system table... 21 Jan 2010 13:28

[HACKERS] 8.5 vs. 9.0
In an attempt to pre-empt the normally drawn-out discussions about what the next version of PostgreSQL will be numbered. the core team have discussed the issue and following a lenghty debate lasting literally a few minutes decided that the next release shall be.... Wait for it.... 9.0. -- Dave Page Enter... 21 Jan 2010 05:38

Largeobject Access Controls (r2460)
KaiGai Kohei <kaigai(a)ak.jp.nec.com> wrote: This patch renamed the hasBlobs() by getBlobs(), and changed its purpose. It registers DO_BLOBS, DO_BLOB_COMMENTS and DO_BLOB_ACLS for each large objects owners, if necessary. This patch adds DumpableObjectType DO_BLOB_ACLS and struct BlobsInfo. We use three B... 9 Feb 2010 21:56

[HACKERS] is any reason why we cannot cast from record (row) to typed row?
Hello I looked on question on http://stackoverflow.com/questions/2104811/execute-using-statement-in-pl-pgsql-doesnt-work-with-record-type I was surprised so isn't possible cast from record to target type - is there reason for this? DECLARE r RECORD; BEGIN EXECUTE 'SELECT * FROM xx' INTO r; r::xx isn... 21 Jan 2010 03:28

plpython3 perf
On Jan 14, 2010, at 2:03 PM, Joshua D. Drake wrote: What I would (as a non hacker) would look for is: (1) Generalized benchmarks between plpython(core) and plpython3u I know a lot of these are subjective, but it is still good to see if there are any curves or points that bring the performance of eit... 25 Jan 2010 16:13

HS/SR and smart shutdown
On Thu, Jan 21, 2010 at 8:04 AM, Josh Berkus <josh(a)agliodbs.com> wrote: I've been working on my demo, and I'm discovering that due to the connection from the walsender and walreceiver, "smart" shutdown from pg_ctl doesn't work if replication is active. This seems worth fixing; if we don't fix it, we shou... 4 Mar 2010 13:30

[HACKERS] HS/SR and smart shutdown
I've been working on my demo, and I'm discovering that due to the connection from the walsender and walreceiver, "smart" shutdown from pg_ctl doesn't work if replication is active. This seems worth fixing; if we don't fix it, we should at least document it. Comments? --Josh -- Sent via pgsql-hackers mai... 20 Jan 2010 18:35

[HACKERS] Serializable implementation milestone: table SIREAD locks without correct lifespan
Attached is a patch for the next milestone on the Serializable wiki page: changing the table-level predicate locks to SIREAD locks without worrying about lifespan. (Implementing correct lifespan is next.) The result of not worrying about it is that they aren't cleaned up at all, even when the transaction ends ... 20 Jan 2010 17:26

[HACKERS] Custom GUCs still a bit broken
It seems like Custom GUCs are still in need of some work, as shown in my recent email. In particular, they are not transaction safe - if a transaction attempts to do DefineCustomFooVariable() and that transaction aborts, the placeholder setting that it used is already gone by the time it tries to roll back GU... 20 Jan 2010 17:26