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

From Martijn van Oosterhout
Subject Re: Curious question about physical files to store database
Date
Msg-id 20131107213345.GA5613@svana.org
Whole thread Raw
In response to Re: Curious question about physical files to store database  (Patrick Dung <patrick_dkt@yahoo.com.hk>)
List pgsql-general
On Tue, Nov 05, 2013 at 10:42:36PM +0800, Patrick Dung wrote:
> I have seen some databases product that allocate small number of large files.
>
> Please correct me if I am wrong:
>
> MySQL with InnoDB

Actually, InnoDB has a file-per-table mode which I tend to prefer. It
means that when I drop a partition I actually see the disk usage drop.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.
   -- Arthur Schopenhauer

Attachment

pgsql-general by date:

Previous
From: Greg Burek
Date:
Subject: Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3?
Next
From: Adrian Klaver
Date:
Subject: Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3?