Re: Very slow catalog query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Just Someone" <just(dot)some(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Very slow catalog query
Date: 2008-03-31 14:37:59
Message-ID: 27566.1206974279@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Just Someone" <just(dot)some(at)gmail(dot)com> writes:
> Any ideas how to start finding the culprit?

EXPLAIN ANALYZE?

What would be particularly interesting is to compare the results for
fast and slow cases of the "same" query.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2008-03-31 14:45:22 Re: Survey: renaming/removing script binaries (createdb, createuser...)
Previous Message juan_carlos 2008-03-31 14:25:00 Re: Installing support for python on windows