Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I set up Postgres to use given amount of RAM? - Mailing list pgsql-general

From Mladen Gogala
Subject Re: How can I set up Postgres to use given amount of RAM?
Date
Msg-id f60cb360-57b2-a41e-c8a9-08a65be1f77a@gmail.com
Whole thread Raw
In response to How can I set up Postgres to use given amount of RAM?  ("W.P." <laurentp@wp.pl>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Zahid Rahman
Date:
Subject: Re: How can I set up Postgres to use given amount of RAM?
Next
From: Michael Paquier
Date:
Subject: Re: Postgresql error : PANIC: could not locate a valid checkpoint record