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

From Gregory Stark
Subject Re: Reducing stats collection overhead
Date
Msg-id 87bqh7za34.fsf@oxford.xeocode.com
Whole thread Raw
In response to Reducing stats collection overhead  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Reducing stats collection overhead  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> So I think that complicating the design with, say, a timeout counter to
> force out the stats after a sleep interval is not necessary. Doing so would
> add a couple of kernel calls to every client interaction so I'd really
> rather avoid that.
>
> Any thoughts, better ideas?

If we want to have an idle_in_statement_timeout then we'll need to introduce a
select loop instead of just directly blocking on recv anyways. Does that mean
we may as well bite the bullet now?

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: Feature freeze progress report
Next
From: "Dawid Kuroczko"
Date:
Subject: Re: Feature freeze progress report