On Jan 22, 2008 1:32 PM, Luiz K. Matsumura <luiz(at)planit(dot)com(dot)br> wrote:
> 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 ?
In response to
pgsql-performance by date
|Next:||From: Guillaume Smet||Date: 2008-01-23 00:57:07|
|Subject: Workaround for cross column stats dependency|
|Previous:||From: Joshua D. Drake||Date: 2008-01-22 20:19:21|
|Subject: Re: SELECT * FROM table is too slow|