Re: 7.3.1 New install, large queries are slow - Mailing list pgsql-performance

From Stephan Szabo
Subject Re: 7.3.1 New install, large queries are slow
Date
Msg-id 20030115194528.U98448-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: 7.3.1 New install, large queries are slow  ("Roman Fail" <rfail@posportal.com>)
List 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?


pgsql-performance by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: 7.3.1 New install, large queries are slow
Next
From: Tom Lane
Date:
Subject: Re: 7.3.1 New install, large queries are slow