pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dmitry Karasik <dmitry@karasik.eu.org>
To: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: VACUUM ANALYZE downgrades performance
Date: 03 Dec 2004 11:42:13 +0100
Message-ID: <84k6rz64u2.fsf@plab.ku.dk> (raw)
References: <84fz2ra2gy.fsf_-_@plab.ku.dk>
	<41AC94CC.1020602@idigx.com>
	<84wtw0d6q2.fsf@plab.ku.dk>
	<1102004718.99116.220.camel@home>

	Hi Rod!

 Thomas> Index scans are not always faster, and the planner/optimizer knows
 Thomas> this.  VACUUM ANALYZE is best run when a large proportion of data
 Thomas> has been updated/loaded or in the off hours to refresh the
 Thomas> statistics on large datasets.
 >>  While I agree that generally this is true, look how stupid this
 >> behavior looks in this particular case: A developer creates a table and
 >> index, knowing that the table will be large and will be intensively
 >> used. An admin runs 'VACUUM ANALYZE' when table is occasionally empty,
 >> and next, say, 1 day, until another 'VACUUM ANALYZE' starts, the index
 >> is simply not used! Sure you don't suppose to run 'VACUUM ANALYZE'
 >> every 5 minutes as a solution, right?

 Rod> You might want to try this on the next 8.0 beta to come out, or
 Rod> against CVS. Tom recently applied some changes which should mitigate
 Rod> this situation.

But this would affect only VACUUM, and not ANALYZE, right?

-- 
Sincerely,
	Dmitry Karasik

---
catpipe Systems ApS
*BSD solutions, consulting, development
www.catpipe.net
+45 7021 0050  




view thread (8+ messages)

Message-ID: <84k6rz64u2.fsf@plab.ku.dk>
Permalink:  ../84k6rz64u2.fsf@plab.ku.dk/
Also on:    postgresql.org/message-id/84k6rz64u2.fsf@plab.ku.dk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: dmitry@karasik.eu.org
  Subject: Re: VACUUM ANALYZE downgrades performance
  In-Reply-To: <84k6rz64u2.fsf@plab.ku.dk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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