From: Mark Lewis <mark.lewis@mir3.com>
To: carlosreimer@terra.com.br
Cc: pgsql-performance@postgresql.org
Subject: Re: Initial database loading and IDE x SCSI
Date: Fri, 02 Jun 2006 11:41:27 -0700
Message-ID: <1149273687.20798.91.camel@archimedes> (raw)
In-Reply-To: <PEEPKDFEHHEMKBBFPOOKCEHCCPAA.carlosreimer@terra.com.br>
References: <PEEPKDFEHHEMKBBFPOOKCEHCCPAA.carlosreimer@terra.com.br>
On Fri, 2006-06-02 at 15:25 -0300, carlosreimer@terra.com.br wrote:
> Hi,
>
> I would like to know if my supposition is right.
>
> Considering an environment with only one hard disk attached to a server, an
> initial loading of the database probably is much faster using an IDE/ATA
> interface with write-back on than using an SCSI interface. That´s because of
> the SCSI command interface overhead.
No, it's because the SCSI drive is honoring the database's request to
make sure the data is safe.
> Then main advantage of SCSI interfaces, the multiuser environment is lost in
> this scenery.
>
> Am I right? Am I missing something here?
>
> Even if I´m right, is something that could be done too improove SCSI loading
> performance in this scenery?
You can perform the initial load in large transactions. The extra
overhead for ensuring that data is safely written to disk will only be
incurred once per transaction, so try to minimize the number of
transactions.
You could optionally set fsync=off in postgresql.conf, which means that
the SCSI drive will operate with no more safety than an IDE drive. But
you should only do that if you're willing to deal with catastrophic data
corruption. But if this is for a desktop application where you need to
support IDE drives, you'll need to deal with that anyway.
> Thanks in advance!
>
> Reimer
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark.lewis@mir3.com, carlosreimer@terra.com.br
Subject: Re: Initial database loading and IDE x SCSI
In-Reply-To: <1149273687.20798.91.camel@archimedes>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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