Re: ANALYZE and index/stats degradation

From: "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl>
To: "Gregory Stark" <stark(at)enterprisedb(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ANALYZE and index/stats degradation
Date: 2007-07-02 16:33:08
Message-ID: 15164.125.24.240.137.1183393988.squirrel@webmail.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, July 2, 2007 22:17, Gregory Stark wrote:

> 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?

In a nuthshell, yes. The problem is I can't delete them all at once; it
happens in batches, and that means that stats degrade in the meantime.

Jeroen

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-07-02 16:41:12 Re: Configurable Additional Stats
Previous Message Tom Lane 2007-07-02 16:30:37 Re: Postgresql.conf cleanup