"Thorne, Francis" <thornef@cromwell.co.uk> 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