On Sun, Jul 4, 2021 at 1:20 PM Adrian Klaver
wrote:
>
> In any case I don't see you getting a 9.5 version on the laptop in the
> package directories. Pretty sure the Fedora 30 repos will not have 9.5
> and the Postgres repos don't go back to Fedora 30. So if you want a 9.5
> instance you will nee
On 7/5/21 4:22 PM, Emiliano Saenz wrote:
Hello!
We have a huge POSTGRES 9.4 database in the production environment
(several tables have more than 100.000.00 registers). Last two months we
have had problems with CPU utilization. Debugging the locks (on
pg_locks) we notice that sometimes simple
Hello!
We have a huge POSTGRES 9.4 database in the production environment (several
tables have more than 100.000.00 registers). Last two months we have had
problems with CPU utilization. Debugging the locks (on pg_locks) we notice
that sometimes simple UPDATE (by primary key) operation takes out
AC
On Mon, 5 Jul 2021 at 14:29, Avi Weinberg wrote:
> Thanks for the reply,
>
>
>
> My question was, what will happen if I have one destination table which
> gets data from many source tables. What is the best way to handle changes
> in the structure of SOME of the source tables, while other source
Hi ,
As I mentioned in my mail that there is no replication configured and
no archival is lagging.
my query is simple.
How to to reduce the number of wal file from 4000 to 100 in an
independent server ?
Regards.
On 7/5/21, hubert depesz lubaczewski wrote:
> On Mon, Jul 05, 2021 at 03:18:14P
hi,
(on postgres 9.6) I was just practicing to make my no. of wal files in
pg_xlog directory to be the same/equal as I pass on wal_keep_segments
paramater.
say for example
show wal_keep_segments;
wal_keep_segments
---
125
so I want my wal files should not be grow in numbers mo
On Mon, Jul 05, 2021 at 03:18:14PM +0530, Atul Kumar wrote:
> I have postgres 9.6 running server on centos 7, the number of wal file
> in pg_xlog directory is above 4000 so to save some disk space, I
> thought of reducing to 100.
...
> Please suggest when the number of wal files will be reduced to
Hi,
I have postgres 9.6 running server on centos 7, the number of wal file
in pg_xlog directory is above 4000 so to save some disk space, I
thought of reducing to 100.
but there is no reduction in numbers.
Please not that there is no replication is configured, the server is
independent.
What I
Thanks for the reply,
My question was, what will happen if I have one destination table which gets
data from many source tables. What is the best way to handle changes in the
structure of SOME of the source tables, while other source tables remain in the
old format.
Maybe in some cases where t
