RES: RES: Initial database loading and IDE x SCSI - Mailing list pgsql-performance

From
Subject RES: RES: Initial database loading and IDE x SCSI
Date
Msg-id PEEPKDFEHHEMKBBFPOOKMEHHCPAA.carlosreimer@terra.com.br
Whole thread Raw
In response to Re: RES: Initial database loading and IDE x SCSI  (Mark Lewis <mark.lewis@mir3.com>)
Responses Re: RES: RES: Initial database loading and IDE x SCSI  (Mark Lewis <mark.lewis@mir3.com>)
List pgsql-performance
Many thanks Mark,

I will consider fsync=off only to do an initial load, not for a database normal operation.

I was just thinking about this hipotetical scenario:
a) a restore database operation
b) fsync off
c) write-back on (IDE)

As I could understand, in this sceneraio, it´s normal the IDE drive be faster than the SCSI, ok?

Of course, the database is exposed because of the fsync=off, but if you consider only the system performance, then it
istrue. Isn´t it? 

Thanks,

Reimer



pgsql-performance by date:

Previous
From: Mark Lewis
Date:
Subject: Re: RES: Initial database loading and IDE x SCSI
Next
From: Mark Lewis
Date:
Subject: Re: RES: RES: Initial database loading and IDE x SCSI