Sv: How can I set up Postgres to use given amount of RAM?

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Sv: How can I set up Postgres to use given amount of RAM?
Дата
Msg-id VisenaEmail.e9.dbfaaf5e44ccdcbb.181a3ead8f8@visena.app.internal.visena.net
обсуждение исходный текст
Ответ на How can I set up Postgres to use given amount of RAM?  ("W.P." <laurentp@wp.pl>)
Список pgsql-general
På søndag 26. juni 2022 kl. 20:40:01, skrev W.P. <laurentp@wp.pl>:
Question in topic:

"How can I set up Postgres to use given amount of RAM?"

I have now laptop with 8GB of RAM, i can see Linux uses no more than 2-3GB.

So my question is how to FORCE PostgreSQL

use let's say 2-4Ghow to B of RAM for caching tables  I run queries on?

As I can see disk actity running queries.


W.P..

The closest thing I can think of is effective_cache_size: https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-EFFECTIVE-CACHE-SIZE

 

 

--
Andreas Joseph Krogh
 

В списке pgsql-general по дате отправления:

Предыдущее
От: WR
Дата:
Сообщение: Re: Differences in Escaped bytea's when creating a plain pg_dump
Следующее
От: WR
Дата:
Сообщение: Re: Differences in Escaped bytea's when creating a plain pg_dump