ay, August 30, 2012 11:11 AM
To: Liron Shiri
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Investigating the reason for a very big TOAST table size
On Mon, Aug 27, 2012 at 11:24 PM, Liron Shiri wrote:
> There were no "hot standby" configuration, but the DB has s
To: Liron Shiri
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Investigating the reason for a very big TOAST table size
On Sun, Aug 26, 2012 at 5:46 AM, Liron Shiri wrote:
> Hi,
>
>
>
> We have a table which its TOAST table size is 66 GB, and we believe
> should be sm
Hi,
We have a table which its TOAST table size is 66 GB, and we believe should be
smaller.
The table size is 472 kb. And the table has 4 columns that only one of them
should be toasted.
The table has only 8 dead tuples, so apparently this is not the problem.
This table contains a column with b
From: Liron Shiri
Sent: Sunday, August 26, 2012 3:47 PM
To: 'pgsql-performance@postgresql.org'
Subject: Investigating the reason for a very big TOAST table size
Importance: High
Hi,
We have a table which its TOAST table size is 66 GB, and we believe should be
smaller.
The table size
