One additional point about reindexing I should have mentioned, make sure
you have adequate disk space to complete the reindexing.
Craig
On Mon, May 5, 2025 at 8:33 AM Craig Jackson
wrote:
> For the two indexes that take 12 hours to vacuum: If you can drop and
> rebuild them in less than
needed for your delete statements, dropping the
indexes before your start the deletion work would allow you to avoid the
overhead of maintaining the indexes, possibly speeding up the delete
statements.
Craig Jackson
On Sat, May 3, 2025 at 1:46 PM wrote:
> Hi
>
>
>
> It is not y
Consider creating a pg_stat_activity history table. This would allow you to
look back at the time of incident and verify if any unusual activity was
occurring in the database. Something like:
CREATE TABLE pg_stat_activity_hist ASSELECT
now() AS sample_time,
a.*FROM
pg_stat_activity a W
How far apart are the min/max connection settings on your application
connection pool? We had a similar issue with connection storms in the past
on Oracle. One thing we did to minimize the storms was make sure there was
not a wide gap between the min/max, say no more than a 5-10 connection
differen
Yes, these were deferrable foreign key constraints.
On Fri, Jan 8, 2021 at 2:05 AM Laurenz Albe
wrote:
> On Thu, 2021-01-07 at 10:49 -0700, Craig Jackson wrote:
> > We had a similar situation recently and saw high commit times that were
> caused
> > by having unindexed foreig
We had a similar situation recently and saw high commit times that were
caused by having unindexed foreign key columns when deleting data with
large tables involved. You might check to see if any new foreign key
constraints have been added recently or if any foreign key indexes may have
inadverten
We are currently engaged in an Oracle to Postgres migration. Our DBA team
has been going through this book and we have learned a lot from it.
PostgreSQL 12 High Availability Cookbook - Third Edition
https://www.packtpub.com/data/postgresql-12-high-availability-cookbook-third-edition
On Mon, May 4
Thanks, I'll check it out.
On Thu, Dec 5, 2019 at 12:51 PM Craig James wrote:
> On Thu, Dec 5, 2019 at 9:48 AM Craig Jackson
> wrote:
>
>> Hi,
>>
>> We are in the process of migrating an oracle database to postgres in
>> Google Cloud and are investigating
ing
pgbackreset, barman, and GCP snapshots but wanted to see if there are any
other recommendations we should consider.
*Desirable features*
- Parallel backup/recovery
- Incremental backups
- Backup directly to a GCP bucket
- Deduplication/Compression
Any suggestions would be appreciated.
Craig Jackson
