From: David W Noon <dwnoon@spamtrap.ntlworld.com>
To: pgsql-sql@postgresql.org
Subject: Re: Performance on temp table inserts
Date: Tue, 20 May 2003 00:19:32 +0100
Message-ID: <4d5op-4h3.ln1@my-pc.ntlworld.com> (raw)
References: <baba9i$2vi8$1@news.hub.org>
On Monday 19 May 2003 20:11 in <baba9i$2vi8$1@news.hub.org>, Jeff Boes
(jboes@nexcerpt.com) wrote:
> What factors affect the performance of a temp table insert?
I would run an EXPLAIN on each of the two servers and see what differences
there are in the respective execution strategies.
Also, a VACUUM ANALYZE might be of interest to speed up the slower box.
--
Regards,
Dave [RLU#314465]
======================================================
dwnoon@spamtrap.ntlworld.com (David W Noon)
Remove spam trap to reply via e-mail.
======================================================
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: dwnoon@spamtrap.ntlworld.com
Subject: Re: Performance on temp table inserts
In-Reply-To: <4d5op-4h3.ln1@my-pc.ntlworld.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