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

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

From
"W.P."
Date:
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..




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

From
Zahid Rahman
Date:


On Sun, 26 Jun 2022, 11:40 pm W.P., <laurentp@wp.pl> wrote:
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..



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

From
Mladen Gogala
Date:
On 6/26/22 14:40, W.P. wrote:
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..



I would try docker with --memory option. An alternative is to create a VM with the given amount of memory. If your laptop is memory starved, then creating a VM is probably not an option. Docker is much cheaper. Dockerfile is relatively simple to master and you can use Docker to run almost anything.

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

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

From
Andreas Joseph Krogh
Date:
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