Re: keeping an index in memory

"Rajarshi Guha" <rguha@indiana.edu> writes:

> The table itself is about 10M rows corresponding to 14GB.

Each row is on average 1.4kB ? Perhaps you should send more details of the
table definition and the typical size of each column. It's possible you have
the columns you're selecting on being stored out of line ("toasted") which
would hurt performance if you're often accessing many of those columns.

If it's not true then you may have a lot of dead space in your table which
would decrease performance.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com