Re: Query Time is Slow - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Query Time is Slow
Date
Msg-id 1360363559.52467.YahooMailNeo@web162904.mail.bf1.yahoo.com
Whole thread Raw
In response to Query Time is Slow  ("Foster, Kristian B (HSC)" <kristian-foster@ouhsc.edu>)
List pgsql-performance
"Foster, Kristian B (HSC)" <kristian-foster@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


pgsql-performance by date:

Previous
From: "Foster, Kristian B (HSC)"
Date:
Subject: Query Time is Slow
Next
From: Johnny Tan
Date:
Subject: Re: postgresql.conf recommendations