I did the restart and it took seconds.
This was on a SSD.
BTW on ubuntu and debian i never use pg_ctl directly, postgresql-common has
a very nice CLI for this.
For the restart i used: sudo pg_ctlcluster --force 9.4 main restart
Thanks for all the good advice!
On Mon, Jan 27, 2020 at 10:15 PM Tom
Hi,
we are using luks/dmycrypt to encrypt our pgdata volumes.
On some standby/replication machines we see load peaks up to 15x of the
primary server.
If we remove the dmcrypt/luks and run it on a non-encrypted device this
does not happen.
We have tried to analyze this but could not find where the
Hi!
I ran into a problem which caused by wrong rows count planner expecting to get
when using ?| operator against jsonb field.
To illustrate the issue:
create table tbl_test (a jsonb);
insert into tbl_test(a)
select jsonb_build_object('val1', 1)
from generate_series(1, 10);
analyse tbl_tes
Other than creating a functional index on the keys that you most want to
access and include that function call in your query, I don't know that you
can. Functional indexes get statistics while partial indexes do not. If a
GIN index using path operator collected stats on the frequency of the keys,
t
