pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPerformance of request of type WHERE ... IN ( ... )
3+ messages / 3 participants
[nested] [flat]
* Performance of request of type WHERE ... IN ( ... )
@ 2003-01-15 10:23 Th Templ <templ_th@hotmail.com>
2003-01-15 15:00 ` Re: Performance of request of type WHERE ... IN ( ... ) Achilleus Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 3+ messages in thread
From: Th Templ @ 2003-01-15 10:23 UTC (permalink / raw)
To: pgsql-sql
Hello,
I have performance problem of an request of type ... WHERE ... IN ( ... ).
How to improve performance of this type of request when a group of id in the
'in' is important.
Thanks for your answers.
Templth
_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Performance of request of type WHERE ... IN ( ... )
2003-01-15 10:23 Performance of request of type WHERE ... IN ( ... ) Th Templ <templ_th@hotmail.com>
@ 2003-01-15 15:00 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
2003-01-15 17:17 ` Re: Performance of request of type WHERE ... IN ( ... ) Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 3+ messages in thread
From: Achilleus Mantzios @ 2003-01-15 15:00 UTC (permalink / raw)
To: Th Templ <templ_th@hotmail.com>; +Cc: pgsql-sql
On Wed, 15 Jan 2003, Th Templ wrote:
> Hello,
>
> I have performance problem of an request of type ... WHERE ... IN ( ... ).
> How to improve performance of this type of request when a group of id in the
> 'in' is important.
Try WHERE ... EXISTS (...).
> Thanks for your answers.
> Templth
>
>
> _________________________________________________________________
> Add photos to your e-mail with MSN 8. Get 2 months FREE*.
> http://join.msn.com/?page=features/featuredemail
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-10-8981112
fax: +30-10-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Performance of request of type WHERE ... IN ( ... )
2003-01-15 10:23 Performance of request of type WHERE ... IN ( ... ) Th Templ <templ_th@hotmail.com>
2003-01-15 15:00 ` Re: Performance of request of type WHERE ... IN ( ... ) Achilleus Mantzios <achill@matrix.gatewaynet.com>
@ 2003-01-15 17:17 ` Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 3+ messages in thread
From: Josh Berkus @ 2003-01-15 17:17 UTC (permalink / raw)
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>; Th Templ <templ_th@hotmail.com>; +Cc: pgsql-sql
Th,
> > I have performance problem of an request of type ... WHERE ... IN (
> ... ).
> > How to improve performance of this type of request when a group of
> id in the
> > 'in' is important.
>
> Try WHERE ... EXISTS (...).
The explanation of the difference btw. IN and EXISTS is in the
PostgreSQL FAQ on the web site.
-Josh
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-01-15 17:17 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-15 10:23 Performance of request of type WHERE ... IN ( ... ) Th Templ <templ_th@hotmail.com>
2003-01-15 15:00 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
2003-01-15 17:17 ` Josh Berkus <josh@agliodbs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox