Re: moving data between tables causes the db to overwhelm the system

From: Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>
To: "Kevin Kempter" <kevink(at)consistentstate(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: moving data between tables causes the db to overwhelm the system
Date: 2009-09-01 09:26:08
Message-ID: op.uzkm5umpcke6l8@soyouz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> 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

Did you create the indexes on the partition before or after inserting the
330M rows into it ?
What is your hardware config, where is xlog ?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Kempter 2009-09-01 09:32:32 Re: moving data between tables causes the db to overwhelm the system
Previous Message tv 2009-09-01 08:58:06 Re: moving data between tables causes the db to overwhelm the system