Re: PostgreSQL runs a query much slower than BDE and

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Mark Lewis" <mark(dot)lewis(at)mir3(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Peter Hardman" <peter(at)ssbg(dot)zetnet(dot)co(dot)uk>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PostgreSQL runs a query much slower than BDE and
Date: 2006-08-17 16:31:39
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCEA0FB3A@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-08-17 18:33:27 Re: PostgreSQL runs a query much slower than BDE and MySQL
Previous Message Mark Lewis 2006-08-17 13:54:00 Re: PostgreSQL runs a query much slower than BDE and