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

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 (view raw or flat)
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

pgsql-general by date

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

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