Re: Performace question

On Wed, Oct 29, 2003 at 05:42:30PM +0100, Lada 'Ray' Lostak wrote:

> >Secondly, the queries that are varying so much, can you post the EXPLAIN
> >ANALYZE output so we can see what is actually going on.
> Thx, ANALYZE was good idea. Here it comes - right now, there is index on
> 'cluster' (BTREE) @ dtditems. But it was not used - I guess because reading
> & seraching will cost more than pure seq scan on 'few' items...

Hmm... have you tried running VACUUM periodically?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"En las profundidades de nuestro inconsciente hay una obsesiva necesidad
de un universo lógico y coherente. Pero el universo real se halla siempre
un paso más allá de la lógica" (Irulan)