Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance on temp table inserts - Mailing list pgsql-sql

From Jeff Boes
Subject Re: Performance on temp table inserts
Date
Msg-id 1053434229.4973.1.camel@takin.private.nexcerpt.com
Whole thread Raw
In response to Re: Performance on temp table inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Performance on temp table inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: Drop CONSTRAINT
Next
From: "Eric Anderson Vianet SAO"
Date:
Subject: missing chunk number 0 for toast value 32067496