So, does anyone know which is best? Or are the performance differences so minute they'd only matter in extremely unique circumstances?
Regards,
Luke Gordon
PS I attempted to reply to the above thread, but downloading the "raw" link resulted in a basic auth challenge. If I entered my mailing list credentials, I'd just get rechallenged with basic auth...
You did not mention your PostgreSQL version or O/S, which would be helpful for future reference, but please take note.
Yes, PostgreSQL does have a mechanism to cluster the index, BUT... as stated in the docs, any subsequent insert or update will not be clustered, so a periodic
reCLUSTER is required to maintain it.
--
Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.