Re: Decreasing BLKSZ - Mailing list pgsql-performance

From Marc Morin
Subject Re: Decreasing BLKSZ
Date
Msg-id 2BCEB9A37A4D354AA276774EE13FB8C2011306A1@mailserver.sandvine.com
Whole thread Raw
In response to Re: Decreasing BLKSZ  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Decreasing BLKSZ  ("Bucky Jordan" <bjordan@lumeta.com>)
Re: Decreasing BLKSZ  (Markus Schaber <schabi@logix-tt.com>)
List 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.....
>

pgsql-performance by date:

Previous
From: Mark Lewis
Date:
Subject: Re: Decreasing BLKSZ
Next
From: Tobias Brox
Date:
Subject: Merge Join vs Nested Loop