Bruce Momjian wrote:
Is changing the OS/X wal_sync_method default something we should
consider?
It's certainly reasonable to consider changing both OS X and Windows so
wal_sync_method defaulted to fsync_writethrough, and provide safer
operation by default on both those platforms. It
Is changing the OS/X wal_sync_method default something we should
consider?
---
Greg Smith wrote:
Michael Clark wrote:
The solution to the problem seemed to be to change the value for the
wal_sync_method setting to
On 16/12/2009 3:54 PM, Florian Weimer wrote:
* Michael Clark:
The solution to the problem seemed to be to change the value for the
wal_sync_method setting to fsync_writethrough from the default of fsync.
I was curious if there were perhaps any other reasons that we should look
at? Or if there
* Craig Ringer:
On 16/12/2009 3:54 PM, Florian Weimer wrote:
* Michael Clark:
The solution to the problem seemed to be to change the value for the
wal_sync_method setting to fsync_writethrough from the default of fsync.
I was curious if there were perhaps any other reasons that we should
On 16/12/2009 6:41 PM, Florian Weimer wrote:
* Craig Ringer:
When you're dealing with end users who have machines running
god-knows-what kinds of awful hardware drivers
Even Mac OS X? There should be less variety.
Of disk and other critical drivers, sure.
There is, however, a huge variety
Hello Craig - thanks for the reply. I will reply below.
On Tue, Dec 15, 2009 at 9:34 PM, Craig Ringer
cr...@postnewspapers.com.auwrote:
On 16/12/2009 6:39 AM, Michael Clark wrote:
Hello all,
Over the past 6 months or so I have posted to the list a couple times
looking for information
Hi Scott and Craig,
On Tue, Dec 15, 2009 at 9:45 PM, Craig Ringer
cr...@postnewspapers.com.auwrote:
On 16/12/2009 9:07 AM, Scott Marlowe wrote:
I'd also recommend moving off of OSX as you're using a minority OS as
far as databases are concerned, and you won't have a very large
community to
Hi Greg, thanks for the reply!
On Tue, Dec 15, 2009 at 10:52 PM, Greg Smith g...@2ndquadrant.com wrote:
Michael Clark wrote:
Secondly, I ask about an alternative solution to the corruption problem
because with preliminary testing we have seen a significant degradation in
performance. So
On Wed, Dec 16, 2009 at 5:41 AM, Florian Weimer fwei...@bfk.de wrote:
* Craig Ringer:
On 16/12/2009 3:54 PM, Florian Weimer wrote:
* Michael Clark:
and with no power protection, then I expect it does. Add laptop
users with ageing/flakey batteries, laptops let go flat after they
go
Florian Weimer wrote:
I hope that Mac OS X turns off write caches on low battery.
I've never heard of such a thing. The best you can do is try to push
the system into hibernation instead of going down hard. That *should*
clear any disk caches as part of the graceful shutdown. But
On Wed, Dec 16, 2009 at 11:25 AM, Greg Smith g...@2ndquadrant.com wrote:
Florian Weimer wrote:
I hope that Mac OS X turns off write caches on low battery.
I've never heard of such a thing. The best you can do is try to push the
system into hibernation instead of going down hard. That
Michael Clark wrote:
On Wed, Dec 16, 2009 at 11:25 AM, Greg Smith g...@2ndquadrant.com
mailto:g...@2ndquadrant.com wrote:
Florian Weimer wrote:
I hope that Mac OS X turns off write caches on low battery.
I've never heard of such a thing. The best you can do is
On Wed, Dec 16, 2009 at 2:05 PM, Greg Smith g...@2ndquadrant.com wrote:
Michael Clark wrote:
On Wed, Dec 16, 2009 at 11:25 AM, Greg Smith g...@2ndquadrant.com wrote:
Florian Weimer wrote:
I hope that Mac OS X turns off write caches on low battery.
I've never heard of such a thing.
Hello all,
Over the past 6 months or so I have posted to the list a couple times
looking for information regarding recovering databases from corruption. At
the time the incidents of corruption among our users was very low, but the
frequency is starting to increase, most likely due to the
On Tue, Dec 15, 2009 at 3:39 PM, Michael Clark codingni...@gmail.com wrote:
Hello all,
Over the past 6 months or so I have posted to the list a couple times
looking for information regarding recovering databases from corruption. At
the time the incidents of corruption among our users was very
On 16/12/2009 6:39 AM, Michael Clark wrote:
Hello all,
Over the past 6 months or so I have posted to the list a couple times
looking for information regarding recovering databases from corruption.
At the time the incidents of corruption among our users was very low,
but the frequency is
On 16/12/2009 9:07 AM, Scott Marlowe wrote:
I'd also recommend moving off of OSX as you're using a minority OS as
far as databases are concerned, and you won't have a very large
community to help out when things do go wrong.
It sounds like PostgreSQL is being used as a DB bundled with an app
Michael Clark wrote:
The solution to the problem seemed to be to change the value for the
wal_sync_method setting to fsync_writethrough from the default of fsync.
I was surprised recently to discover the default wasn't
fsync_writethrough on that platform, because it probably should be.
Craig Ringer wrote:
On 16/12/2009 9:07 AM, Scott Marlowe wrote:
I'd also recommend moving off of OSX as you're using a minority OS as
far as databases are concerned, and you won't have a very large
community to help out when things do go wrong
It sounds like PostgreSQL is being used as a DB
On Tue, Dec 15, 2009 at 7:45 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
On 16/12/2009 9:07 AM, Scott Marlowe wrote:
I'd also recommend moving off of OSX as you're using a minority OS as
far as databases are concerned, and you won't have a very large
community to help out when things
* Michael Clark:
The solution to the problem seemed to be to change the value for the
wal_sync_method setting to fsync_writethrough from the default of fsync.
I was curious if there were perhaps any other reasons that we should look
at? Or if there may be other alternatives to changing the
21 matches
Mail list logo