Re: [GENERAL] PostgreSQL Storage: Sorted by Primary Key?

[michi]

Hi Rainer and Christopher,

Thank you for your quick responses. I didn't know about CLUSTER
command. It seems like just what I needed!

Thanks!
--Michi


---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] PostgreSQL Storage: Sorted by Primary Key?

[Rainer Bauer]

michi wrote:

Does PostgreSQL store records sorted by primary key?

Only after you cluster the table:
http://www.postgresql.org/docs/8.2/static/sql-cluster.html

Rainer

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] PostgreSQL Storage: Sorted by Primary Key?

[Christopher Browne]

After takin a swig o' Arrakan spice grog, michi [EMAIL PROTECTED] belched out:
 Does PostgreSQL store records sorted by primary key?

No.  It initially stores tuples based on the order in which they are
inserted.

Behaviour changes later when a table has free space due to deleted
tuples.
-- 
let name=cbbrowne and tld=gmail.com in name ^ @ ^ tld;;
http://cbbrowne.com/info/emacs.html
Who is General Failure and why is he reading my hard disk? 
-- [EMAIL PROTECTED], Felix von Leitner

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/