Hi all,
We are new to Kubernetes. Our application is in C++ and it is connecting to
postgres server.
We are facing problems during sending traffic to postgres server. Initially it
is running fine.
When we restarting the container it hanged. We took tcpdump. After analyzing
the dump we found th
On Tue, 2020-01-21 at 11:18 +0100, Ekaterina Amez wrote:
[about wal_keep_segments]
> I'm not sure how to figure this value . Of course I could use a big
> value and forget, but as the server is running out of space I'd like to
> adjust it so there is (almost) no waste of space. This is why I be
We also reverted this param :
cmdv3=# show max_parallel_workers_per_gather;
max_parallel_workers_per_gather
-
2
(1 row)
It was set to 8.
Il giorno mar 21 gen 2020 alle ore 16:06 Nicola Contu <
nicola.co...@gmail.com> ha scritto:
> Hey Thomas,
> after a few mon
On 1/21/20 12:55 AM, Eric Veldhuyzen wrote:
Ron wrote:
On 1/21/20 1:10 AM, Eric Veldhuyzen wrote:
Hi,
We are using pgbackrest (2.21) to backup out postgresql (11) clusters.
Last night our nightly diff backup gave me the
ERROR: unable to convert base 10 string '000B' to unsigned int.
I trie
Hey Thomas,
after a few months, we started having this issue again.
So we revert the work_mem parameter to 600MB instead of 2GB.
But the issue is still there. A query went to segmentation fault, the DB
went to recovery mode and our app went to read only for a few minutes.
I understand we can incre
Hello,
I tried to call drop index on a big table(around 3 million records)
through non-multi thread script, and got deadlock.
Same drop index command in the same script on a smaller size table no
deadlock returned.
May I know that may cause the problem please?
Thanks a lot.
[Block info]
El 21/1/20 a las 10:14, Laurenz Albe escribió:
On Mon, 2020-01-20 at 14:59 +0100, Ekaterina Amez wrote:
PS: Just in case anyone wants to know, this is part of the process of upgrade a
server with 9.2 version
that has no free space in PGDATA and that can't be stopped for much time. After
aski
On Mon, 2020-01-20 at 14:59 +0100, Ekaterina Amez wrote:
> PS: Just in case anyone wants to know, this is part of the process of upgrade
> a server with 9.2 version
> that has no free space in PGDATA and that can't be stopped for much time.
> After asking here, the strategy
> to upgrade will be:
On Tue, Jan 21, 2020 at 08:10:39AM +0100, Eric Veldhuyzen wrote:
> We are using pgbackrest (2.21) to backup out postgresql (11) clusters.
> Last night our nightly diff backup gave me the
> ERROR: unable to convert base 10 string '000B' to unsigned int.
> I tried if a full backup would fix this,