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: 2BCEB9A37A4D354AA276774EE13FB8C2011306A1@mailserver.sandvine.com (view raw or flat)
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
16G
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

Responses

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-2014 The PostgreSQL Global Development Group