| From: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
|---|---|
| To: | Ioannis Anagnostopoulos <ioannis(at)anatec(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: A very long running query.... |
| Date: | 2012-07-21 08:02:21 |
| Message-ID: | 500A620D.4030505@ringerc.id.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-performance |
On 07/21/2012 06:19 AM, Ioannis Anagnostopoulos wrote:
> On this Ubuntu installation the default_statistics_target = 1000 and
> not 100. Do you think that this might be an issue?
Nope. You should generally avoid setting default_statistics_target too
high anyway; leave it where it is and use ALTER TABLE ... ALTER COLUMN
... SET STATISTICS to raise the targets on columns where you're seeing
bad statistics estimates.
http://www.postgresql.org/docs/9.1/static/sql-altertable.html
Also make sure autovaccum is running frequently so it keeps the stats up
to date.
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Mamin | 2012-07-21 09:16:16 | Re: A very long running query.... |
| Previous Message | Ioannis Anagnostopoulos | 2012-07-20 23:56:34 | Re: A very long running query.... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2012-07-21 08:30:44 | Re: query overhead |
| Previous Message | Ioannis Anagnostopoulos | 2012-07-20 23:56:34 | Re: A very long running query.... |