Postgres Pro
Downloads
Home   >   mailing lists

Re: == PostgreSQL Weekly News - July 29 2007 == - Mailing list pgsql-general

From Tom Lane
Subject Re: == PostgreSQL Weekly News - July 29 2007 ==
Date
Msg-id 1643.1186111649@sss.pgh.pa.us
Whole thread Raw
In response to Re: == PostgreSQL Weekly News - July 29 2007 ==  (Joseph S <jks@selectacast.net>)
List pgsql-general
Tree view 
Joseph S <jks@selectacast.net> writes:
> David Fetter wrote:
>> - Arrange to put TOAST tables belonging to temporary tables into
>> special schemas named pg_toast_temp_nnn, alongside the pg_temp_nnn

> Does this apply to indexes on temp tables as well?  Or is this not even
> an issue with indexes?

Indexes always live in the same schema as their parent table.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: What do people like to monitor (or in other words, what might be nice in pgsnmpd)?
Next
From: Tom Lane
Date:
Subject: Re: index bloat WAS: reindexing pg_shdepend