From: Alvaro Herrera <alvherre@commandprompt.com>
To: samantha mahindrakar <sam.mahindrakar@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance with temporary table
Date: Tue, 8 Apr 2008 15:43:10 -0400
Message-ID: <20080408194310.GP9062@alvh.no-ip.org> (raw)
In-Reply-To: <f0c828c40804081228x6e1edf2l881fe0725f1a5504@mail.gmail.com>
References: <f0c828c40804071127u512a5f89ka7866a148e3c7c21@mail.gmail.com>
<20080408161745.GB9062@alvh.no-ip.org>
<f0c828c40804081228x6e1edf2l881fe0725f1a5504@mail.gmail.com>
samantha mahindrakar escribió:
> Well instead of creating a temp table everytime i just created a
> permanant table and insert the data into it everytime and truncate it.
> I created indexes on this permanent table too. This did improve the
> performance to some extent.
>
> Does using permanant tables also bloat the catalog or hinder the performance?
In terms of catalog usage, permanent tables behave exactly the same as
temp tables.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@commandprompt.com, sam.mahindrakar@gmail.com
Subject: Re: Performance with temporary table
In-Reply-To: <20080408194310.GP9062@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox