Re: json datatype and table bloat?
| От | John R Pierce |
|---|---|
| Тема | Re: json datatype and table bloat? |
| Дата | |
| Msg-id | 52701136.307@hogranch.com обсуждение исходный текст |
| Ответ на | Re: json datatype and table bloat? (Gregory Haase <haaseg@onefreevoice.com>) |
| Ответы |
Re: json datatype and table bloat?
Re: json datatype and table bloat? |
| Список | pgsql-general |
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 pagesDETAIL: 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
В списке pgsql-general по дате отправления: