Re: [GENERAL] Information about storge engine in PostgreSQL

2004-10-22 Thread nd02tsk
I really appreciate these type of high-quality anwsers, thank you. Tim > On 10/21/2004 10:27 AM, [EMAIL PROTECTED] 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

Re: [GENERAL] Information about storge engine in PostgreSQL

2004-10-21 Thread Jan Wieck
On 10/21/2004 10:27 AM, [EMAIL PROTECTED] 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 th

Re: [GENERAL] Information about storge engine in PostgreSQL

2004-10-21 Thread Karsten Hilbert
> 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. Hm. How about reading the standard PostgreSQL documentation ? It at least depends on

Re: [GENERAL] Information about storge engine in PostgreSQL

2004-10-21 Thread Richard Huxton
[EMAIL PROTECTED] 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, Pos

Re: [GENERAL] Information about storge engine in PostgreSQL

2004-10-21 Thread Kevin Barnard
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 direct

Re: [GENERAL] Information about storge engine in PostgreSQL

2004-10-21 Thread Andrew Sullivan
On Thu, Oct 21, 2004 at 04:27:24PM +0200, [EMAIL PROTECTED] wrote: > Hello > > MySQL has information about several storage engines. I think you will find fairly broad agreement around here that the idea of different storage engines for different jobs is a bad one. But to answer your question. .

[GENERAL] Information about storge engine in PostgreSQL

2004-10-21 Thread nd02tsk
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