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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
