Re: performance of temporary vs. regular tables

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Joachim Worringen <joachim(dot)worringen(at)iathh(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: performance of temporary vs. regular tables
Date: 2010-05-25 08:49:13
Message-ID: AANLkTik4_exB6U3GlfLMNIgPSk0G3RVQ8fWBTzwekrke@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

temporary tables are handled pretty much like the regular table. The
magic happens on schema level, new schema is setup for connection, so
that it can access its own temporary tables.
Temporary tables also are not autovacuumed.
And that's pretty much the most of the differences.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joachim Worringen 2010-05-25 09:00:24 Re: performance of temporary vs. regular tables
Previous Message Joachim Worringen 2010-05-25 07:59:56 performance of temporary vs. regular tables