Skip site navigation (1) Skip section navigation (2)

Re: PARSE WAITING

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: David Kerr <dmk(at)mr-paradox(dot)net>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PARSE WAITING
Date: 2010-08-23 22:23:25
Message-ID: 1282602153-sup-6272@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-performance
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 <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

pgsql-performance by date

Next:From: David KerrDate: 2010-08-23 22:47:02
Subject: Re: PARSE WAITING
Previous:From: David KerrDate: 2010-08-23 22:19:31
Subject: Re: PARSE WAITING

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group