[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] [GENERAL] Performance issues with compaq server
From:       Denis Gasparin <denis () edistar ! com>
Date:       2002-05-09 12:29:50
[Download RAW message or body]

The Compaq servers you indicated use the smart array controller which is
very very slow in storing data into hard disks. Are you using the RAID?

I suggest you to buy a controller with a larger write cache (the smart
array controller does not have w-cache)... You should note a large
performance progress...

Also do not forget to set fsync to false and to use the COPY command
whenever is possible...

Bye!
-- 
Doct. Eng. Denis Gasparin: denis@edistar.com
---------------------------
Programmer & System Administrator - Edistar srl


Il mer, 2002-05-08 alle 00:40, Samuel J. Sutjiono ha scritto:
> I tried to load data using insert statement to our new database server (Compaq \
> DL580, DL590, DL380 using SCSI driver) but it was very very slow.  The database \
> runs on Red Hat Linux 7.2 and PostgreSQL version 7.1.3   
> Does anybody know any idea to what cause this problem ? or things that I need to \
> look or check (in the config. file) 
> I appreciate any help.
> 
> Regards,
> Samuel



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


[prev in list] [next in list] [prev in thread] [next in thread]