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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-01-25 17:56:53 | Re: PostgreSQL vs. Oracle vs. Microsoft |
Previous Message | Josh Berkus | 2005-01-25 16:58:37 | Re: PgPool changes WAS: PostgreSQL clustering VS MySQL |