Re: PostgreSQL Storage: Sorted by Primary Key?

From: Rainer Bauer <usenet(at)munnin(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL Storage: Sorted by Primary Key?
Date: 2007-10-07 07:33:12
Message-ID: eq2hg3t8lpvl0l2ee7o12elcp1jdslifr4@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Terry Yapt 2007-10-07 08:40:31 Re: windows and pg 8.2 (change database to another server)
Previous Message michi 2007-10-07 05:34:17 PostgreSQL Storage: Sorted by Primary Key?