Re: Database over multiple drives

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