| From: | Manfred Spraul <manfred(at)colorfullife(dot)com> |
|---|---|
| To: | "Simon(at)2ndquadrant(dot)com" <simon(at)2ndquadrant(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Klaus Naumann <kn(at)mgnet(dot)de>, markw(at)osdl(dot)org, "Pgsql-Hackers(at)Postgresql(dot) Org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: NOT LOGGED options (was Point in Time Recovery ) |
| Date: | 2004-08-18 16:52:42 |
| Message-ID: | 4123895A.6060203@colorfullife.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers pgsql-patches |
Simon(at)2ndquadrant(dot)com wrote:
>>Tom Lane wrote
>>
>>
>>>NOT LOGGED options on CREATE INDEX and COPY, to allow users to take
>>>advantage of the no logging optimization without turning off PITR system
>>>wide. (Just as this is possible in Oracle and Teradata).
>>>
>>>
>>Isn't this in direct conflict with your opinion above? And I cannot say
>>that I think this one is a good idea. We do not have support for
>>selective catalog xlogging;
>>
Is it possible to skip the xlog fsync for NOT LOGGED transactions?
--
Manfred
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marius Andreiana | 2004-08-18 18:20:52 | Re: [ADMIN] tracking db changes / comparing databases |
| Previous Message | Andrew Dunstan | 2004-08-18 16:43:20 | Re: [HACKERS] SRPM for 8.0.0 beta? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-08-18 17:02:55 | Re: 8.0 libpq: missing get_home_path() |
| Previous Message | Tom Lane | 2004-08-18 16:51:41 | Re: 7.4.3 & 8.0.0beta1 + Solaris 9: default pg_hba.conf breaks |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-08-18 16:53:43 | Re: Compiling libpq with VC6 |
| Previous Message | Tom Lane | 2004-08-18 16:51:41 | Re: 7.4.3 & 8.0.0beta1 + Solaris 9: default pg_hba.conf breaks |