[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: Re: [PERFORM] SQL select query becomes slow when using limit (with no
From: PFC <lists () peufeu ! com>
Date: 2009-07-31 12:46:45
Message-ID: op.uxxm37opcigqcu () soyouz
[Download RAW message or body]
> 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.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic