Re: Performance Killer 'IN' ? - Mailing list pgsql-general

From Kai Hessing
Subject Re: Performance Killer 'IN' ?
Date
Msg-id 492apaFme7d7U1@individual.net
Whole thread Raw
In response to Performance Killer 'IN' ?  (Kai Hessing <kai.hessing@hobsons.de>)
Responses Re: Performance Killer 'IN' ?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
> and it took about 10 Minutes to execute. So it is nearly a hundred times
> slower. Can this be verified? Is there anything that can be done about
> that? Else I would need to have a few words with our programmers...

OK... I overstated a little bit. The real numbers are:

1.) 21.5 seconds
2.) 363.7 seconds

But it is still a significant difference.

pgsql-general by date:

Previous
From: Kai Hessing
Date:
Subject: Performance Killer 'IN' ?
Next
From: "Mark Aufflick"
Date:
Subject: Re: PostgreSQL x Sybase