On Wed, Jul 13, 2005 at 01:16:25PM -0600, Dan Harris wrote:

> On Jul 13, 2005, at 1:11 PM, John A Meinel wrote:
> >I might be wrong, but there may be something much more substantially
> >wrong than slow i/o.
> Yes, I'm afraid of that too.  I just don't know what tools I should  
> use to figure that out.  I have some 20 other databases on this  
> system, same schema but varying sizes, and the small ones perform  
> very well.  It feels like there is an O(n) increase in wait time that  
> has recently become very noticeable on the largest of them.

I'd guess it's stuck on some lock.  Try that EXPLAIN, and when it
blocks, watch the pg_locks view for locks not granted to the process
executing the EXPLAIN.  Then check what else is holding the locks.

Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"La rebeldía es la virtud original del hombre" (Arthur Schopenhauer)

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to