Re: Number of tables - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Number of tables
Date
Msg-id 4A925D960200002500029FD3@gw.wicourts.gov
Whole thread Raw
In response to Re: Number of tables  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
Greg Stark <gsstark@mit.edu> wrote:

> Creating new catalog entries for [temp tables] gives up -- what I
> think is the whole point of their design -- their lack of DDL
> overhead.

As long as we're brainstorming...  Would it make any sense for temp
tables to be created as in-memory tuplestores up to the point that we
hit the temp_buffers threshold?  Creating and deleting a whole set of
disk files per temp table is part of what makes them so heavy.
(There's still the issue of dealing with the catalogs, of course....)

-Kevin

pgsql-performance by date:

Previous
From: Gábor Farkas
Date:
Subject: postgresql uses Hash-join, i need Nested-loop
Next
From: Tom Lane
Date:
Subject: Re: postgresql uses Hash-join, i need Nested-loop