From: Jeff Boes <jboes@nexcerpt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Performance on temp table inserts
Date: 20 May 2003 08:37:09 -0400
Message-ID: <1053434229.4973.1.camel@takin.private.nexcerpt.com> (raw)
In-Reply-To: <26320.1053406306@sss.pgh.pa.us>
References: <baba9i$2vi8$1@news.hub.org>
<26320.1053406306@sss.pgh.pa.us>
On Tue, 2003-05-20 at 00:51, Tom Lane wrote:
> Jeff Boes <jboes@nexcerpt.com> writes:
> > What factors affect the performance of a temp table insert?
>
> PG version would have a lot to do with that, considering how we've
> whacked around the temp-table implementation in the last few releases.
>
> > Hardware, O/S and PostgreSQL versions are all identical.
>
> And they are?
Red Hat Linux release 7.1 (Seawolf)
Kernel 2.4.18-17.7.xbigmem on a 2-processor i686
We have 4 GB of memory and a 53GB partition on a RAID device for the PG
data.
PG version is 7.2.4.
--
Jeff Boes vox 269.226.9550 ext 24
Database Engineer fax 269.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise
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-sql@postgresql.org
Cc: jboes@nexcerpt.com, tgl@sss.pgh.pa.us
Subject: Re: Performance on temp table inserts
In-Reply-To: <1053434229.4973.1.camel@takin.private.nexcerpt.com>
* 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