Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group