Re: Adding and filling new column on big table

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Adding and filling new column on big table
Дата
Msg-id cone.1149009935.943516.71610.5001@35st-server.simplicato.com
обсуждение исходный текст
Ответ на Re: Adding and filling new column on big table  ("Jonathan Blitz" <jb@anykey.co.il>)
Ответы Re: Adding and filling new column on big table  ("Jonathan Blitz" <jb@anykey.co.il>)
Список pgsql-performance
Jonathan Blitz writes:

> Nope. Didn't think it would make any difference.

May be worth a try.

> I am using a laptop :).
> Pentium 4 (not 4M) with 1GB of memory - 2 MHZ

Most laptop drives are only 5,400 RPM which would make a transaction like
you are describing likely take a while.

> Must do it on  that since the program is aimed for use at home.

No desktop at home you could try it on?
I think the problem with the laptop is likely it's drive.


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

Предыдущее
От: "mcelroy, tim"
Дата:
Сообщение: Re: pg_dump issue
Следующее
От: "Daniel J. Luke"
Дата:
Сообщение: Re: Getting even more insert performance (250m+rows/day)