Re: bulk inserts

Поиск
Список
Период
Сортировка
От Sam Mason
Тема Re: bulk inserts
Дата
Msg-id 20090929231648.GT5407@samason.me.uk
обсуждение исходный текст
Ответ на Re: bulk inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Tue, Sep 29, 2009 at 12:17:51PM -0400, Tom Lane wrote:
> Sam Mason <sam@samason.me.uk> writes:
> > On Tue, Sep 29, 2009 at 08:45:55AM -0700, Alan Hodgson wrote:
> >> I think a big reason is also that the client can stream the data without
> >> waiting for a network round trip ack on every statement.
>
> > I don't think so.  I'm pretty sure you can send multiple statements in a
> > single round trip.
>
> You can, but that doesn't scale to megabytes of data (at least not
> well).

No, but I didn't think that was being talked about.  I was thinking
network round trip time does seem to become a thousand times less
important when you're putting a thousand statements together.  This
would seem to imply that network latency can be almost arbitrarily
reduced.

> I think the big points are elimination of per-row network and
> transaction commit overhead ...

Well, if you start including transaction commit then you've just changed
semantics away from COPY.  I was implicitly thinking of what changes
when you keep the same semantics as COPY.

> but there are some other optimizations
> in the COPY path too.

Cool, I'll continue to prefer COPY then!

--
  Sam  http://samason.me.uk/

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Performance evaluation of PostgreSQL's historic releases
Следующее
От: Matt Friedman
Дата:
Сообщение: Postgresql Web Hosting