Re: [GENERAL] High cpu usage after many inserts

2009-02-24 Thread Aidan Van Dyk
* Greg Smith [090201 00:00]: > Shouldn't someone have ranted about RAID-5 by this point in the thread? What? Sorry, I wasn't paying attention... You mean someone's actually still using RAID-5? ;-) -- Aidan Van Dyk Cre

Re: [GENERAL] Decreasing WAL size effects

2008-10-31 Thread Aidan Van Dyk
* Aidan Van Dyk <[EMAIL PROTECTED]> [081031 15:11]: > How about something like the attached. It's been spun quickly, passed > regression tests, and some simple hand tests on REL8_3_STABLE. It seem slike > HEAD can't initdb on my machine (quad opteron with SW raid1), I

Re: [GENERAL] Decreasing WAL size effects

2008-10-31 Thread Aidan Van Dyk
* Aidan Van Dyk <[EMAIL PROTECTED]> [081031 15:11]: > Archiving 00010012 > Archiving 00010013 > Archiving 00010014 > Archiving 00010017 > Archiving 00010

Re: [GENERAL] Decreasing WAL size effects

2008-10-31 Thread Aidan Van Dyk
08-10-31 15:02 0001001C.gz And yes, even the non-zeroed segments compress well here, because my test load is pretty simple: CREATE TABLE TEST ( a numeric, b numeric, c numeric, i bigint not null ); INSERT INTO test (a,b,c,i)

Re: [GENERAL] Annoying Reply-To

2008-10-21 Thread Aidan Van Dyk
citly told you how to get back to me (by setting a reply-to), but if the MLM munged that... /me is glad that PostgreSQL doesn't "just insert NULL" when I give it an empty string, just because "NULL is pretty much the same thing" ;-) -- Aidan Van Dyk

Re: [GENERAL] cutting out the middleperl

2007-03-27 Thread Aidan Van Dyk
Kev wrote: > Hi everyone, > > I'm still in the design phase of a project. I was just wondering if > anyone has any thoughts or experience on the idea of cutting the P out > of the LAMP (or in my case, WAMP for now) stack. What I mean is > having > everything encapsulated into sql (or plpgsql or