Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: column ordering, was Re: [PATCHES] Enums patch v2


  • From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
  • To: Andrew Dunstan <andrew(at)dunslane(dot)net>
  • Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org
  • Subject: Re: column ordering, was Re: [PATCHES] Enums patch v2
  • Date: Tue, 19 Dec 2006 17:25:04 +0100
  • Message-id: <20061219162504.GC21385@svana.org> <text/plain>

On Tue, Dec 19, 2006 at 10:48:41AM -0500, Andrew Dunstan wrote:
> Sure, but the only sane way I can think of to do that would be have 
> separate logical and physical orderings, with a map between the two. I 
> guess we'd need to see what the potential space savings would be and 
> establish what the processing overhead would be, before considering it. 
> One side advantage would be that it would allow us to do the often 
> requested "add column at position x".

A patch to allow seperate physical and logical orderings was submitted
and rejected. Unless something has changed on that front, any
discussion in this direction isn't really useful.

Once this is possible it would allow a lot of simple savings. For
example, shifting all fixed width fields to the front means they can
all be accessed without looping through the previous columns, for
example.

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment: signature.asc
Description: Digital signature



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group