Postgres Pro
Downloads
Home   >   mailing lists

Re: quick question abt pg_dump and restore - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: quick question abt pg_dump and restore
Date
Msg-id 20080109163943.GB28750@crankycanuck.ca
Whole thread Raw
In response to Re: quick question abt pg_dump and restore  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Responses Re: quick question abt pg_dump and restore  ("Josh Harrison" <joshques@gmail.com>)
List pgsql-general
Tree view 
On Wed, Jan 09, 2008 at 05:28:15PM +0100, Ivan Sergio Borgonovo wrote:
> Does it make any sense *knowing* how the implementation works to load
> records in a table in a specific order to improve performances?

Well, this is more or less what CLUSTER does.  There are some cases where
happening to know about the order the table is in will yield happy effects,
yes.

A

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: count(*) and bad design was: Experiences with extensibility
Next
From: "Josh Harrison"
Date:
Subject: Re: quick question abt pg_dump and restore