On 6/2/23 21:22, Adrian Klaver wrote:
On 6/2/23 18:06, Ron wrote:
On 6/2/23 19:58, Adrian Klaver wrote:
On 6/2/23 17:44, Ron wrote:
Ran into this when upgrading from 13.11 to 15.3...
The pg_restore phase failed with "ERROR: out of shared memory", and
recommended that I increase max_locks_per
On 6/2/23 18:06, Ron wrote:
On 6/2/23 19:58, Adrian Klaver wrote:
On 6/2/23 17:44, Ron wrote:
Ran into this when upgrading from 13.11 to 15.3...
The pg_restore phase failed with "ERROR: out of shared memory", and
recommended that I increase max_locks_per_transaction. Doing so let
the process
> On Jun 2, 2023, at 17:44, Ron wrote:
> Is this to be expected of such a huge schema?
pg_upgrade time is pretty much proportional to the number of database objects
in the schema, so a much larger schema taking much longer is to be expected.
On 6/2/23 19:58, Adrian Klaver wrote:
On 6/2/23 17:44, Ron wrote:
Ran into this when upgrading from 13.11 to 15.3...
The pg_restore phase failed with "ERROR: out of shared memory", and
recommended that I increase max_locks_per_transaction. Doing so let the
process run to completion.
It took
On 6/2/23 17:44, Ron wrote:
Ran into this when upgrading from 13.11 to 15.3...
The pg_restore phase failed with "ERROR: out of shared memory", and
recommended that I increase max_locks_per_transaction. Doing so let the
process run to completion.
It took 12.5 minutes to upgrade a 13GB instan
Ran into this when upgrading from 13.11 to 15.3...
The pg_restore phase failed with "ERROR: out of shared memory", and
recommended that I increase max_locks_per_transaction. Doing so let the
process run to completion.
It took 12.5 minutes to upgrade a 13GB instance. Soon after, I upgraded a