Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL runs a query much slower than BDE and - Mailing list pgsql-performance

From Magnus Hagander
Subject Re: PostgreSQL runs a query much slower than BDE and
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCEA0FB3A@algol.sollentuna.se
Whole thread Raw
In response to Re: PostgreSQL runs a query much slower than BDE and  (Mark Lewis <mark.lewis@mir3.com>)
List pgsql-performance
Tree view 
> MSSQL can give either a graphical query plan or a text-based
> one similar to PG.  There's no way that I've found to get the
> equivalent of an EXPLAIN ANALYZE, but I'm by no means an MSSQL guru.

SET STATISTICS IO ON
SET STATISTICS PROFILE ON
SET STATISTICS TIME ON


//Magnus

pgsql-performance by date:

Previous
From: Mark Lewis
Date:
Subject: Re: PostgreSQL runs a query much slower than BDE and
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL runs a query much slower than BDE and MySQL