Re: Query runs 38 seconds for small database!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: Query runs 38 seconds for small database!
From: "Andrus" <eetasoft@xxxxxxxxx>
Date: Mon, 8 May 2006 20:03:38 +0300
Organization: Hub.Org Networking Services
References: <e3n8at$1f7i$1@xxxxxxxxxxxx> <26838.1147099614@xxxxxxxxxxxxx> <e3nqv9$30v0$1@xxxxxxxxxxxx> <27599.1147105626@xxxxxxxxxxxxx>

> 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.

Follow-Ups:
- Re: Query runs 38 seconds for small database!
  - From: Jim C. Nasby

References:
- Query runs 38 seconds for small database!
  - From: Andrus
- Re: Query runs 38 seconds for small database!
  - From: Tom Lane
- Re: Query runs 38 seconds for small database!
  - From: Andrus
- Re: Query runs 38 seconds for small database!
  - From: Tom Lane

Prev by Date: Re: Query runs 38 seconds for small database!
Next by Date: Re: extremely slow when execute select/delete for certain
Previous by thread: Re: Query runs 38 seconds for small database!
Next by thread: Re: Query runs 38 seconds for small database!
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux