Re: slow seqscan after vacuum analize

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Edoardo Ceccarelli <eddy(at)axa(dot)it>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: slow seqscan after vacuum analize
Date: 2004-02-04 21:45:01
Message-ID: Pine.LNX.4.33.0402041444060.29742-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 4 Feb 2004, Edoardo Ceccarelli wrote:

> I have a simple query that scans each record, like this: select * from utente where
> luogorilasciodoc='ciao'
> The execution time BEFORE vacuum is: 1203ms The execution time AFTER vacuum is: 6656ms
> !!!
> What is going on? Thought that one vaccum the db to get better performance!
>
> PostgreSQL Ver. 7.3.4 on linux

Can you show us the output of "explain analyze select * from ..." for both
before and after a vacuum? i.e. with the difference in performance. If
not, just an explain analyze of the way it runs now might be enough.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Harley Milne 2004-02-04 22:04:26 Windows Installer with Configuration Instructions
Previous Message Edoardo 2004-02-04 21:24:20 slow seqscan after vacuum analize