Search Postgresql Archives

Re: PostgreSQL Storage: Sorted by Primary Key?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: PostgreSQL Storage: Sorted by Primary Key?
From: Rainer Bauer <usenet@xxxxxxxxxx>
Date: Sun, 07 Oct 2007 09:33:12 +0200
Organization: Hub.Org Networking Services

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- PostgreSQL Storage: Sorted by Primary Key?
  - From: michi

Prev by Date: Re: Foreign Key for PHP serialized data - possible?
Next by Date: Re: windows and pg 8.2 (change database to another server)
Previous by thread: PostgreSQL Storage: Sorted by Primary Key?
Next by thread: Re: PostgreSQL Storage: Sorted by Primary Key?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux