I'd say it's a little early to worry about a 10% performance increase
when you don't have any redundancy.  You might want to consider using
more, cheaper SATA disks - with more spindles you may very well get
better performance in addition to redundancy.

Anyway, here's an optimization project I just went through recently: the
old database was running all on a SAN attached RAID5 partition; moved
the indices to a local striped mirror set (faster disks too: 15K rpm),
moved the WAL files to a separate local two disk mirror, and spent a lot
of time tuning the config parameters (the old install was running the
conservative defaults).  All the hardware (apart from the additional
disks) is the same.  For some simple queries I saw as much as a 150X
speedup, though that's certainly not typical of the performance
improvement overall.  Most of this is likely due to the memory settings,
but faster disks certainly play a part.

In any case, it's hard to say what would improve performance for you
without knowing what kind of applications you are running and what sort
of load they see.


-----Original Message-----
[mailto:[EMAIL PROTECTED] On Behalf Of Alvaro
Nunes Melo
Sent: Wednesday, July 06, 2005 1:59 PM
To: PostgreSQL - Performance
Subject: [PERFORM] Storing data and indexes in different disks


I'm about to recommend a server model to a client, and I've read a in 
many places (including in this list) that  storing indexes in one disk 
and the rest of the database in other disk might increase the overall 
performance  of the system in about 10%.

Making this only by a symbolic link is enough, or there are any futher 
steps? We were thinking (for costs reasons) in use only 2 SCSI disks, 
without any level of RAID. Is this enough to achieve performance 
improvement mentioned above?

Best regards,

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material. Any 
review, retransmission, dissemination or other use of, or taking of any action 
in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact 
the sender and delete the material from any computer

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to