Postgres Pro
Downloads
Home   >   mailing lists

Re: Query runs 38 seconds for small database! - Mailing list pgsql-performance

From Andrus
Subject Re: Query runs 38 seconds for small database!
Date
Msg-id e3ntpp$qqg$1@news.hub.org
Whole thread Raw
In response to Query runs 38 seconds for small database!  ("Andrus" <eetasoft@online.ee>)
Responses Re: Query runs 38 seconds for small database!
List pgsql-performance
Tree view 
> The default autovac thresholds are not very aggressive; this table was
> probably not large enough to get selected for analysis.

Tom,

thank you.
Excellent.

Andrus.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query runs 38 seconds for small database!
Next
From: "Jim C. Nasby"
Date:
Subject: Re: extremely slow when execute select/delete for certain