Does mysql have the same option where you can it allow for tables and indexes to be stored on different (or the same) filesystems.

Or should I use PostgreSQL? Is PostgreSQL suitable for more high end sites? I am making a site that will be database intensive and I want an open source database. Thanks