Re: Adding and filling new column on big table

Поиск
Список
Период
Сортировка
От Jonathan Blitz
Тема Re: Adding and filling new column on big table
Дата
Msg-id 012501c6842c$bb8438f0$ddf71005@jonathanlaptop
обсуждение исходный текст
Ответ на Re: Adding and filling new column on big table  (Francisco Reyes <lists@stringsutils.com>)
Ответы Re: Adding and filling new column on big table  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Adding and filling new column on big table  (PFC <lists@peufeu.com>)
Список pgsql-performance
>
> Most laptop drives are only 5,400 RPM which would make a transaction like
> you are describing likely take a while.

Not sure what my one is but it is new(ish).

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

I suppose I could do but I need to install PostgreSQL there and then copy
over the database.
Maybe I will give it a try.

Jonathan

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.7.4/351 - Release Date: 05/29/2006



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

Предыдущее
От: "Daniel J. Luke"
Дата:
Сообщение: Re: Getting even more insert performance (250m+rows/day)
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Adding and filling new column on big table