position in DDL of columns used in indexes

From: Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: position in DDL of columns used in indexes
Date: 2009-10-08 13:54:07
Message-ID: ba2ef1d83616ef847f9a80ddc980bec1@intermodalsoftwaresolutions.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

In other SQL engines that I've used, it is recommended that the columns that
are used in various indexes be placed at the beginning of a row since at
some point (depending on the engine and/or pagesize) wide rows could end up
on other pages.  From a performance standpoint on large tables this makes a
big difference.  Is the same true with Postgres.  Should I try and make sure
that my indexes fit in the first 8192 bytes?

 

Bes Regards

--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2009-10-08 14:36:50 Re: position in DDL of columns used in indexes
Previous Message Matthew Wakeling 2009-10-08 13:40:53 Re: Best suiting OS