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

Re: 200 times slower then MSSQL??

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Alexander Dolgin <alex(at)dolgin(dot)dp(dot)ua>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 200 times slower then MSSQL??
Date: 2005-01-25 17:52:28
Message-ID: 41F6875C.9040804@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
> with about 8000 rows. For this table query:
> 
> SELECT MAX(MsgSeqNum),MAX(LogTimestamp) FROM ELT_tcli_MessageLog 
> WHERE LogTimestamp  >=  '0' AND IsFromCounterParty  =  'Y' AND
> IsOutOfSequence = 'N' 
>      AND ConnectionName  =  'DB_BENCHMARK' 
>      AND LogTimestamp IN (SELECT MAX(LogTimestamp) 
>                           FROM ELT_tcli_MessageLog 
>                           WHERE MsgSeqNum  >  0 AND IsFromCounterParty = 'Y'
> 
>                                 AND IsOutOfSequence  =  'N' AND
> ConnectionName  =  'DB_BENCHMARK')
> 
> takes about 1 second on MSSQL Server and 257 seconds on PostgreSQL one.
> 
> Does anybody have idea about reasons of such results?

1. Have you run vaccum analyze recently?
2. Reply with the output of EXPLAIN ANALYZE SELECT...

Chris

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2005-01-25 17:56:53
Subject: Re: PostgreSQL vs. Oracle vs. Microsoft
Previous:From: Josh BerkusDate: 2005-01-25 16:58:37
Subject: Re: PgPool changes WAS: PostgreSQL clustering VS MySQL

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