PgSql

[HACKERS] Small Bug in pgstat display during recovery conflict resolution
Hi Simon, Hi all, if (!logged && (wait_s > 0 || wait_us > 500000)) { const char *oldactivitymsg; int len; oldactivitymsg = get_ps_display(&len); snprintf(waitactivitymsg, sizeof(waitactivitymsg), "waiting for max_standby_delay (%u... 8 Feb 2010 20:15

[HACKERS] Order of operations in lazy_vacuum_rel
I see that lazy_vacuum_rel() truncates the heap before it does vacuuming of the free space map. Once upon a time this wouldn't have mattered, but now it means that cancel interrupts are likely to be ignored for the duration of FreeSpaceMapVacuum(). Is that really necessary? Would it be okay to swap the two steps?... 8 Feb 2010 15:40

Knngist for 8.5
2010/2/8 Oleg Bartunov <oleg(a)sai.msu.su>: List of holidays by country http://en.wikipedia.org/wiki/List_of_holidays_by_country I'm not sure how it's valid, though. In Russia, for example, russian goverment decreed holidays 1-10 January, 2010. I think next time we should consider december-january as a ... 8 Feb 2010 20:15

Backup history file should be replicated in Streaming Replication?
On Sun, Feb 7, 2010 at 1:02 AM, Bruce Momjian <bruce(a)momjian.us> wrote: src/backend/access/transam/xlog.c else {     XLogRecPtr      InvalidXLogRecPtr = {0, 0};     ControlFile->minRecoveryPoint = InvalidXLogRecPtr; } In my original patch, the above is for the problem discussed... 8 Feb 2010 19:07

[HACKERS] Writeable CTEs and empty relations
Hi, While playing around with another issue with the patch, I came across the following: => create table foo(a int); CREATE TABLE => with t as (insert into foo values(0)) select * from foo; a --- (0 rows) I traced this down to heapam.c, which has this: /* * return null immediately if relation is em... 8 Feb 2010 14:31

FM format modifier does not remove leading zero from year
Alvaro Herrera <alvherre(a)commandprompt.com> writes: What's the point of not following Oracle here, since this is solely an Oracle compatibility function? Changing FM's behavior like that will break approximately every user of to_char() ... regards, tom lane -- Sent via pgsql-hackers mailing list (p... 8 Feb 2010 14:31

FM format modifier does not removeleading zero from year
Bruce Momjian wrote: Guy Rouillier wrote: On 1/6/2010 3:29 PM, Tom Lane wrote: Guy Rouillier<guyr-ml1(a)burntmail.com> writes: Oracle states clearly in the SQL Reference manual: "A modifier can appear in a format model more than once. In such a case, each subsequent occurren... 8 Feb 2010 14:31

[HACKERS] Streaming replication in docs
The post about the dev docs needing more hot standby mentions prompted me to have a look at how streaming replication is documented. Ignore this if this has already been discussed (I couldn't find any posts), but I couldn't find any mention of streaming replication except in the write ahead log configuration. The... 7 Feb 2010 05:25

FM format modifier does not remove leading zerofrom year
Guy Rouillier wrote: On 1/6/2010 3:29 PM, Tom Lane wrote: Guy Rouillier<guyr-ml1(a)burntmail.com> writes: Oracle states clearly in the SQL Reference manual: "A modifier can appear in a format model more than once. In such a case, each subsequent occurrence toggles the effects of the modifi... 6 Feb 2010 16:19

Backup history file should be replicated inStreaming Replication?
Fujii Masao wrote: On Mon, Jan 4, 2010 at 9:55 PM, Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: Heikki Linnakangas wrote: Here's is modified patch that adds a new backupStartPoint field to pg_control for that + some other minor editorialization. I've committed this no... 6 Feb 2010 11:51