Re: import performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: import performance
Дата
Msg-id 12028.1142301081@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: import performance  (Chris <dmagick@gmail.com>)
Ответы Re: import performance  (Chris <dmagick@gmail.com>)
Список pgsql-performance
Chris <dmagick@gmail.com> writes:
> Tons of difference :/

Have you checked that the I/O performance is comparable?  It seems
possible that there's something badly misconfigured about the disks
on your new machine.  Benchmarking with "bonnie" or some such would
be useful; also try looking at "iostat 1" output while running the
inserts on both machines.

Also, are the inserts just trivial "insert values (... some constants ...)"
or is there more to it than that?

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Chris
Дата:
Сообщение: Re: import performance
Следующее
От: Frank Wiles
Дата:
Сообщение: Re: import performance