Hi,
We have still problems with our query time.
After restoring the database the query time is about one minute.
After an analyze the query time is about 70 minutes.
We could discover one table which cause the problem.
After analyzing this table the query time increases.
We have made an explain p
Hi,
We have a PostgreSQL DB, version 9.3 on a Suse Linux system.
We ran the update from postgresql 8.4 to 9.3.
After importing the database the query time of one sql query is about 30
sec.
After ANALYZE the DB the query time of this sql query is about 45 minutes.
We can see that after analyzing t
rina Koobs
Cc: pgsql-performance@postgresql.org; 'Sebastian Vogt'
Betreff: Re: [PERFORM] Increasing query time after updates
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 s
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 export, drop and import the DB the query time is again at a few
min
