Re: quick question abt pg_dump and restore

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: quick question abt pg_dump and restore
Date: 2008-01-09 16:39:43
Message-ID: 20080109163943.GB28750@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Harrison 2008-01-09 16:46:14 Re: quick question abt pg_dump and restore
Previous Message Scott Marlowe 2008-01-09 16:36:32 Re: count(*) and bad design was: Experiences with extensibility