Re: [pgsql-patches] O_DIRECT support for Windows

2007-01-17 Thread Magnus Hagander
> People seem to be confusing sector size and cluster size. > > Microsoft Windows assumes sectors are 8k or less on hard drives (99% are > 512 bytes). Do you have any doc ref for this? I beleive you but I've been searching for docs on that and found nothing. > > Cluster size is the allocation

Re: [pgsql-patches] O_DIRECT support for Windows

2007-01-17 Thread Magnus Hagander
> >> I think many people can benefit from Itagaki-san's proposal, and > >> NO_BUFFERING should be default. Isn't it very rare that disks with > >> sector size larger than 8KB are used? > > > > Definitly very rare. > > > > > >> Providing a way (such as > >> wal_sync_method) to avoid NO_BUFFERING is

Re: [pgsql-patches] Recalculating OldestXmin in a long-running vacuum

2007-01-17 Thread Gregory Stark
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > Tom Lane wrote: > > > In any case I'd like to see some evidence of significant real-world > > benefit before adding such a conceptual wart ... > > I've asked our testers to do a TPC-C run with and without the > patch. I'm not expecting it to make

Re: [pgsql-patches] [PATCHES] pg_standby

2007-01-17 Thread Merlin Moncure
On 12/28/06, Simon Riggs <[EMAIL PROTECTED]> wrote: On Thu, 2006-12-28 at 19:26 +, Simon Riggs wrote: > On Thu, 2006-12-14 at 12:04 +, Simon Riggs wrote: > > pg_standby and test framework, in separate .tar files > > New version (v2), following further testing. > > Signal handling not incl

Re: [pgsql-patches] [PATCHES] pg_standby

2007-01-17 Thread Doug Knight
I confirm that I am seeing the exact same characteristic. Could you post your rotating script? Thanks, Doug On Wed, 2007-01-17 at 10:05 -0500, Merlin Moncure wrote: > On 12/28/06, Simon Riggs <[EMAIL PROTECTED]> wrote: > > On Thu, 2006-12-28 at 19:26 +, Simon Riggs wrote: > > > On Thu, 2006-12

Re: [pgsql-patches] [PATCHES] pg_standby

2007-01-17 Thread Merlin Moncure
On 1/17/07, Doug Knight <[EMAIL PROTECTED]> wrote: I confirm that I am seeing the exact same characteristic. Could you post your rotating script? note: this is still a work in progress, the crude but effective sleep 5 is due to be replaced with a lock/fifo and there catch_wal.sh needs to be r

Re: [pgsql-patches] [PATCHES] pg_standby

2007-01-17 Thread Merlin Moncure
On 1/17/07, Merlin Moncure <[EMAIL PROTECTED]> wrote: On 1/17/07, Doug Knight <[EMAIL PROTECTED]> wrote: > I confirm that I am seeing the exact same characteristic. Could you post > your rotating script? note: this is still a work in progress, the crude but effective sleep 5 is due to be repla

Re: [pgsql-patches] O_DIRECT support for Windows

2007-01-17 Thread Chuck McDevitt
BTW: From the current FAT/FAT32 source code fsctrl.c (which I have via Microsoft's IFS kit), when it checks the boot sector for validity: // // Enforce some sanity on the sector size (easy check) // } else if ((Bpb.BytesPerSector != 128) && (Bpb.BytesPerSector !=

Re: [pgsql-patches] [PATCHES] pg_standby

2007-01-17 Thread Merlin Moncure
On 1/17/07, Simon Riggs <[EMAIL PROTECTED]> wrote: new v4 Changes - removed -m command, design flaw in original spec, use -l instead - added -k N command to cleanup archive and leave max N files - fflush() points added to allow Windows debug - bug fix: when .history file present - bug fix: comma

Re: [pgsql-patches] [PATCHES] Tablespace for temporary objects and

2007-01-17 Thread Robert Treat
On Sunday 14 January 2007 23:16, Jaime Casanova wrote: > On 1/13/07, Albert Cervera Areny <[EMAIL PROTECTED]> wrote: > > It was already possible to set the guc on postgresql.conf when I posted > > the patch... > > ok... fixed... the problem was that this code only let > num_temp_tablespaces be grea