| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | Chris Beecroft <CBeecroft(at)PrO-Unlimited(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Some queries starting to hang |
| Date: | 2006-06-21 07:49:15 |
| Message-ID: | 4498F9FB.6000505@logix-tt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi, Chris,
Chris Beecroft wrote:
> Query is now returning with results on our replicated database. Will
> vacuum analyze production now. So it seems to have done the trick. Now
> the question is has our auto vacuum failed or was not set up properly...
> A question for my IT people.
Most of the cases when we had database bloat despite running autovacuum,
it was due to a low free_space_map setting.
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | nicky | 2006-06-21 13:47:19 | Speeding up query, Joining 55mil and 43mil records. |
| Previous Message | Markus Schaber | 2006-06-21 07:31:22 | Re: scaling up postgres |