Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump order of rows - Mailing list pgsql-general

From Filip Rembiałkowski
Subject Re: pg_dump order of rows
Date
Msg-id AANLkTi=Y7XKDmpGWuDvB=sJ7fmgS9WPHc6uq4GbToAob@mail.gmail.com
Whole thread Raw
In response to pg_dump order of rows  (jan <jan@dafuer.de>)
Responses Re: pg_dump order of rows  (Jan Kesten <jan@dafuer.de>)
List pgsql-general
Tree view
2010/12/11 jan <jan@dafuer.de>
we are seeking for a solution to make the dumop (e.g. the backup) more random

Can you please explain why? ( just curious, this seems a very strange requirement )


you _could_ _try_ to use postgres feature of synchronised seqscans to achieve this, but I'm not sure if it will work.
(after a minute of googling ... no it will not work - http://archives.postgresql.org/pgsql-committers/2008-01/msg00358.php )


cheers,
Filip

pgsql-general by date:

Previous
From: c k
Date:
Subject: Re: Asynchronous query execution
Next
From: Yeb Havinga
Date:
Subject: Re: GiST indexing question