Re: Equivalent praxis to CLUSTERED INDEX?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>, "J(dot) Andrew Rogers" <jrogers(at)neopolitan(dot)com>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: <pgsql-performance(at)postgresql(dot)org>, <mischa(dot)sandberg(at)telus(dot)net>
Subject: Re: Equivalent praxis to CLUSTERED INDEX?
Date: 2004-08-26 19:48:25
Message-ID: 200408261248.25661.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Magnus,

> IIRC, SQL Server always creates clustered indexes by default for primary
> keys.

I think that's a per-database setting; certainly the ones I admin do not.

However, since SQL Server orders its data pages, those data pages tend to be
in the order of the primary key regardless if there is no clustered index.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Doug McNaught 2004-08-26 19:54:04 Re: Anyone familiar with Apple Xserve RAID
Previous Message Hervé Piedvache 2004-08-26 19:30:40 Re: TSearch2 and optimisation ...