Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Bulk Insert tuning
- From: Simon Riggs <simon(at)2ndquadrant(dot)com>
- To: pgsql-patches(at)postgresql(dot)org
- Subject: Bulk Insert tuning
- Date: Tue, 26 Feb 2008 14:43:51 +0000
- Message-id: <1204037031.4252.301.camel@ebony.site> <text/plain>
Following patch implements a simple mechanism to keep a buffer pinned while we are bulk loading. Performance gains measured as +20% gain for CREATE TABLE as SELECT, and 15-17% for COPY on very short rows. Measurable difference drops away and is not measurable at all at 1000/bytes per row. As a result, patch doesn't bother to implement buffer pinning for TOAST operations. Can I ask for some independent performance results please? -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com
Attachment:
fast_copy.v3.patch
Description: Text Data
- Follow-Ups:
- Re: Bulk Insert tuning
- From: Tom Lane
- Re: Bulk Insert tuning
- From: Simon Riggs
- Re: Bulk Insert tuning
- Prev by Date: Re: DTrace not working after SUBSYS.o reorg
- Next by Date: Re: DTrace not working after SUBSYS.o reorg
- Previous by thread: DTrace not working after SUBSYS.o reorg
- Next by thread: Re: Bulk Insert tuning
- Indexes: