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).
CLUSTER should be able to do that for you. See
http://www.postgresql.org/docs/9.0/static/sql-cluster.html.
/ Hampus