Re: Decreasing BLKSZ

Поиск
Список
Период
Сортировка
От Marc Morin
Тема Re: Decreasing BLKSZ
Дата
Msg-id 2BCEB9A37A4D354AA276774EE13FB8C2011306A1@mailserver.sandvine.com
обсуждение исходный текст
Ответ на Re: Decreasing BLKSZ  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Decreasing BLKSZ
Re: Decreasing BLKSZ
Список 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 по дате отправления:

Предыдущее
От: Mark Lewis
Дата:
Сообщение: Re: Decreasing BLKSZ
Следующее
От: Tobias Brox
Дата:
Сообщение: Merge Join vs Nested Loop