Greg Stark <stark(at)enterprisedb(dot)com> wrote:
>> creating/deleting a few dozen rows in the system catalogs shouldn't
>> really be something that autovacuum can't deal with.
> I don't see why it's limited to a few dozen rows. Moderately busy
> web sites these days count their traffic in hundreds of page views
> per second.
Sure. We're there. And many of those hits run ten to twenty queries.
We'd be insane to get a new connection for each one rather than use a
connection pool; and this overhead only occurs once per referenced
table per connection.
In response to
pgsql-hackers by date
|Next:||From: David Fetter||Date: 2009-04-29 21:48:57|
|Subject: Re: Throw some low-level C scutwork at me|
|Previous:||From: Greg Stark||Date: 2009-04-29 20:39:03|
|Subject: Re: idea: global temp tables|