| From: | Curt Sampson <cjs(at)cynic(dot)net> |
|---|---|
| To: | Daniel Kalchev <daniel(at)digsys(dot)bg> |
| Cc: | Hannu Krosing <hannu(at)tm(dot)ee>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Dann Corbit <DCorbit(at)connx(dot)com>, Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-performance(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] Terrible performance on wide selects |
| Date: | 2003-01-23 15:50:27 |
| Message-ID: | Pine.NEB.4.51.0301240048580.547@angelic.cynic.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On Thu, 23 Jan 2003, Daniel Kalchev wrote:
> Does this mean, that constructing tables where fixed length fields are
> 'before' variable lenght fields and 'possibly null' fields might increase
> performance?
This, I believe, is why DB2 always puts (in physical storage) all of the
fixed-length fields before the variable-length fields.
cjs
--
Curt Sampson <cjs(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ross J. Reedstrom | 2003-01-23 17:26:54 | Re: Call for objections: put back OIDs in CREATE TABLE AS/SELECT INTO |
| Previous Message | Curt Sampson | 2003-01-23 15:42:15 | Re: Options for growth |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chantal Ackermann | 2003-01-23 15:52:51 | Re: [PERFORM] optimizing query |
| Previous Message | John Lange | 2003-01-23 15:36:11 | Re: Query plan and Inheritance. Weird behavior |