Optimizing queries that use temporary tables

From: "Luiz K(dot) Matsumura" <luiz(at)planit(dot)com(dot)br>
To: pgsql-performance(at)postgresql(dot)org
Subject: Optimizing queries that use temporary tables
Date: 2008-01-22 19:32:17
Message-ID: 479644C1.4070703@planit.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,

I'm developing some routines that will use temporary tables and need
advice on how to not lose performance.

I will insert data in a temporary table and use this data to generate
new sets that will update or add to the same temporary table.

I have some questions that I'm concerned about:

- I can create indexes on this temp table to optimize queries ?

If yes...
- This indexes will be destroyed together (automatic?) the temp table
when the connection is closed ?
- When I insert a lot of new rows, need to run analyze on this temporary
table ?

Thanks in Advance.

--
Luiz K. Matsumura
Plan IT Tecnologia Informática Ltda.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Luiz K. Matsumura 2008-01-22 19:44:33 Re: SELECT * FROM table is too slow
Previous Message Hannes Dorbath 2008-01-22 12:13:57 Re: 8.3 synchronous_commit