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

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group