Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group