two questions about toast - Mailing list pgsql-general

From Luca Ferrari
Subject two questions about toast
Date
Msg-id CAKoxK+5x9J74Sn=rvGSu4dAkSdpF=9AoTjs9-KmnSGd6c03SxQ@mail.gmail.com
Whole thread Raw
Responses Re: two questions about toast  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi all,
I've a couple of doubts about toast:
1) is a REINDEX DATABASE hitting also toast tables or they need to be
reindexed manually?
2) while executing a query against toasted values I got this debug
message that I don't know what is meaning
DEBUG:  building index "pg_toast_33875_index" on table "pg_toast_33875" serially

The query I was executing was:
SELECT  lower( f::text )  ||  lower( t::text )  FROM crashy_table
WHERE id = '16385'
via a plpgsql PERFORM.

Thanks,
Luca



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: New "function tables" in V13 documentation
Next
From: Adrian Klaver
Date:
Subject: Re: New "function tables" in V13 documentation