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.