Re: Stats collector performance improvement

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Fuhr <mike(at)fuhr(dot)org>, Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, Carlos Benkendorf <carlosbenkendorf(at)yahoo(dot)com(dot)br>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Stats collector performance improvement
Date: 2006-01-03 09:54:57
Message-ID: 1136282097.5052.117.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches pgsql-performance

On Mon, 2006-01-02 at 13:40 -0500, Bruce Momjian wrote:

> This change reduced the stats_command_string time from 5.5 to 3.9, which
> is closer to the 3.5 seconds with stats_command_string off.

Excellent work, port specific or not.

Best Regards, Simon Riggs

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2006-01-03 13:08:46 Re: WAL bypass for INSERT, UPDATE and DELETE?
Previous Message Simon Riggs 2006-01-03 09:40:53 Re: Stats collector performance improvement

Browse pgsql-patches by date

  From Date Subject
Next Message Jim C. Nasby 2006-01-03 16:35:56 Re: Stats collector performance improvement
Previous Message Simon Riggs 2006-01-03 09:40:53 Re: Stats collector performance improvement

Browse pgsql-performance by date

  From Date Subject
Next Message Jens-Wolfhard Schicke 2006-01-03 15:08:48 Materialize Subplan and push into inner index conditions
Previous Message Simon Riggs 2006-01-03 09:40:53 Re: Stats collector performance improvement