Re: PostgreSQL database size is not reasonable

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: PostgreSQL database size is not reasonable
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Tue, 12 Dec 2017 08:21:14 -0700
Cc: PostgreSQL mailing lists <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <CA+t6e1=OQANSQ+vxUW8tR4hBPvnA=y4ThUToACejAoguex5dFA@mail.gmail.com>
References: <CA+t6e1=OQANSQ+vxUW8tR4hBPvnA=y4ThUToACejAoguex5dFA@mail.gmail.com>

On Tue, Dec 12, 2017 at 8:15 AM, Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> wrote:

A
nd the bigger question, Where are the missing 180G ?

In the toaster probably...

https://www.postgresql.org/docs/current/static/storage-toast.html

Basically large data values are store in another table different than both the main table and indexes.

David J.

Follow-Ups:
- Re: PostgreSQL database size is not reasonable
  - From: Tom Lane
- RE: PostgreSQL database size is not reasonable
  - From: Craig McIlwee

References:
- PostgreSQL database size is not reasonable
  - From: Mariel Cherkassky

Prev by Date: PostgreSQL database size is not reasonable
Next by Date: RE: PostgreSQL database size is not reasonable
Previous by thread: PostgreSQL database size is not reasonable
Next by thread: RE: PostgreSQL database size is not reasonable
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux