Re: Information about storge engine in PostgreSQL

From: Kevin Barnard <kevin(dot)barnard(at)gmail(dot)com>
To: "nd02tsk(at)student(dot)hig(dot)se" <nd02tsk(at)student(dot)hig(dot)se>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Information about storge engine in PostgreSQL
Date: 2004-10-21 14:42:53
Message-ID: b068057c04102107422dcb9e90@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

PostgreSQL uses it's own internal storage engine. It doesn not
support multiple one. As for splitting files accross partitions this
is a feature of version 8.0 called tablespaces.

http://developer.postgresql.org/docs/postgres/manage-ag-tablespaces.html

Should get you pointed in the right direction.

On Thu, 21 Oct 2004 16:27:24 +0200 (CEST), nd02tsk(at)student(dot)hig(dot)se
<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.
>
> Do you know of any places where this information can be obtained?
>
> Thank you.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2004-10-21 14:43:50 Re: Information about storge engine in PostgreSQL
Previous Message Henry Combrinck 2004-10-21 14:34:07 Is it possible to remove the public schema?