From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Alessio Bragadini <alessio(at)albourne(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Changing Column Order (Was Re: MySQL vs PostgreSQL.) |
Date: | 2002-10-14 15:04:07 |
Message-ID: | 200210141504.g9EF47W09439@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-jdbc |
Alessio Bragadini wrote:
> On Sat, 2002-10-12 at 11:37, Gavin Sherry wrote:
>
> > I cannot think of any reason why changing column order should be
> > implemented in Postgres. Seems like a waste of time/more code bloat for
> > something which is strictly asthetic.
> >
> > Regardless, I do have collegues/clients who ask when such a feature will
> > be implemented. Why is this useful?
>
> Has column ordering any effect on the physical tuple disposition? I've
> heard discussions about keeping fixed-size fields at the beginning of
> the tuple and similar.
>
> Sorry for the lame question. :-)
Yes, column ordering matches physical column ordering in the file, and
yes, there is a small penalty for accessing any columns after the first
variable-length column (pg_type.typlen < 0). CHAR() used to be a fixed
length column, but with TOAST (large offline storage) it became variable
length too. I don't think there is much of a performance hit, though.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2002-10-14 15:15:59 | Re: Changing Column Order (Was Re: MySQL vs PostgreSQL.) |
Previous Message | Darko Prenosil | 2002-10-14 14:22:54 | Re: Nuance speech recognition server and Postgres |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2002-10-14 15:15:59 | Re: Changing Column Order (Was Re: MySQL vs PostgreSQL.) |
Previous Message | Bruce Momjian | 2002-10-14 14:49:26 | Re: droped out precise time calculations in src/interfaces/libpq/fe-connect.c |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2002-10-14 15:15:59 | Re: Changing Column Order (Was Re: MySQL vs PostgreSQL.) |
Previous Message | Tom Lane | 2002-10-14 14:11:05 | Re: [GENERAL] Prepared statement performance... |