moving data between tables causes the db to overwhelm the system

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: moving data between tables causes the db to overwhelm the system
Date: 2009-09-01 08:45:58
Message-ID: 200909010245.58088.kevink@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message tv 2009-09-01 08:58:06 Re: moving data between tables causes the db to overwhelm the system
Previous Message Alvaro Herrera 2009-09-01 02:59:41 Re: BUG #4919: CREATE USER command slows down system performance