Re: 7.4beta2 vs 7.3.3 - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: 7.4beta2 vs 7.3.3
Date
Msg-id 3F6A25B4.4050902@bigfoot.com
Whole thread Raw
In response to Re: 7.4beta2 vs 7.3.3  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 7.4beta2 vs 7.3.3  (Gaetano Mendola <mendola@bigfoot.com>)
Re: 7.4beta2 vs 7.3.3  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 
> Hm, it sure looks to be exactly the same plan.  The performance
> difference seems to be just that the seqscans are faster.  I surmise
> that in the 7.3 database you had a lot of dead rows, or at least a lot
> of free space.  Possibly you need to vacuum more often to keep down the
> amount of junk in the tables.

The two databases were created from scratch and the first
operation on it ( after a vacuum analyze ) was just that query.

I will try to pump up the statistic target.


Regards
Gaetano Mendola



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Memory buffer alignment
Next
From: Hiroshi Inoue
Date:
Subject: Re: Killing the backend to cancel a long waiting query