Re: two questions about toast

On 11/15/20 9:03 AM, Luca Ferrari wrote:
> 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?

https://www.postgresql.org/docs/current/sql-reindex.html

"DATABASE

     Recreate all indexes within the current database. Indexes on shared 
system catalogs are also processed. This form of REINDEX cannot be 
executed inside a transaction block.
"

"TABLE

     Recreate all indexes of the specified table. If the table has a 
secondary “TOAST” table, that is reindexed as well.
"

Database --> Table --> TOAST table.

> 2) while executing a query against toasted values I got this debug
> message that I don't know what is meaning

This happened when you where doing the REINDEX DATABASE?

> 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
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com