From: | Ghislain ROUVIGNAC <ghr(at)sylob(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Slow queries after vacuum analyze |
Date: | 2012-12-13 17:10:04 |
Message-ID: | CAH12p1B-11ner0AdRAXe4AZu2mO5f9N9OF-drF0LzS+2fJ1ASQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hello,
I have a customer that experience a strange behaviour related to statictics.
Threre is a vacuum analyze planned during the night.
The morning, 1 day out of 2, there are some extremely slow queries.
Those queries lasts more than 5 minutes (never waited more and cancelled
them) whereas when everything is OK they last less than 300ms.
In order to resolve this i have to execute a least one analyze, sometimes
more.
My Configuration:
Windows
PostgreSQL 8.4.8
default_statistics_target = 100
In addition to an increase for shared_buffers, work_mem, ..., i changed
the default_statistics_target to 500 with no effect.
It was even worse as i never managed to get rid of the slow queries after
running many analyze.
So i fell back to default_statistics_target=100 in order to get rid of
those slow queries.
I have no idea of what i can do to solve this issue.
Any help would be greatly appreciated.
Cordialement,
*Ghislain ROUVIGNAC*
Ingénieur R&D
ghr(at)sylob(dot)com
7 rue Marcel Dassault - Z.A. La Mouline - 81990 Cambon d'Albi - FRANCE
Tel : 05 63 53 08 18 - Fax : 05 63 53 07 42 - www.sylob.com
Support : 05 63 53 78 35 - support(at)sylob(dot)com
Entreprise certifiée ISO 9001 version 2008 par Bureau Veritas.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-12-13 17:12:50 | Re: Limit & offset effect on query plans |
Previous Message | Kevin Grittner | 2012-12-13 17:07:00 | Re: Limit & offset effect on query plans |