DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com;
	h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=Y7Wh0Qx+v6QycLYo1h6cyZf8jHWa35rWlQRHnxWD/gI4PR16AF4Ir34Lfe3uioOWb98OOGJJV3x7lt9tLuwjNvPZRuriMcAT0WWSUmfaBCf6Qosfqs2xIgE2THwr1akcxBDwnjSuzl0g/aMhZmf+iWuEnQcxlaz7j+feOkLWK6k=;
References: <7DF4C4113E7CAD4D90A978233833EFE803A6180921@TESLA.hsc.net.ou.edu>
Message-ID: <1360363559.52467.YahooMailNeo@web162904.mail.bf1.yahoo.com>
Date: Fri, 8 Feb 2013 14:45:59 -0800 (PST)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: Query Time is Slow
To: "Foster, Kristian B \(HSC\)" <kristian-foster@ouhsc.edu>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
In-Reply-To: <7DF4C4113E7CAD4D90A978233833EFE803A6180921@TESLA.hsc.net.ou.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

"Foster, Kristian B (HSC)" <kristian-foster@ouhsc.edu> wrote:

> Currently the queries are running about 4x slower on postgres than
> sql server.=A0 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


--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance