position in DDL of columns used in indexes - Mailing list pgsql-performance

From Michael Gould
Subject position in DDL of columns used in indexes
Date
Msg-id ba2ef1d83616ef847f9a80ddc980bec1@intermodalsoftwaresolutions.net
Whole thread Raw
In response to Query logging time, not values  (Ludwik Dylag <ldylag@gmail.com>)
Responses Re: position in DDL of columns used in indexes
List 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

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: Best suiting OS
Next
From: Matthew Wakeling
Date:
Subject: Re: position in DDL of columns used in indexes