> 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
pgsql-performance by date
|Next:||From: Kevin Kempter||Date: 2009-09-01 09:32:32|
|Subject: Re: moving data between tables causes the db to overwhelm the system|
|Previous:||From: tv||Date: 2009-09-01 08:58:06|
|Subject: Re: moving data between tables causes the db to
overwhelm the system|