Re: mysql to postgresql, performance questions - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: mysql to postgresql, performance questions
Date
Msg-id 201003311423.o2VENTD15761@momjian.us
Whole thread Raw
In response to Re: mysql to postgresql, performance questions  (James Mansion <james@mansionfamily.plus.com>)
Responses Re: mysql to postgresql, performance questions
List pgsql-performance
James Mansion wrote:
> Hannu Krosing wrote:
> > Pulling the plug should not corrupt a postgreSQL database, unless it was
> > using disks which lie about write caching.
> >
> Didn't we recently put the old wife's 'the disks lied' tale to bed in
> favour of actually admiting that some well known filesystems and
> saftware raid systems have had trouble with their write barriers?

I thought the issue was that many file systems do not issue the drive
ATAPI flush command, and I suppose drives are allowed not to flush on
write if they honor the command.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

pgsql-performance by date:

Previous
From: Matteo Beccati
Date:
Subject: Re: 3ware vs. MegaRAID
Next
From: Robert Haas
Date:
Subject: Re: experiments in query optimization