You can't do it with Postgres. To do it, Postgres must implement
"tablespaces" to spread the database in different localizations (who can be
different physical localizations, of course). Then a table can be assigned
to a tablespace.
If the RDBMS implements partitions also, you can distribute a table (by
rows) in different tablespaces. Of course it can improve the perfomance by
reducing the I/O operations.
>Hi all,
>
>Can I spread a database over multiple physical drives? I want to put temp
>files somewhere, some tables somewhere, some other tables somewhere else
>etc. Is this possible? Why? My db is growing at an enormous rate, last
>month, it didn't exist, now it's 530 MB - and that's just one client, we're
>expecting about 50 clients by year end.
>
>Best regards,
>Chris
>
>
>_________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html