Hello
MySQL has information about several storage engines. MEMORY to handle temporary tables, InnoDB to handle transactions and which also can split its table data over several files/partitions. Splitting of storage is something which according to the following article, PostgreSQL does not support:
http://www.devx.com/dbzone/Article/20743
But I cannot verify this due to lack of information. I haven't found any similar information about the storage engine used by PostgreSQL which I think is called Postgres.
PostgreSQL has one and only one storage engine. Unless you intend working on the source-code of PostgreSQL itself there's no point in enquiring about its details.
A database is already split over several files, and individual objects (tables/indexes) may be split into multiple files of 1GB each. You can spread the load over multiple drives via various RAID setups, symlinks or, in 8.0 tablespaces.
HTH
PS - treat most articles you read on the web with some caution. Most are poorly researched by people without the experience to write their topic. I haven't read the article linked above.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
