pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

RES: RES: Initial database loading and IDE x SCSI
2+ messages / 2 participants
[nested] [flat]

* RES: RES: Initial database loading and IDE x SCSI
@ 2006-06-02 20:37 carlosreimer@terra.com.br
  2006-06-02 20:44 ` Re: RES: RES: Initial database loading and IDE x SCSI Mark Lewis <mark.lewis@mir3.com>
  0 siblings, 1 reply; 2+ messages in thread

From: carlosreimer@terra.com.br @ 2006-06-02 20:37 UTC (permalink / raw)
  To: Mark Lewis <mark.lewis@mir3.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; 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 is true. Isn´t it?

Thanks,

Reimer





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: RES: RES: Initial database loading and IDE x SCSI
  2006-06-02 20:37 RES: RES: Initial database loading and IDE x SCSI carlosreimer@terra.com.br
@ 2006-06-02 20:44 ` Mark Lewis <mark.lewis@mir3.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Mark Lewis @ 2006-06-02 20:44 UTC (permalink / raw)
  To: carlosreimer@terra.com.br; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-performance

On Fri, 2006-06-02 at 17:37 -0300, carlosreimer@terra.com.br wrote:
> Many thanks Mark,
> 
> I will consider fsync=off only to do an initial load, not for a database normal operation.
> 

This approach works well.  You just need to remember to shut down the
database and start it back up again with fsync enabled for it to be safe
after the initial load.

> 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?
> 

If fsync is off, then the IDE drive loses its big advantage, so IDE and
SCSI should be about the same speed.

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



> Thanks,
> 
> Reimer
> 
> 



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2006-06-02 20:44 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-02 20:37 RES: RES: Initial database loading and IDE x SCSI carlosreimer@terra.com.br
2006-06-02 20:44 ` Mark Lewis <mark.lewis@mir3.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox