Re: [HACKERS] 8.2 features?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgresql(dot)org, Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com>, 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-18 18:19:01
Message-ID: 5842.1153246741@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers pgsql-patches

>> If the use case is people running MySQL dumps, then there will be
>> millions of values-targetlists in MySQL dumps.

I did some experimentation just now, and could not get mysql to accept a
command longer than about 1 million bytes. It complains about
Got a packet bigger than 'max_allowed_packet' bytes
which seems a bit odd because max_allowed_packet is allegedly set to
16 million, but anyway I don't think people are going to be loading any
million-row tables using single INSERT commands in mysql either.

regards, tom lane

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Chris Browne 2006-07-18 18:49:35 Re: [HACKERS] 8.2 features?
Previous Message Joe Conway 2006-07-18 15:05:57 Re: [HACKERS] 8.2 features?

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Hammond 2006-07-18 18:20:32 Re: password is no required, authentication is overridden
Previous Message Gregory Stark 2006-07-18 18:17:09 does pgxs work?

Browse pgsql-patches by date

  From Date Subject
Next Message Chris Browne 2006-07-18 18:49:35 Re: [HACKERS] 8.2 features?
Previous Message Joshua Reich 2006-07-18 17:43:32 Re: [PATCHES] Proposed patch for contrib/cube