Postgres Pro
Downloads
Home   >   mailing lists

Re: Hash aggregates blowing out memory - Mailing list pgsql-general

From Greg Stark
Subject Re: Hash aggregates blowing out memory
Date
Msg-id 87y8dboow0.fsf@stark.xeocode.com
Whole thread Raw
In response to Hash aggregates blowing out memory  (Mike Harding <mvh@ix.netcom.com>)
Responses Re: Hash aggregates blowing out memory  (Mike Harding <mvh@ix.netcom.com>)
List pgsql-general
Tree view 
Mike Harding <mvh@ix.netcom.com> writes:

> The following was run -immediately- after a vacuum.

You realize "vacuum" doesn't update the statistics, right?
You have to do "analyze" or "vacuum analyze" for that.


--
greg

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: row numbering
Next
From: Jeff Davis
Date:
Subject: Re: row numbering