On Wed, May 30, 2012 at 1:45 PM, Sergey Koposov <kopo...@ast.cam.ac.uk> wrote: > On Wed, 30 May 2012, Merlin Moncure wrote: >> >> >> Hm, why aren't we getting a IOS? Just for kicks (assuming this is >> test data), can we drop the index on just transitid, leaving the index >> on transitid, healpixid? Is enable_indexonlyscan on? Has idt_match >> been vacuumed? What kind of plan do you get when do: > > > Okay dropping the index on transitid solved the issue with indexonlyscan but > didn't solve the original problem. Actually the indexonlyscan made the > sequential queries faster but not the parallel ones.
hurk -- ISTM that since IOS is masikng the heap lookups, there must be contention on the index itself? Does this working set fit in shared memory? If so, what happens when you do a database restart and repeat the IOS test? merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
