RE: Bulk Insert into PostgreSQL
От
Tsunakawa, Takayuki
Тема
RE: Bulk Insert into PostgreSQL
Дата
Msg-id
0A3221C70F24FB45833433255569204D1FA27778@G01JPEXMBYT05
Ответ на
Re: Bulk Insert into PostgreSQL (Peter Geoghegan)
Список
Дерево обсуждения
Bulk Insert into PostgreSQL Srinivas Karthik V <skarthikv.iitb@gmail.com>
Re: Bulk Insert into PostgreSQL Pavel Stehule <pavel.stehule@gmail.com>
Re: Bulk Insert into PostgreSQL Don Seiler <don@seiler.us>
Re: Bulk Insert into PostgreSQL Srinivas Karthik V <skarthikv.iitb@gmail.com>
RE: Bulk Insert into PostgreSQL "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Bulk Insert into PostgreSQL Peter Geoghegan <pg@bowt.ie>
RE: Bulk Insert into PostgreSQL "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Bulk Insert into PostgreSQL Srinivas Karthik V <skarthikv.iitb@gmail.com>
Re: Bulk Insert into PostgreSQL Peter Geoghegan <pg@bowt.ie>
Re: Bulk Insert into PostgreSQL Srinivas Karthik V <skarthikv.iitb@gmail.com>
Re: Bulk Insert into PostgreSQL Craig Ringer <craig@2ndquadrant.com>
Re: Bulk Insert into PostgreSQL Ashwin Agrawal <aagrawal@pivotal.io>
RE: Bulk Insert into PostgreSQL ROS Didier <didier.ros@edf.fr>
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 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
В списке pgsql-hackers по дате отправления
