Re: SQL select query becomes slow when using limit (with no offset)
От
PFC
Тема
Re: SQL select query becomes slow when using limit (with no
offset)
Дата
Msg-id
op.uxxm37opcigqcu@soyouz
Ответ на
SQL select query becomes slow when using limit (with no offset) (Kees van Dieren)
Список
Дерево обсуждения
SQL select query becomes slow when using limit (with no offset) Kees van Dieren <keesvandieren@gmail.com>
Re: SQL select query becomes slow when using limit (with no offset) Greg Stark <gsstark@mit.edu>
Re: SQL select query becomes slow when using limit (with no offset) Kees van Dieren <keesvandieren@gmail.com>
Re: SQL select query becomes slow when using limit (with
no offset) Russell Smith <mr-russ@pws.com.au>
Re: SQL select query becomes slow when using limit (with no
offset) Kees van Dieren <keesvandieren@gmail.com>
Re: SQL select query becomes slow when using limit (with no
offset) Robert Haas <robertmhaas@gmail.com>
Re: SQL select query becomes slow when using limit (with
no offset) Scott Carey <scott@richrelevance.com>
Re: SQL select query becomes slow when using limit (with no
offset) Robert Haas <robertmhaas@gmail.com>
Re: SQL select query becomes slow when using limit
(with no offset) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: SQL select query becomes slow when using limit (with no
offset) Robert Haas <robertmhaas@gmail.com>
Re: SQL select query becomes slow when using limit (with
no offset) Devin Ben-Hur <dbenhur@whitepages.com>
Re: SQL select query becomes slow when using limit (with no
offset) PFC <lists@peufeu.com>
> The query: > select events_events.id FROM events_events > left join events_event_types on events_events.eventType_id= > events_event_types.id > where events_event_types.severity=70 > and events_events.cleared='f' > order by events_events.dateTime DESC The main problem seems to be lack of a suitable index... - Try creating an index on events_events( eventType_id, cleared ) - Or the other way around : events_events( cleared, eventType_id ) (depends on your other queries) Please try both and report EXPLAIN ANALYZE.
В списке pgsql-performance по дате отправления
От: Greg Stark
Дата:
