Re: Information about storge engine in PostgreSQL

nd02tsk(at)student(dot)hig(dot)se wrote:
> 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