From: Joel Fradkin <jfradkin@wazagua.com>
To: pgsql-sql@postgresql.org
Subject: MSSQL versus Postgres timing
Date: Tue, 1 Feb 2005 11:54:11 -0500
Message-ID: <000001c5087e$b92ddfa0$797ba8c0@jfradkin> (raw)
All is moving along well.
I have all my views and data and am testing things out a bit.
A table with 645,000 records for associates has view (basically select *
from tblassociates where clientnum = 'test')
This is taking 13 seconds in postgres and 3 seconds in MSSQL.
I tried making an index on clientnum (there is one on clinetnum, associateID
in MSSQL).
I did an analyze.
I did a set seq scan off
Is there a possibility postgres is this much slower, or (my hope) I am
missing some key concept.
Be glad to provide the view and tables etc.
Joel Fradkin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jfradkin@wazagua.com
Subject: Re: MSSQL versus Postgres timing
In-Reply-To: <000001c5087e$b92ddfa0$797ba8c0@jfradkin>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox