Re: ANALYZE and index/stats degradation - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: ANALYZE and index/stats degradation
Date
Msg-id 87tzsm4yyn.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: ANALYZE and index/stats degradation  ("Jeroen T. Vermeulen" <jtv@xs4all.nl>)
Responses Re: ANALYZE and index/stats degradation  ("Jeroen T. Vermeulen" <jtv@xs4all.nl>)
List pgsql-hackers
"Jeroen T. Vermeulen" <jtv@xs4all.nl> writes:

> Actually, come to think of it, I don't think I'd want any vacuums at all
> on this particular table.  Just the analyze on the primary key, no
> vacuums, no statistics on anything else.  Unfortunately it's not just one
> table, but a set of tables that can be created dynamically.  I could
> change that, but in this particular case I don't think I should.

The way you described it there were records being inserted and later deleted.
Why wouldn't you need vacuums?

Or are all the records eventually deleted and then the table truncated or
dropped before the next batch of inserts?

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: "Jeroen T. Vermeulen"
Date:
Subject: Re: ANALYZE and index/stats degradation
Next
From: "Simon Riggs"
Date:
Subject: Re: Configurable Additional Stats