Postgres Pro
Downloads
Home   >   mailing lists

Re: Query plan from hell - Mailing list pgsql-performance

From Guido Neitzer
Subject Re: Query plan from hell
Date
Msg-id E304B561-3061-4479-B858-F0472D70D4A9@pharmaline.de
Whole thread Raw
In response to Query plan from hell  (PFC <lists@peufeu.com>)
List pgsql-performance
Tree view 
On 24.03.2006, at 23:54 Uhr, PFC wrote:

>     bookmark_delta contains very few rows but is inserted/deleted very
> often... the effect is spectacular !
>     I guess I'll have to vacuum analyze this table every minute...

What about using autovacuum?

cug

--
PharmaLine, Essen, GERMANY
Software and Database Development
Attachment

pgsql-performance by date:

Previous
From: K C Lau
Date:
Subject: Re: limitation using LIKE on ANY(array)
Next
From: Ruben Rubio Rey
Date:
Subject: Re: Array performance