From: Greg Stark <gsstark@mit.edu>
To: Joel Fradkin <jfradkin@wazagua.com>
Cc: gsstark@mit.edu
Cc: pgsql-sql@postgresql.org
Subject: Re: same question little different test MSSQL vrs Postgres
Date: 26 Jan 2005 11:20:18 -0500
Message-ID: <873bwo17st.fsf@stark.xeocode.com> (raw)
In-Reply-To: <000401c503aa$f8ee5620$797ba8c0@jfradkin>
References: <000401c503aa$f8ee5620$797ba8c0@jfradkin>
"Joel Fradkin" <jfradkin@wazagua.com> writes:
> QUERY PLAN
> "Seq Scan on tblcase (cost=0.00..30066.21 rows=37401 width=996) (actual
> time=0.344..962.260 rows=22636 loops=1)"
> " Filter: ((clientnum)::text = 'SAKS'::text)"
> "Total runtime: 1034.434 ms"
Well that says it only took 1s. So it seems this is highly dependent on
whether the data is in cache. Perhaps it was in cache on MSSQL when you
profiled it there and not on postgres?
You could put an index on clientnum, but if the data is usually in cache like
this it might not even be necessary.
--
greg
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: gsstark@mit.edu, jfradkin@wazagua.com
Subject: Re: same question little different test MSSQL vrs Postgres
In-Reply-To: <873bwo17st.fsf@stark.xeocode.com>
* 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