Re: Subselect query enhancement
От
Michael Artz
Тема
Re: Subselect query enhancement
Дата
Msg-id
e9c163070702011014g7c90f0f3v8bff5fcb0de27f7@mail.gmail.com
Ответ на
Re: Subselect query enhancement (Ted Allen)
Список
Дерево обсуждения
Subselect query enhancement "Michael Artz" <mlartz@gmail.com>
Re: Subselect query enhancement Frank Wiles <frank@wiles.org>
Re: Subselect query enhancement Richard Huxton <dev@archonet.com>
Re: Subselect query enhancement "Michael Artz" <mlartz@gmail.com>
Re: Subselect query enhancement Richard Huxton <dev@archonet.com>
Re: Subselect query enhancement "Michael Artz" <mlartz@gmail.com>
Re: Subselect query enhancement Richard Huxton <dev@archonet.com>
Re: Subselect query enhancement Ted Allen <tallen@blackducksoftware.com>
Re: Subselect query enhancement "Michael Artz" <mlartz@gmail.com>
Re: Subselect query enhancement Andrew Lazarus <andrew@pillette.com>
> How about this option: > > SELECT distinct ip_info.* FROM ip_info RIGHT JOIN network_events USING > (ip) RIGHT JOIN host_events USING (ip) WHERE > (network_events.name='blah' OR host_events.name = 'blah') AND > ip_info.ip IS NOT NULL; Nah, that seems to be much much worse. The other queries usually return in 1-2 minutes, this one has been running for 30 minutes and has still not returned -Mike
В списке pgsql-performance по дате отправления
