On Fri, Sep 16, 2011 at 3:00 AM, Merlin Moncure <mmonc...@gmail.com> wrote: > > c:\Program Files\PostgreSQL\9.0\data>dir/s | grep 16525 > 09/15/2011 07:46 PM 224,641,024 16525 > > c:\Program Files\PostgreSQL\9.0\data>dir/s | grep 16526 > 09/15/2011 07:49 PM 268,451,840 16526
That's not surprising at all. Hashes need to be bigger to avoid collisions. What's more interesting than index creation, is index maintainance and access costs. In my experience, btree beats hash. I haven't tried with 9.1, though. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
