Re: Reducing stats collection overhead
- From: Gregory Stark <stark(at)enterprisedb(dot)com>
- To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: <pgsql-hackers(at)postgreSQL(dot)org>
- Subject: Re: Reducing stats collection overhead
- Date: Sun, 29 Apr 2007 12:36:15 +0100
- Message-id: <87bqh7za34.fsf@oxford.xeocode.com> <text/plain>
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)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
Home |
Main Index |
Thread Index