| 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
| 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? |
| 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? |
| 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 |