Question : I turned the archive_mode on on my postgresql configuration for testing a backup server . And since the […]
Tag: checkpoint
Checkpoints are occurring too frequently during pg_restore
Question : Under PostgreSQL 9.2.2 (Windows 32 bits), I have a pg_restore command that systematically results in log warnings about […]
High number of Checkpoint pages/sec and memory pressure
Question : Recently I read a blog post on mssqltips.com about memory bottlenecks on SQL Server. In this article I […]
Postgres 9.1.16 Hot Standby
Question : I am using PostgreSQL 9.1.16 (and I cannot upgrade) with Hot Standby. We have a few batches that […]
Why xlog checkpoint was started?
Question : Consider the following config shared_buffers = 20GB max_wal_size = 2GB min_wal_size = 1GB checkpoint_completion_target = 0.7 checkpoint_timeout = […]
When should CHECKPOINT be added to stored procedures
Question : I would like to know when is the proper moment to append a manual CHECKPOINT in a stored […]
What does “Deleting unrecoverable checkpoint table row” mean?
Question : When I look at our production SQL Server 2016’s server logs I am seeing multiple entries that say: […]
Sql Server rollback to some point in time
Question : This seems like a fairly common scenario, yet I’m not sure how to do this. I have a […]
Does not writing a checkpoint record damage anything?
Question : I got an alert Event ID: 3619. Could not write a checkpoint record in database ‘ID ####’ because […]
Dirty buffer pages after issuing CHECKPOINT
Question : I am currently working on a test system and due to the nature of the queries I want […]