Re: "SELECT IN" Still Broken in 7.4b
От | Rod Taylor |
---|---|
Тема | Re: "SELECT IN" Still Broken in 7.4b |
Дата | |
Msg-id | 1061399435.40948.15.camel@jester обсуждение исходный текст |
Ответ на | "SELECT IN" Still Broken in 7.4b (Mike Winter <mike.winter@frontlogic.com>) |
Ответы |
Re: "SELECT IN" Still Broken in 7.4b
|
Список | pgsql-sql |
Ensure your IN list is unique. You might find better times by through an indexed temp table. On Wed, 2003-08-20 at 16:32, Mike Winter wrote: > I'm sure many on this list are sick of hearing about this problem, but it > was on the fix list for 7.4, but doesn't appear to have been changed. > > You can see one of the many threads on the problem at: > http://archives.postgresql.org/pgsql-sql/2003-05/msg00352.php > > Basically, queries of the form SELECT <rows> FROM <table> WHERE <row> IN > (<list of values>) take forever for high numbers of rows in the IN clause. > We've done timing on 7.3 and 7.4b and there is no speed improvement on > these queries. > > Does anyone know what the status of this bug is?
В списке pgsql-sql по дате отправления: