Re: Performance on temp table inserts

Поиск
Список
Период
Сортировка
От David W Noon
Тема Re: Performance on temp table inserts
Дата
Msg-id 4d5op-4h3.ln1@my-pc.ntlworld.com
обсуждение исходный текст
Ответ на Performance on temp table inserts  (Jeff Boes <jboes@nexcerpt.com>)
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: "Stefano Vita Finzi"
Дата:
Сообщение: plpgsql recursion
Следующее
От: Rajendran
Дата:
Сообщение: Inquiry From Form [pgsql]