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

Re: Decreasing BLKSZ

From: "Marc Morin" <marc(at)sandvine(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Markus Schaber" <schabi(at)logix-tt(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Decreasing BLKSZ
Date: 2006-09-26 00:29:37
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
> 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 BroxDate: 2006-09-26 19:35:53
Subject: Merge Join vs Nested Loop
Previous:From: Mark LewisDate: 2006-09-25 22:28:24
Subject: Re: Decreasing BLKSZ

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