PgSql

Streaming replication and non-blocking I/O
On Tue, Dec 8, 2009 at 11:23 PM, Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: The first question is: do we really need to be prepared for that? The XLogRecPtr acknowledgment messages the client sends are very small, and if the client is mindful about not sending them too often - perhaps max... 16 Jan 2010 09:30

Sought after architectures for the PostgreSQL buildfarm?
Peter St. Onge wrote privately: With the local server room renovations, there may be some older equipment being retired. Are there any architectures that you would like to see added to the buildfarm? Hackers, Any nominations? cheers andrew -- Sent via pgsql-hackers mailing list (pgsq... 8 Dec 2009 14:10

YAML
All, What it's sounding like is that we ought to have a plug-in (both for postmaster and for psql) which allows the calling of an external library to parse explain output. Then people could covert XML/JSON into whatever they wanted. --Josh Berkus -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)po... 8 Dec 2009 11:55

[PATCH] Largeobject Access Controls (r2460)
I just looked over the latest version of this patch and it seems to satisfy all the issues suggested by the initial review. This looks like it's ready for a committer from a quality perspective and I'm going to mark it as such. I have a guess what some of the first points of discussion are going to be thoug... 7 Dec 2009 11:47

Hot standby, recent changes
On Sun, 2009-12-06 at 12:32 +0200, Heikki Linnakangas wrote: 1. The XLogFlush() call you added to dbase_redo doesn't help where it is. You need to call XLogFlush() after the *commit* record of the DROP DATABASE. The idea is minimize the window where the files have already been deleted but the entry in pg_da... 7 Dec 2009 04:09

Patch for information_schema performance
On fre, 2009-09-25 at 00:55 +0200, Joachim Wieland wrote: the attached patch addresses the performance issues of the authorization related views from information_schema (BUG #4596). It implements what Tom suggests in http://archives.postgresql.org/pgsql-bugs/2008-12/msg00144.php In the cases that... 5 Dec 2009 17:22

[GENERAL] pg_attribute.attnum - wrong column ordinal?
Greg Stark escribi�: On Wed, Nov 25, 2009 at 1:03 AM, Konstantin Izmailov <pgfizm(a)gmail.com> wrote: My question:�can pg_attribute.attnum be used to determine the sequential ordinal positions of columns in a table? What is a right way to get the ordinal numbers? You could use something like:... 5 Dec 2009 15:09

how to hack a webmail
Hi everybody, I would like to hack a webmail, like hotmail or gmail. Please. ... 2 Dec 2009 21:12

[HACKERS] Ragged CSV import
Hi, In sept 2009 there was a discussion of ragged csv import and import requirements. I thought I'd add my requirements to the heap. I'm working a QA solution for a dbms migration project that will import query output from a non PG database into PG, so we can compare query results between PG and the alternative ... 2 Dec 2009 16:41

Adding support for SE-Linux security
Bruce, If we decide not to support SE-Linux, it is unlikely we will be adding support for any other external security systems because SE-Linux has the widest adoption. I think the big question is whether we are ready to extend Postgres to support additional security infrastructures. PostgreSQL i... 15 Dec 2009 22:15