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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Tobias Brox 2006-09-26 19:35:53 Merge Join vs Nested Loop
Previous Message Mark Lewis 2006-09-25 22:28:24 Re: Decreasing BLKSZ