Re: [PERFORM] PARSE WAITING

2010-08-23 Thread Alvaro Herrera
Excerpts from David Kerr's message of lun ago 23 18:47:02 -0400 2010: > unlink("base/pgsql_tmp/pgsql_tmp28335.12593") = 0 > unlink("base/pgsql_tmp/pgsql_tmp28335.6041") = 0 > unlink("base/pgsql_tmp/pgsql_tmp28335.3030") = 0 > unlink("base/pgsql_tmp/pgsql_tmp28335.14737") = 0 > > which isn't the f

Re: [PERFORM] PARSE WAITING

2010-08-23 Thread David Kerr
On Mon, Aug 23, 2010 at 06:23:25PM -0400, Alvaro Herrera wrote: - Excerpts from David Kerr's message of lun ago 23 18:15:56 -0400 2010: - > Howdy all, - > - > We're doing some performance testing, and when we scaled it our app up to about 250 concurrent users - > we started seeing a bunch of proc

Re: [PERFORM] PARSE WAITING

2010-08-23 Thread Alvaro Herrera
Excerpts from David Kerr's message of lun ago 23 18:15:56 -0400 2010: > Howdy all, > > We're doing some performance testing, and when we scaled it our app up to > about 250 concurrent users > we started seeing a bunch of processes sititng in "PARSE WAITING" state. > > Can anyone give me insite o

Re: [PERFORM] PARSE WAITING

2010-08-23 Thread David Kerr
probably waiting on the xlog directory that's filled up... ->->blamo move along, nothing to see here =) Dave On Mon, Aug 23, 2010 at 03:15:56PM -0700, David Kerr wrote: - Howdy all, - - We're doing some performance testing, and when we scaled it our app up to about 250 concurrent users - w

[PERFORM] PARSE WAITING

2010-08-23 Thread David Kerr
Howdy all, We're doing some performance testing, and when we scaled it our app up to about 250 concurrent users we started seeing a bunch of processes sititng in "PARSE WAITING" state. Can anyone give me insite on what this means? what's the parse waiting for? Thanks Dave -- Sent via pgsql-p