Re: [GENERAL] Benchmarks - Mailing list pgsql-general

From The Hermit Hacker
Subject Re: [GENERAL] Benchmarks
Date
Msg-id Pine.BSF.4.21.0001061352500.18498-100000@thelab.hub.org
Whole thread Raw
In response to Re: [GENERAL] Benchmarks  (Dustin Sallings <dustin@spy.net>)
Responses Re: [GENERAL] Benchmarks  (Dustin Sallings <dustin@spy.net>)
List pgsql-general
On Thu, 6 Jan 2000, Dustin Sallings wrote:

>     Untrue, vacuum is *extremely* important for updating statistics.
> If you have a lot of data in a table, and you have never vacuumed, you
> might as well not have any indices.  It'd be nice if you could seperate
> the stat update from the storage reclaim.  Actually, it'd be nice if you
> could reuse storage, so that an actual vacuum wouldn't be necessary unless
> you just wanted to free up disk space you might end up using again anyway.

Okay, my understanding is that a vacuum does a 'cleanup', while a vacuum
analyze does a cleanup *and* stats...



pgsql-general by date:

Previous
From: Dustin Sallings
Date:
Subject: Re: [GENERAL] Benchmarks
Next
From: Dustin Sallings
Date:
Subject: Re: [GENERAL] Benchmarks