From: Peter Geoghegan [mailto:p...@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 used in the index. According to my faint memory, iostat showed many reads on the database storage, and correspondingly pstack showed ReadBufferExtended during the btree operations. shared_buffers was multiple GBs. I wondered why btree operations didn't benefit from the caching of non-leaf nodes. Regards Takayuki Tsunakawa
