Postgres Pro
Downloads
Home   >   mailing lists

Re: Curious question about physical files to store database - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Curious question about physical files to store database
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17C56915@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: Curious question about physical files to store database  (Patrick Dung <patrick_dkt@yahoo.com.hk>)
Responses Re: Curious question about physical files to store database
List pgsql-general
Tree view 
Patrick Dung wrote:
> I have seen some databases product that allocate small number of large files.
> 
> Please correct me if I am wrong:
> 
> MSSQL (one file is the data and another file for the transaction log)
> MySQL with InnoDB
> Oracle
> DB2

I don't know enough about DB2 and MSSQL, but you are correct
with regard to InnoDB and Oracle.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Junk date getting uploaded into date field
Next
From: Albe Laurenz
Date:
Subject: Re: WITH RECURSIVE doesn't work properly for me