Re: pg_dump order of rows

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: "Jan Kesten" <jan(at)dafuer(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump order of rows
Date: 2010-12-13 14:49:09
Message-ID: C4DAC901169B624F933534A26ED7DF31034BB9A0@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I'm not aware of any database where I can influence the on-disk order directly

Hello,

You may want to export your main tables using COPY instead of pg_dump.

Doing this, you could disorder your tables, e.g. with hashtext:

COPY (select * from foo order by hashtext(some_col) )TO <file>

Getting a consistent dump of all your data may be an issue thought...

regards,

Marc Mamin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message paulo matadr 2010-12-13 15:00:23 Cluster with LATIN1 and UTF-8
Previous Message Hampus Wessman 2010-12-13 14:48:47 Re: pg_dump order of rows