Horton

Re: Seq scans roadmap

Luke Lonergan <llonergan@greenplum.com>

View thread View on postgr.es
From: "Luke Lonergan" <llonergan@greenplum.com>
To: "Simon Riggs" <simon@enterprisedb.com>, "Heikki Linnakangas" <heikki@enterprisedb.com>
Cc: "PostgreSQL-development" <pgsql-hackers@postgresql.org>, "Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>, "CK Tan" <cktan@greenplum.com>, "Jeff Davis" <pgsql@j-davis.com>
Date: 2007-05-12T15:42:40Z
Lists: pgsql-hackers 
Hi Simon,

On 5/12/07 12:35 AM, "Simon Riggs" <simon@enterprisedb.com> wrote:

> I'm slightly worried that the results for COPY aren't anywhere near as
> good as the SELECT and VACUUM results. It isn't clear from those numbers
> that the benefit really is significant.

COPY is bottlenecked on datum formation and format translation with very low
performance, so I don't think we should expect the ring buffer to make much
of a dent.

- Luke