Creating indexes for PostgreSQL database
Posted: Mon Jan 21, 2008 6:19 pm
Hi All
I read in the manuals and web about applying indexes to tables for the PostgreSQL db V8.2.5. But I still can't seem to find an overview for that.
Is there a tool which helps in creating indexes for tables? Or do I really have to create each index manually?
PostgreSQL doesn't create indexes for primary keys as Sybase does, is that assumption correct?
Best regards, Robert
I read in the manuals and web about applying indexes to tables for the PostgreSQL db V8.2.5. But I still can't seem to find an overview for that.
Is there a tool which helps in creating indexes for tables? Or do I really have to create each index manually?
PostgreSQL doesn't create indexes for primary keys as Sybase does, is that assumption correct?
Best regards, Robert