From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Neil Conway <neilc(at)samurai(dot)com> |
Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>, agoldshuv(at)greenplum(dot)com |
Subject: | Re: [PATCHES] WAL bypass for CTAS |
Date: | 2005-06-05 00:36:52 |
Message-ID: | 200506050036.j550aqN01183@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Neil Conway wrote:
> Bruce Momjian wrote:
> > Well, it isn't going to help us for 8.1 because 8.0 will not have it,
> > and if we add the clause we make loading the data into previous releases
> > harder.
>
> pg_dump output in general is not compatible with prior releases. It
> would be a nice feature to have, but until we have it, I don't see that
> changing or not changing the COPY syntax will make a major difference to
> dump backward compatibility.
Right, usually the schema changes are not backward compatibible, but the
COPY commands are. But now that I look at this example:
COPY test (x) FROM stdin;
1
\.
The column name "(x)" actually broke backward compatibility when we
added it, so yea, we could add a new option now too. No one complained
when we added the column names, so another option would be fine.
I suppose no one would like adding an option to turn off locking during
COPY, so the non-WAL logging would become the default? (Just asking.
You know me, I like automatic.)
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-06-05 00:38:40 | Re: Suggestion: additional system views |
Previous Message | Neil Conway | 2005-06-05 00:29:19 | Re: WAL bypass for CTAS |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-06-05 00:42:29 | Re: Faster install-sh in C |
Previous Message | Neil Conway | 2005-06-05 00:29:19 | Re: WAL bypass for CTAS |