Skip site navigation (1) Skip section navigation (2)

Re: Select performance vs. mssql

From: mark durrant <markd89(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Select performance vs. mssql
Date: 2005-05-24 06:40:34
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
> Post the result of this for us:
> explain analyze select count(*) from mtable where
> day='Mon';
> On both machines.

Hi Chris --

PostgreSQL Machine:
"Aggregate  (cost=140122.56..140122.56 rows=1 width=0)
(actual time=24516.000..24516.000 rows=1 loops=1)"
"  ->  Index Scan using "day" on mtable 
(cost=0.00..140035.06 rows=35000 width=0) (actual
time=47.000..21841.000 rows=1166025 loops=1)"
"        Index Cond: ("day" = 'Mon'::bpchar)"
"Total runtime: 24516.000 ms"
(Note this took 24 seconds after fresh reboot, next
execution was 11, and execution without explain
analyze was 6.7 seconds)

MSSQL Machine:
That "Explain Analyze" command doesn't work for MSSQL,
but I did view the Query plan. 97% of it was "Scanning
a particular range of rows from a nonclustered index"

Thanks for your help --Mark

Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 


pgsql-performance by date

Next:From: Neil ConwayDate: 2005-05-24 06:47:31
Subject: Re: Select performance vs. mssql
Previous:From: Christopher Kings-LynneDate: 2005-05-24 06:18:36
Subject: Re: Select performance vs. mssql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group