"Thorne, Francis" <thornef@xxxxxxxxxxxxxx> writes: > The problem I have is that it takes around 15 mins to insert the data > into the table which is a massive improvement from the old server but it > then takes 40 mins to create two indexes one 1GB index and another that > is a 2GB index this is considerably slower than on the older server. If these are indexes on textual data, maybe you accidentally changed from C locale to some other locale. All the other ones are slower to compare text strings, sometimes massively so. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
