On Tue, Sep 24, 2013 at 6:24 AM, Sam Wong <[email protected]> wrote: > This event_log table has 4 million rows. > > “log_id” is the primary key (bigint), > > there is a composite index “event_data_search” over (event::text, > insert_time::datetime).
I think you need to add log_id to that composite index to get pg to use it. -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
