1

Topic: How to force postgresql there is a storage?

Good afternoon.
Delivered parameter shared_bufers 4 Gb.
And  does not want 4 Gb is.
Total Private of storage of all its processes 10 times less sad((
I look in RamMap and in the manager of tasks.
OS  the server, storages of 16 Gb.
Prompt as postgres to force to eat storage?

2

Re: How to force postgresql there is a storage?

the Elephant wrote:

Prompt as postgres to force to eat storage?

to update. Not clearly unless?

3

Re: How to force postgresql there is a storage?

mefman wrote:

it is passed...
to update. Not clearly unless?

More in detail please...

4

Re: How to force postgresql there is a storage?

In general,   faster than  sad((
Delivered it 5, restarted.
Minutes 20 transited, and it so 5  and not  though it is free (free) 7 Gb at present....

5

Re: How to force postgresql there is a storage?

the Elephant wrote:

in general,   faster than  sad((
Delivered it 5, restarted.
Minutes 20 transited, and it so 5  and not  though it is free (free) 7 Gb at present....

The basis less 5GB can at you or that data set to which actively address less 5GB?
--
Maxim Boguk
the best support PostgreSQL: dataegret.ru

6

Re: How to force postgresql there is a storage?

Maxim Boguk wrote:

it is passed...
The basis less 5GB can at you or that data set to which actively address less 5GB?
--
Maxim Boguk
the best support PostgreSQL: dataegret.ru

Basis 250.
And the Windows cache DB files on gigabytes.

7

Re: How to force postgresql there is a storage?

What OS?
The server virtual or physical?
Screen of the manager of tasks?

8

Re: How to force postgresql there is a storage?

the Elephant wrote:

it is passed...
Basis 250.
And the Windows cache DB files on gigabytes.

Put pg_buffercache extension
https://www.postgresql.org/docs/10/stat … cache.html
Also show us allocation than they are occupied from you...
Then it will be possible that that clever to tell on a subject really is not used or you not that and not there look.
For example through
SELECT
usagecount, count (*), isdirty
FROM public.pg_buffercache
GROUP BY isdirty, usagecount
ORDER BY isdirty, usagecount
Otherwise here in blind it will be possible to argue indefinitely.
--
Maxim Boguk
the best support PostgreSQL: dataegret.ru