Re: [HACKERS] 8.2 features?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Andrew Dunstan <andrew(at)dunslane(dot)net>, Joe Conway <mail(at)joeconway(dot)com>, Bernd Helmle <mailings(at)oopsware(dot)de>, Peter Eisentraut <peter_e(at)gmx(dot)net>, "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>, Susanne Ebrecht <susanne(dot)ebrecht(at)credativ(dot)de>
Subject: Re: [HACKERS] 8.2 features?
Date: 2006-07-19 03:32:34
Message-ID: 15212.1153279954@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers pgsql-patches

Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com> writes:
> Strange. Last time I checked I thought MySQL dump used 'multivalue
> lists in inserts' for dumps, for the same reason that we use COPY

I think Andrew identified the critical point upthread: they don't try
to put an unlimited number of rows into one INSERT, only a megabyte
or so's worth. Typical klugy-but-effective mysql design approach ...

regards, tom lane

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Joe Conway 2006-07-19 04:20:05 Re: [HACKERS] 8.2 features?
Previous Message Christopher Kings-Lynne 2006-07-19 01:20:29 Re: [HACKERS] 8.2 features?

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2006-07-19 03:52:36 Re: url for TODO item, is it right?
Previous Message Tom Lane 2006-07-19 03:24:08 Re: Progress bar updates

Browse pgsql-patches by date

  From Date Subject
Next Message Joe Conway 2006-07-19 04:20:05 Re: [HACKERS] 8.2 features?
Previous Message Tom Lane 2006-07-19 02:52:02 Re: modular pg_regress.sh