On Tue, Sep 24, 2013 at 6:24 AM, Sam Wong <s...@hellosam.net> 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 (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
