On 01/20/2014 05:55 AM, ARCEnergo wrote:
> Time: 1.211 ms
>| Physical | Virtaul
> --
> from PC "Total runtime"| 0.05x ms | 0.05x ms
> --
> from PC timing | 0
On 21/01/14 21:45, Mark Kirkwood wrote:
On 21/01/14 21:37, Katharina Koobs wrote:
Dear Heikki,
thank you for your valuable feedback. Regarding your questions: It
gradually slower every day. The database size is increasing only
slightly over time.
I will try your hint regarding CLUSTERING. The d
Hi,
On 21 Leden 2014, 7:26, Katharina Koobs wrote:
> Hi,
>
> We have a PostgreSQL DB, version 8.4 on a Suse Linux system.
> Every night a script runs with several updates and inserts. The query time
> at day increases after
> approximately 3 weeks from a few minutes to about an hour.
> After expor
On 21/01/14 21:37, Katharina Koobs wrote:
Dear Heikki,
thank you for your valuable feedback. Regarding your questions: It
gradually slower every day. The database size is increasing only
slightly over time.
I will try your hint regarding CLUSTERING. The difference in effect of
VACUUM FULL in ver
Dear Heikki,
thank you for your valuable feedback. Regarding your questions: It
gradually slower every day. The database size is increasing only
slightly over time.
I will try your hint regarding CLUSTERING. The difference in effect of
VACUUM FULL in version 9.0 sounds very interesting. I will
On 01/21/2014 08:26 AM, Katharina Koobs wrote:
Hi,
We have a PostgreSQL DB, version 8.4 on a Suse Linux system.
Every night a script runs with several updates and inserts. The query time
at day increases after
approximately 3 weeks from a few minutes to about an hour.
Does it get gradually slo
