| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-patches(at)postgresql(dot)org, Alon Goldshuv <agoldshuv(at)greenplum(dot)com> |
| Subject: | Re: WAL bypass for CTAS |
| Date: | 2005-06-05 00:20:19 |
| Message-ID: | 42A24543.4000902@samurai.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Bruce Momjian wrote:
> Could we do your NOLOGGING automatically in COPY if we test to see if
> anyone else is connected to our current database?
That seems pretty fragile -- what happens if someone connects after the
COPY has started? Considering that many COPY operations can take many
minutes or hours, I don't think it is wise to make assumptions based on
the initial state of the system.
> I would _love_ to see pg_dump loads use this automatically, without
> having to add clauses to pg_dump output.
What's wrong with adding clauses to the pg_dump output?
-Neil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-06-05 00:20:26 | Re: timestamp with time zone a la sql99 |
| Previous Message | Serguei A. Mokhov | 2005-06-04 23:42:34 | Re: pg_upgrade project: high-level design proposal of |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-06-05 00:23:25 | Re: WAL bypass for CTAS |
| Previous Message | Bruce Momjian | 2005-06-04 23:34:52 | Re: [HACKERS] PGPASSWORD and client tools |