Need a hardware optimization pointer

[Daniel Fitzgerald <dfitzgeraldca@sympatico.ca>]

Hi all, I need some pointers. I want to optimize my pgsql databases 
hardware-wise. I can do this in Sybase, Oracle, SQL Server, etc. by 
putting let's say, indexes on one device, the trasaction logs on 
another, data on another drive, etc. Can I do this in Postgresql ? I 
have only used the simple

CREATE DATABASE newdatabase ( didn't find an alternate syntax ) so far.

Is it possible to do a specific component optimization or do I just 
create a stripe set across all drives and hope for the best ? Anyone 
have experience in this ? Any comments appreciated - thanks in advance.




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org