Re: profiling connection overhead - Mailing list pgsql-hackers

From Tom Lane
Subject Re: profiling connection overhead
Date
Msg-id 2532.1291006303@sss.pgh.pa.us
Whole thread Raw
In response to Re: profiling connection overhead  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: profiling connection overhead
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> Yeah, very true.  What's a bit frustrating about the whole thing is
> that we spend a lot of time pulling data into the caches that's
> basically static and never likely to change anywhere, ever.

True.  I wonder if we could do something like the relcache init file
for the catcaches.

> Maybe we could speed things up a bit if we got rid of the pg_attribute
> entries for the system attributes (except OID).

I used to have high hopes for that idea, but the column privileges
patch broke it permanently.
        regards, tom lane


pgsql-hackers by date:

Previous
From: KaiGai Kohei
Date:
Subject: Re: [GENERAL] column-level update privs + lock table
Next
From: Joachim Wieland
Date:
Subject: Re: directory archive format for pg_dump