pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
slow seqscan after vacuum analize
4+ messages / 4 participants
[nested] [flat]

* slow seqscan after vacuum analize
@ 2004-02-04 20:35  Edoardo Ceccarelli <eddy@expot.it>
  0 siblings, 0 replies; 4+ messages in thread

From: Edoardo Ceccarelli @ 2004-02-04 20:35 UTC (permalink / raw)
  To: pgsql-admin

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

Thank you
Edoardo




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* slow seqscan after vacuum analize
@ 2004-02-04 21:23  Edoardo Ceccarelli <eddy@axa.it>
  0 siblings, 1 reply; 4+ messages in thread

From: Edoardo Ceccarelli @ 2004-02-04 21:23 UTC (permalink / raw)
  To: pgsql-admin

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

Thank you
Edoardo




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* slow seqscan after vacuum analize
@ 2004-02-04 21:24  Edoardo <eddy@axa.it>
  0 siblings, 0 replies; 4+ messages in thread

From: eddy@axa.it @ 2004-02-04 21:24 UTC (permalink / raw)
  To: pgsql-admin

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

Thank you
Edoardo



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: slow seqscan after vacuum analize
@ 2004-02-04 21:45  scott.marlowe <scott.marlowe@ihs.com>
  parent: Edoardo Ceccarelli <eddy@axa.it>
  0 siblings, 0 replies; 4+ messages in thread

From: scott.marlowe @ 2004-02-04 21:45 UTC (permalink / raw)
  To: Edoardo Ceccarelli <eddy@axa.it>; +Cc: 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.




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-02-04 21:45 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-04 20:35 slow seqscan after vacuum analize Edoardo Ceccarelli <eddy@expot.it>
2004-02-04 21:23 slow seqscan after vacuum analize Edoardo Ceccarelli <eddy@axa.it>
2004-02-04 21:45 ` scott.marlowe <scott.marlowe@ihs.com>
2004-02-04 21:24 slow seqscan after vacuum analize Edoardo <eddy@axa.it>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox