Re: Rebuild pg_toast from scratch?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Rebuild pg_toast from scratch?
Date: 2019-09-05 16:37:55
Message-ID: 28817.1567701475@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it> writes:
> Il 05/09/19 15:53, Tom Lane ha scritto:
>> TRUNCATE ought to be enough.

> ... or do I need to truncate the "master" table (the table blobs are in)?

Yeah, that one.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ray Cote 2019-09-05 19:25:56 Environment Variable for --data-checksum during initdb
Previous Message Lu, Dan 2019-09-05 16:24:45 RE: postgresql: Help with hstore hextension