| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Patrick Dung <patrick_dkt(at)yahoo(dot)com(dot)hk> |
| Cc: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "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-07 21:33:45 |
| Message-ID: | 20131107213345.GA5613@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-11-07 23:00:33 | Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3? |
| Previous Message | Greg Burek | 2013-11-07 19:07:33 | Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3? |