Re: slow query - Mailing list pgsql-sql

From Tom Lane
Subject Re: slow query
Date
Msg-id 19565.1175752023@sss.pgh.pa.us
Whole thread Raw
In response to Re: slow query  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: slow query  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-sql
"A. Kretschmer" <andreas.kretschmer@schollglas.com> writes:
> am  Thu, dem 05.04.2007, um  1:27:25 -0400 mailte Tom Lane folgendes:
>> I'm betting the problem is poor vacuuming practice leading to lots of
>> dead space.  There's no way it takes 22 sec to read 10 rows if the
>> table is reasonably dense.

> This was my first thought, but:

> ,----[  Quote  ]
> | I've tried
> | vacuuming this table many time
> `----

[ shrug... ]  If the damage is already done, lazy VACUUM won't fix it.
        regards, tom lane


pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: slow query
Next
From: "Shavonne Marietta Wijesinghe"
Date:
Subject: Insert only if not found