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

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?

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

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

michi wrote: >Does PostgreSQL store records sorted by primary key? Only after you cluster the table: Rainer ---(end of broadcast)--- TIP 6: explain analyze is your friend