PgSql

Hot Standby query cancellation and Streaming Replication integration
On Fri, Feb 26, 2010 at 8:33 AM, Greg Smith <greg(a)2ndquadrant.com> wrote: I'm not sure what you might be expecting from the above combination, but what actually happens is that many of the SELECT statements on the table *that isn't even being updated* are canceled.  You see this in the logs: Well I propo... 10 Mar 2010 20:54

Why isn't stats_temp_directory automatically created?
Bruce Momjian <bruce(a)momjian.us> writes: I assume we decided we didn't want this. I thought the risk/reward ratio was pretty bad. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hack... 25 Feb 2010 22:43

[HACKERS] feature request
hello to everyone, is a bit late for an italian, but after an long day debugging I had an idea. Why not introduce a special SQL command like STORE WHERE [condition] FROM [table] removing all data that meet the condition and storing them into another database? Then, if a query that needs the stored data is execute... 25 Feb 2010 17:06

Odd CVS revision number
Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> writes: I just noticed that the revision numbering for the new src/doc/sgml/recovery-config.sgml file I added started from 2 for some reason. The first revision was 2.1, and when I just updated it the new revision became 2.2. It seems to work fin... 25 Feb 2010 11:24

[HACKERS] Odd CVS revision number
I just noticed that the revision numbering for the new src/doc/sgml/recovery-config.sgml file I added started from 2 for some reason. The first revision was 2.1, and when I just updated it the new revision became 2.2. It seems to work fine, but I've never seen CVS revision numbers like that before. Anyone have a... 25 Feb 2010 04:45

[HACKERS] Streaming rep - why log shipping is necessary?
Hello, I was reading the SR docs, and have the following question: Is there a fundamental reason why archive_command etc. is required in streaming replication mode? Can`t setting up the standby be more like: pg_start_streaming_backup() on the master (this will be queuing up files in pg_xlog) copy the data dir ... 25 Feb 2010 04:45

testing cvs HEAD - HS/SR - xlog timeline 0 pg_xlogfile_name_offset
Fujii Masao wrote: On Thu, Feb 25, 2010 at 9:31 AM, Erik Rijkers <er(a)xs4all.nl> wrote: On Wed, February 24, 2010 20:40, Erik Rijkers wrote: pg_last_xlog_receive_location | pg_xlogfile_name_offset -------------------------------+----------------------------------- E2/C012AD90 ... 25 Feb 2010 05:51

[HACKERS] Probably badly timed suggestion: pl/perl calling style same as Cstyle
With plperl.on_init allowing the loading of modules, might there be some merit (and little cost) in allowing the same style of function-mapping as with C functions? CREATE FUNCTION add_one(integer) RETURNS integer AS 'DIRECTORY/funcs', 'add_one' LANGUAGE C STRICT; CREATE FUNCTION add_one(integer... 24 Feb 2010 17:43

[HACKERS] Bizarre buildfarm failure on baiji: can't find pg_class_oid_index
There is a failure report here that seems worthy of notice: http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=baiji&dt=2010-02-23%2023:00:03 Everything is fine except that the session running the "triggers" test went completely bonkers: the first few commands are okay, and then after that everything fails wi... 24 Feb 2010 16:34

FW: Unable to install PostgreSQL on Windows Server2003 SP2
On 24/02/10 13:09, William wrote: Hello Pqsql-hacker, I have tried everything and ask many but cannot get my Installation of your PostgreSQL 8.4.1.1 to install. While you are having problems, take the opportunity to download 8.4.2 and work with that. That's the latest set of bugfixes. I following... 24 Feb 2010 15:25