Postgres Pro
Downloads
Home   >   mailing lists

Re: Seeking reason behind performance gain in 12 with HashAggregate - Mailing list pgsql-performance

From Tomas Vondra
Subject Re: Seeking reason behind performance gain in 12 with HashAggregate
Date
Msg-id 20200113211156.ubllzwzisdyljox5@development
Whole thread Raw
In response to Re: Seeking reason behind performance gain in 12 with HashAggregate  (Shira Bezalel <shira@sfei.org>)
Responses Re: Seeking reason behind performance gain in 12 with HashAggregate
List pgsql-performance
Tree view 
On Mon, Jan 13, 2020 at 12:44:14PM -0800, Shira Bezalel wrote:
>Hi Michael,
>
>I appreciate your question. I ran a vacuum analyze on the 9.6 table and it
>yielded no difference. Same number of buffers were read, same query plan.
>

VACUUM ANALYZE won't shrink the table - the number of buffers will be
exactly the same. You need to do VACUUM FULL, but be careful as that
acquires exclusive lock on the table.


regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-performance by date:

Previous
From: Shira Bezalel
Date:
Subject: Re: Seeking reason behind performance gain in 12 with HashAggregate
Next
From: Shira Bezalel
Date:
Subject: Re: Seeking reason behind performance gain in 12 with HashAggregate