On 5/16/24 08:59, HORDER Philip wrote:
Classified as: {OPEN}
Adrian,
Still your contention was that autovacuum quit running after the initial
restore and that is not the case
This Postgres server has been restarted a few times since 2nd May most recently
on Tuesday 14th, hence the more
Classified as: {OPEN}
Adrian,
> Still your contention was that autovacuum quit running after the initial
> restore and that is not the case
This Postgres server has been restarted a few times since 2nd May most recently
on Tuesday 14th, hence the more recent analyze status.
We've had some
On 5/16/24 07:38, HORDER Philip wrote:
Classified as: {OPEN}
Did you have chance to do below?
Using psql do
\x
select * from pg_stat_all_tables where relname = 'a.accp';
Sorry, missed that bit.
From this output you can see that no stats have been collected since the last
two overnight up
Classified as: {OPEN}
> Did you have chance to do below?
> Using psql do
> \x
> select * from pg_stat_all_tables where relname = 'a.accp';
Sorry, missed that bit.
From this output you can see that no stats have been collected since the last
two overnight updates.
postgres=# select * from pg_st
On 5/16/24 03:08, HORDER Philip wrote:
Classified as: {OPEN}
--oids have not been supported with pg_dump since v11
You're absolutely correct, this command came from my notes, which are obviously
out of date.
We're running Postgres 15 pg_dump, and I've updated my notes.
I'm double-checking t
Classified as: {OPEN}
> --oids have not been supported with pg_dump since v11
You're absolutely correct, this command came from my notes, which are obviously
out of date.
We're running Postgres 15 pg_dump, and I've updated my notes.
I'm double-checking the command options with the guy who creat
Hi,
Thank you for your answer. Here is the requested information.
select last_value from seq_name;
The difference was less than 32 except one sequence with difference equal to 32
The cache used for sequence creation was 1.
Thank you once again!
Dănuț Soare
> On 15 May 2024, at 14:01, Laurenz
