pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Storing data and indexes in different disks 2+ messages / 2 participants [nested] [flat]
* Storing data and indexes in different disks @ 2005-07-06 17:58 Alvaro Nunes Melo <al_nunes@atua.com.br> 0 siblings, 0 replies; 2+ messages in thread From: Alvaro Nunes Melo @ 2005-07-06 17:58 UTC (permalink / raw) To: pgsql-performance Hi, 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, Alvaro ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Storing data and indexes in different disks @ 2005-07-06 18:46 Dmitri Bichko <dbichko@aveopharma.com> 0 siblings, 0 replies; 2+ messages in thread From: Dmitri Bichko @ 2005-07-06 18:46 UTC (permalink / raw) To: Alvaro Nunes Melo <al_nunes@atua.com.br>; pgsql-performance 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. Dmitri -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] 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 Hi, 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, Alvaro ---------------------------(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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-07-06 18:46 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-07-06 17:58 Storing data and indexes in different disks Alvaro Nunes Melo <al_nunes@atua.com.br> 2005-07-06 18:46 Re: Storing data and indexes in different disks Dmitri Bichko <dbichko@aveopharma.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