> The bottom line here is likely to be "you need more RAM" :-(
Yup. Just trying to get a handle on what I can do if I need more than
Of ram... That's as much as I can put on the installed based of
servers.... 100s of them.
> I wonder whether there is a way to use table partitioning to
> make the insert pattern more localized? We'd need to know a
> lot more about your insertion patterns to guess how, though.
> regards, tom lane
We're doing partitioning as well.....
In response to
pgsql-performance by date
|Next:||From: Tobias Brox||Date: 2006-09-26 19:35:53|
|Subject: Merge Join vs Nested Loop|
|Previous:||From: Mark Lewis||Date: 2006-09-25 22:28:24|
|Subject: Re: Decreasing BLKSZ|