| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Joseph S <jks(at)selectacast(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: == PostgreSQL Weekly News - July 29 2007 == |
| Date: | 2007-08-03 03:27:29 |
| Message-ID: | 1643.1186111649@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce pgsql-general |
Joseph S <jks(at)selectacast(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2007-08-05 18:28:00 | == PostgreSQL Weekly News - August 05 2007 == |
| Previous Message | Joseph S | 2007-08-03 01:49:02 | Re: == PostgreSQL Weekly News - July 29 2007 == |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-08-03 03:42:21 | Re: index bloat WAS: reindexing pg_shdepend |
| Previous Message | Alvaro Herrera | 2007-08-03 03:19:51 | Re: What do people like to monitor (or in other words, what might be nice in pgsnmpd)? |