On Tue, Mar 4, 2014 at 2:57 PM, Adarsh Sharma <eddy.ada...@gmail.com> wrote:
> I tried creating simple and gin indexes on the column(t_ids) but still not > helping. Anyone has any idea or faced this before. Postgresql version is > 9.2. > have you done a vacuum analyze or analyze after this step? You might have to disable sequential scans set enable_seqscan=off; And then fire the query. Best Regards, *Sameer Kumar | Database Consultant* *ASHNIK PTE. LTD.* 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533 M: *+65 8110 0350* T: +65 6438 3504 | www.ashnik.com *[image: icons]* [image: Email patch] <http://www.ashnik.com/> This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).
<<inline: image005.jpg>>
<<inline: image006.jpg>>
