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

From: "W(dot)P(dot)" <laurentp(at)wp(dot)pl>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: How can I set up Postgres to use given amount of RAM?
Date: 2022-06-26 18:40:01
Message-ID: e55db013-f6a8-4efd-2fce-f9f26b1029cc@wp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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..

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zahid Rahman 2022-06-26 22:49:38 Re: How can I set up Postgres to use given amount of RAM?
Previous Message Alvaro Herrera 2022-06-26 17:50:27 Re: Support logical replication of DDLs