Re: [PERFORM] [HACKERS] fsync vs open_sync

2004-08-11 Thread Steve Bergman
On Tue, 2004-08-10 at 10:18 -0700, Josh Berkus wrote: Guys, just so you know: OSDL did some testing and found Ext3 to be perhaps the worst FS for PostgreSQL -- although this testing was with the default options. Ext3 involved an almost 40% write performance penalty compared with Ext2,

Re: [PERFORM] postgresql 8.0 beta - fail to collect statsistic

2004-08-23 Thread Steve Bergman
If IPv6 doesn't work, shouldn't it fall back to IPv4, or check IPv4 first, or something? Just wondering. -Steve Bergman ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [PERFORM] fsync vs open_sync

2004-09-04 Thread Steve Bergman
://marc.theaimsgroup.com/?l=reiserfsm=109363302000856 -Steve Bergman ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[PERFORM] Optimizing for writes. Data integrity not critical

2005-05-19 Thread Steve Bergman
. Is there a better way? Combining them all into a transaction or something? Thanks, Steve Bergman ---(end of broadcast)--- TIP 8: explain analyze is your friend