moving data between tables causes the db to overwhelm the system

Поиск
Список
Период
Сортировка
От Kevin Kempter
Тема moving data between tables causes the db to overwhelm the system
Дата
Msg-id 200909010245.58088.kevink@consistentstate.com
обсуждение исходный текст
Ответы Re: moving data between tables causes the db to overwhelm the system  (tv@fuzzy.cz)
Re: moving data between tables causes the db to overwhelm the system  (Pierre Frédéric Caillaud<lists@peufeu.com>)
Список pgsql-performance
Hi all;

We have a table that's > 2billion rows big and growing fast.  We've setup
monthly partitions for it. Upon running the first of many select * from
bigTable insert into partition statements (330million rows per month) the
entire box eventually goes out to lunch.

Any thoughts/suggestions?

Thanks in advance

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

Предыдущее
От: Mike Ivanov
Дата:
Сообщение: Re: Number of tables
Следующее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: moving data between tables causes the db to overwhelm the system