On 26.08.2011 00:45, Jim Nasby wrote:
I've often wondered about the per-tuple overhead of all kinds of operations,
not just GiST index builds. For example, if you're doing a seqscan, ISTM it
would be a lot more efficient to memcpy an entire page into backend-local
memory and operate off of tha
On Aug 23, 2011, at 2:03 AM, Heikki Linnakangas wrote:
> While looking at Alexander's GiST fastbuild patch, which adds buffers to
> internal nodes to avoid random I/O during index build, it occurred to me that
> inserting the tuples to the leaf pages one at a time is quite inefficient
> too, eve
While looking at Alexander's GiST fastbuild patch, which adds buffers to
internal nodes to avoid random I/O during index build, it occurred to me
that inserting the tuples to the leaf pages one at a time is quite
inefficient too, even if the leaf pages are in cache. There's still the
overhead o