"Foster, Kristian B (HSC)" <kristian-foster@xxxxxxxxx> wrote: > Currently the queries are running about 4x slower on postgres than > sql server. Is there any settings I need to check? Your best bet would be to pick one query and follow the steps recommended here: http://wiki.postgresql.org/wiki/SlowQueryQuestions That is likely to yield good advice which will help all queries, but if anything remains slow after the first one is sorted out, pick another. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance