Re: Information about storge engine in PostgreSQL

nd02tsk@student.hig.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