Postgres Pro
Downloads
Home   >   mailing lists

Re: Query times change by orders of magnitude as DB ages - Mailing list pgsql-performance

From Sergey Aleynikov
Subject Re: Query times change by orders of magnitude as DB ages
Date
Msg-id a233edb60911260436k653a29aex5cb353f2b6c6cf6@mail.gmail.com
Whole thread Raw
In response to Re: Query times change by orders of magnitude as DB ages  (Richard Neill <rn214@cam.ac.uk>)
Responses Re: Query times change by orders of magnitude as DB ages
List pgsql-performance
Tree view 
Hello,

2009/11/25 Richard Neill <rn214@cam.ac.uk>:

Also, if you find odd statistics of freshly analyzed table - try
increasing statistics target, using
ALTER TABLE .. ALTER COLUMN .. SET STATISTICS ...

If you're using defaults - it's again low for large tables. Start with
200, for example.

Best regards,
Sergey Aleynikov

pgsql-performance by date:

Previous
From: Sergey Aleynikov
Date:
Subject: Re: Query times change by orders of magnitude as DB ages
Next
From: Richard Neill
Date:
Subject: Re: Query times change by orders of magnitude as DB ages