Re: Performance on temp table inserts

On Monday 19 May 2003 20:11 in <baba9i$2vi8$1(at)news(dot)hub(dot)org>, Jeff Boes
(jboes(at)nexcerpt(dot)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(at)spamtrap(dot)ntlworld(dot)com (David W Noon)
Remove spam trap to reply via e-mail.
======================================================