SEO

#1 (**permalink**) 04-09-2008, 11:05 PM

Does PostgreSQL store records sorted by primary key?

#2 (**permalink**) 04-09-2008, 11:05 PM

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

#3 (**permalink**) 04-09-2008, 11:05 PM

After takin a swig o' Arrakan spice grog, michi <mutsuzaki@gmail.com> 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?"
-- <leitner@inf.fu-berlin.de>, Felix von Leitner

#4 (**permalink**) 04-09-2008, 11:05 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

PostgreSQL Storage: Sorted by Primary Key?