Postgres Pro
Downloads
Home   >   mailing lists

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

From David W Noon
Subject Re: Performance on temp table inserts
Date
Msg-id 4d5op-4h3.ln1@my-pc.ntlworld.com
Whole thread Raw
In response to Performance on temp table inserts  (Jeff Boes <jboes@nexcerpt.com>)
List pgsql-sql
Tree view 
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.
======================================================

pgsql-sql by date:

Previous
From: "Stefano Vita Finzi"
Date:
Subject: plpgsql recursion
Next
From: Rajendran
Date:
Subject: Inquiry From Form [pgsql]