| From: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
|---|---|
| To: | "W(dot)P(dot)" <laurentp(at)wp(dot)pl> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Sv: How can I set up Postgres to use given amount of RAM? |
| Date: | 2022-06-27 06:50:42 |
| Message-ID: | VisenaEmail.e9.dbfaaf5e44ccdcbb.181a3ead8f8@visena.app.internal.visena.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
På søndag 26. juni 2022 kl. 20:40:01, skrev W.P. <laurentp(at)wp(dot)pl
<mailto:laurentp(at)wp(dot)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
<https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-EFFECTIVE-CACHE-SIZE>
--
Andreas Joseph Krogh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | WR | 2022-06-27 07:21:23 | Re: Differences in Escaped bytea's when creating a plain pg_dump |
| Previous Message | WR | 2022-06-27 06:44:59 | Re: Differences in Escaped bytea's when creating a plain pg_dump |