[PERFORM] PARSE WAITING
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-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] PARSE WAITING
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 on what this means? what's the parse waiting for? It means the parse phase is waiting for a lock. You can see exactly what it's waiting for by looking at pg_locks WHERE NOT GRANTED. Have you got lots of partitions, or something? -- Álvaro Herrera alvhe...@commandprompt.com The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] PARSE WAITING
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 fastest operation.. just for my info, can anyone tell me what pgsql_tmp is, and why the engine is wacking each file individually? These are temp files, which you can remove without concern if the server is down. -- Álvaro Herrera alvhe...@commandprompt.com The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance