| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)postgresql(dot)org, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
| Subject: | Re: profiling connection overhead |
| Date: | 2010-11-29 04:51:43 |
| Message-ID: | 2532.1291006303@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Robert Haas <robertmhaas(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joachim Wieland | 2010-11-29 05:11:46 | Re: directory archive format for pg_dump |
| Previous Message | KaiGai Kohei | 2010-11-29 03:10:26 | Re: [GENERAL] column-level update privs + lock table |