Re: [PERFORM] Cleaning up indexes

2004-09-25 Thread Bruce Momjian
Martin Foster wrote: My database was converted from MySQL a while back and has maintained all of the indexes which were previously used. Tt the time however, there were limitations on the way PostgreSQL handled the indexes compared to MySQL. Meaning that under MySQL, it would make use

[PERFORM] Cleaning up indexes

2004-09-23 Thread Martin Foster
My database was converted from MySQL a while back and has maintained all of the indexes which were previously used. Tt the time however, there were limitations on the way PostgreSQL handled the indexes compared to MySQL. Meaning that under MySQL, it would make use of a multi-column index

Re: [PERFORM] Cleaning up indexes

2004-09-23 Thread Gregory S. Williamson
/2004 3:16 PM To: [EMAIL PROTECTED] Cc: Subject:[PERFORM] Cleaning up indexes My database was converted from MySQL a while back and has maintained all of the indexes which were previously used. Tt the time however, there were limitations on the way PostgreSQL handled the indexes