| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | Kevin Grittner <Kgrittn(dot)CCAP(dot)Courts(at)wicourts(dot)gov>, Josh Berkus <josh(at)agliodbs(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: proposal: add columns created and altered topg_proc and pg_class |
| Date: | 2009-04-14 18:37:39 |
| Message-ID: | 603c8f070904141137u25d43e66s4076bf81d669a5e9@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Apr 14, 2009 at 2:13 PM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>> the timestamp column caused the copy to be about 11.3% larger
>
> Grabbed the wrong numbers. It's really 2.5%, but still....
Well, that's why Tom doesn't want to add it to pg_class. But putting
it in a separate table will have no impact on the speed of anything
except DDL statements, and even then it won't require copying the
whole table, so the performance impact will be pretty minimal, so I
think it should be all right.
...Robert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2009-04-14 18:44:50 | Re: Unicode string literals versus the world |
| Previous Message | Peter Eisentraut | 2009-04-14 18:37:20 | Re: Unicode string literals versus the world |