"Foster, Kristian B (HSC)" <kristian-fos...@ouhsc.edu> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance