Re: Query runs 38 seconds for small database!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrus" <eetasoft(at)online(dot)ee>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query runs 38 seconds for small database!
Date: 2006-05-08 16:27:06
Message-ID: 27599.1147105626@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Andrus" <eetasoft(at)online(dot)ee> writes:
> I see autovacuum: processing database "mydb" messages in log file and I have
> stats_start_collector = on
> stats_row_level = on
> in config file. Why statistics was out-of-date ?

The default autovac thresholds are not very aggressive; this table was
probably not large enough to get selected for analysis.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrus 2006-05-08 17:03:38 Re: Query runs 38 seconds for small database!
Previous Message Andrus 2006-05-08 16:15:36 Re: Query runs 38 seconds for small database!