Re: idea: global temp tables - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: idea: global temp tables
Date
Msg-id 49F8767B.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: idea: global temp tables  (Greg Stark <stark@enterprisedb.com>)
List pgsql-hackers
Greg Stark <stark@enterprisedb.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.
-Kevin


pgsql-hackers by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Creating a tablespace directory in recovery
Next
From: "Kevin Grittner"
Date:
Subject: Re: idea: global temp tables