Re: Curious question about physical files to store database

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: Patrick Dung <patrick_dkt(at)yahoo(dot)com(dot)hk>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Curious question about physical files to store database
Date: 2013-11-05 14:51:33
Message-ID: A737B7A37273E048B164557ADEF4A58B17C56915@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-11-05 14:52:49 Re: WITH RECURSIVE doesn't work properly for me
Previous Message Tom Lane 2013-11-05 14:45:54 Re: Junk date getting uploaded into date field