Re: [GENERAL] pg_dump order of rows

2010-12-13 Thread Hampus Wessman
4:53, Vick Khera wrote: On Mon, Dec 13, 2010 at 4:26 AM, Hampus Wessman wrote: CLUSTER should be able to do that for you. See http://www.postgresql.org/docs/9.0/static/sql-cluster.html. That's the exact opposite of what he wished to accomplish. The only thing I can suggest is to do

Re: [GENERAL] pg_dump order of rows

2010-12-13 Thread Hampus Wessman
On 2010-12-13 09:12, Jan Kesten wrote: I'm not aware of any database where I can influence the on-disk order directly, but there may be some hints I'm probably missing (even a vacuum full will only compact the datafile as far as I know but not reoder it accoring to an index or something). CLUSTE