Horton

Re: 7.3.1 New install, large queries are slow

Stephan Szabo <sszabo@megazone23.bigpanda.com>

View thread View on postgr.es
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Roman Fail <rfail@posportal.com>
Cc: <josh@agliodbs.com>, <pgsql-performance@postgresql.org>
Date: 2003-01-16T03:46:16Z
Lists: pgsql-performance 
On Wed, 15 Jan 2003, Roman Fail wrote:

> Thanks to everyone for the quick replies!  I'm sure that my lack of
> skill with SQL queries is the main problem.  What's strange to me is
> how MSSQL takes my bad queries and makes them look good anyway.  It
> must have a real smart planner.

As a followup, if you do
set enable_indexscan=off;
before running the explain analyze, what does that give you?