On Fri, Feb 19, 2010 at 7:54 PM, Heikki Linnakangas
<heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
> Heikki Linnakangas wrote:
>> Magnus Hagander wrote:
>>> Well, it's going to make the process that reads the WAL cause actual
>>> physical I/O... That'll take a chunk out of your total available I/O,
>>> which is likely to push you to the limit of your I/O capacity much
>>> quicker.
>>
>> Right, doesn't seem sensible, though it would be nice to see a benchmark
>> on that.
>>
>> Here's a patch to disable O_DIRECT when archiving or streaming is
>> enabled. This is pretty hard to test, so any extra eyeballs would be nice..
>
> Committed. Can you check that this fixed the PANIC you saw?
Thanks! Yeah, SR works fine in my MinGW environment.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
In response to
pgsql-hackers by date
| Next: | From: Heikki Linnakangas | Date: 2010-02-22 06:51:57 |
| Subject: Re: A thought on Index Organized Tables |
| Previous: | From: Tom Lane | Date: 2010-02-22 03:58:29 |
| Subject: Re: [COMMITTERS] pgsql: Oops, don't forget to rewind the directory before scanning it to |