From: | Gregory Haase <haaseg(at)onefreevoice(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: json datatype and table bloat? |
Date: | 2013-10-29 20:20:50 |
Message-ID: | CAHA6QFRZ2XRfuUx8mDKG9WeHSviCPN8sxtTcf+iquKxeJWDSDg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
One more thing I just tried:
create table table_schema.table_name_new (like table_schema.table_name);
insert into table_schema.table_name_new select * from table_schema.table_
name;
The new tables shows the same amount of wasted bytes and pages as the old.
So I think based on that I'm going to throw out any notion of updates or
deletes as cause for bloat on this particular table.
-G
On Tue, Oct 29, 2013 at 12:53 PM, Gregory Haase <haaseg(at)onefreevoice(dot)com>wrote:
> So, between yesterday and today we actually failed over to our hot-standby
> instance and the issue hasn't changed. I don't think you can have a pending
> transaction across streaming replication.
>
>
> On Tue, Oct 29, 2013 at 12:49 PM, John R Pierce <pierce(at)hogranch(dot)com>wrote:
>
>> On 10/29/2013 12:41 PM, Gregory Haase wrote:
>>
>> db_name=# VACUUM FULL VERBOSE table_schema.table_name;
>> INFO: vacuuming "table_schema.table_name"
>> INFO: "table_name": found 2 removable, 29663 nonremovable row versions
>> in 1754 pages
>> DETAIL: 0 dead row versions cannot be removed yet.
>> CPU 0.07s/0.10u sec elapsed 0.30 sec.
>>
>>
>> is there an old transaction pending? that 'masks' vacuum from touching
>> any tuples newer than the start of that transaction.
>>
>>
>>
>> --
>> john r pierce 37N 122W
>> somewhere on the middle of the left coast
>>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-10-29 20:51:54 | Re: json datatype and table bloat? |
Previous Message | Gregory Haase | 2013-10-29 19:53:49 | Re: json datatype and table bloat? |