Re: [PERFORM] Slow select performance despite seemingly reasonable query plan

2009-05-09 Thread Laurent Wandrebeck
2009/5/7 David Brain : > Hi, Hi, > > Some answers in-line: > >> >> Has there been a performance *change*, or are you just concerned about a >> query which doesn't seem to use "enough" disc bandwidth? > > Performance has degraded noticeably over the past few days. > >> Certainly random access like t

Re: [PERFORM] "iowait" bug?

2009-03-22 Thread Laurent Wandrebeck
2009/3/22 Greg Smith : > On Fri, 20 Mar 2009, M. Edward (Ed) Borasky wrote: > >> I just discovered this on a LinkedIn user group: >> http://bugzilla.kernel.org/show_bug.cgi?id=12309 > > I would bet there's at least 3 different bugs in that one.  That bug report > got a lot of press via Slashdot a f

Re: [PERFORM] "iowait" bug?

2009-03-22 Thread Laurent Wandrebeck
2009/3/21 M. Edward (Ed) Borasky : > I just discovered this on a LinkedIn user group: > > http://bugzilla.kernel.org/show_bug.cgi?id=12309 > > Is anyone here seeing evidence of this in PostgreSQL?? I've been hit by an I/O wait problem, as described here: https://bugzilla.redhat.com/show_bug.cgi?id=