From: Kevin Grittner <kgrittn@ymail.com>
To: Foster, Kristian B \(HSC\) <kristian-foster@ouhsc.edu>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Query Time is Slow
Date: Fri, 8 Feb 2013 14:45:59 -0800 (PST)
Message-ID: <1360363559.52467.YahooMailNeo@web162904.mail.bf1.yahoo.com> (raw)
In-Reply-To: <7DF4C4113E7CAD4D90A978233833EFE803A6180921@TESLA.hsc.net.ou.edu>
References: <7DF4C4113E7CAD4D90A978233833EFE803A6180921@TESLA.hsc.net.ou.edu>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kgrittn@ymail.com, kristian-foster@ouhsc.edu
Subject: Re: Query Time is Slow
In-Reply-To: <1360363559.52467.YahooMailNeo@web162904.mail.bf1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox