| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | <wangqi(at)edgesoft(dot)cn>,<pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: a very slow SQL |
| Date: | 2012-06-25 10:56:42 |
| Message-ID: | 4FE7FD9A0200002500048A5A@gw.wicourts.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Broers | 2012-06-25 14:45:25 | Re: starting postgres with an empty px_xlog folder |
| Previous Message | Albe Laurenz | 2012-06-25 08:03:34 | Re: terminating autovacuum process due to administrator command |