Re: Query plan from hell

From: Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de>
To: PFC <lists(at)peufeu(dot)com>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Query plan from hell
Date: 2006-03-25 09:52:56
Message-ID: E304B561-3061-4479-B858-F0472D70D4A9@pharmaline.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tomaz Borstnar 2006-03-25 19:11:22 experiences needed - how does Itanium2/1.5GHz(4MB) compare to AMD and Intel CPUs as far as Postgresql is concerned
Previous Message K C Lau 2006-03-25 01:48:53 Re: limitation using LIKE on ANY(array)