Re: [PERFORM] unusual performance for vac following 8.2upgrade - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: [PERFORM] unusual performance for vac following 8.2upgrade
Date
Msg-id 20070112010918.GM10464@alvh.no-ip.org
Whole thread Raw
In response to Re: [PERFORM] unusual performance for vac following 8.2upgrade  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: [PERFORM] unusual performance for vac following 8.2upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Simon Riggs wrote:

> Temp relations still make pg_class entried don't they? Is that on the
> TODO list to change?

Yeah, and pg_attribute entries as well, which may be more problematic
because they are a lot.  Did we get rid of pg_attribute entries for
system attributes already?

Can we actually get rid of pg_class entries for temp tables.  Maybe
creating a "temp pg_class" which would be local to each session?  Heck,
it doesn't even have to be an actual table -- it just needs to be
somewhere from where we can load entries into the relcache.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [GENERAL] Checkpoint request failed on version 8.2.1.
Next
From: Neil Conway
Date:
Subject: NaN behavior