Re: Reducing stats collection overhead - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Reducing stats collection overhead
Date
Msg-id 20070518131218.GA5639@alvh.no-ip.org
Whole thread Raw
In response to Reducing stats collection overhead  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Reducing stats collection overhead
List pgsql-hackers
Tom Lane wrote:
> Arjen van der Meijden told me that according to the tweakers.net
> benchmark, HEAD is noticeably slower than 8.2.4, and I soon confirmed
> here that for small SELECT queries issued as separate transactions,
> there's a significant difference.  I think much of the difference stems
> from the fact that we now have stats_row_level ON by default, and so
> every transaction sends a stats message that wasn't there by default
> in 8.2.  When you're doing a few thousand transactions per second
> (not hard for small read-only queries) that adds up.

So, did this patch make the performance problem go away?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: [GSOC] - I ntegrity check algorithm for data files
Next
From: Zdenek Kotala
Date:
Subject: Re: Lack of urgency in 8.3 reviewing