From: Peter Geoghegan [mailto:pg@bowt.ie]
> What kind of data was indexed? Was it a bigserial primary key, or
> something else?
Sorry, I don't remember it. But the table was for storing some machine usage data, and I don't think any sequence was
usedin the index.
According to my faint memory, iostat showed many reads on the database storage, and correspondingly pstack showed
ReadBufferExtendedduring the btree operations. shared_buffers was multiple GBs. I wondered why btree operations
didn'tbenefit from the caching of non-leaf nodes.
Regards
Takayuki Tsunakawa