Re: Performance Killer 'IN' ?

From: Kai Hessing <kai(dot)hessing(at)hobsons(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance Killer 'IN' ?
Date: 2006-03-30 15:11:38
Message-ID: 492apaFme7d7U1@individual.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-03-30 15:35:27 Re: Chasing "signal 11" issues
Previous Message Kai Hessing 2006-03-30 14:45:53 Re: Converting a database from LATIN1 to UTF-8