Re: a very slow SQL - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: a very slow SQL
Date
Msg-id 4FE7FD9A0200002500048A5A@gw.wicourts.gov
Whole thread Raw
In response to a very slow SQL  (wangqi <wangqi@edgesoft.cn>)
List pgsql-admin
wangqi  wrote:

> An SQL execution is very slow.
> What can I do to makes it faster。

Without knowing more about the version of PostgreSQL, your PostgreSQL
configuration, your schema (including indexes), and your hardware,
it's hard to give advice.

http://wiki.postgresql.org/wiki/SlowQueryQuestions

A wild guess on the evidence we have is that you might benefit from
an index on MCL.ctid if you don't already have one.

-Kevin

pgsql-admin by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: terminating autovacuum process due to administrator command
Next
From: Mike Broers
Date:
Subject: Re: starting postgres with an empty px_xlog folder