I am using PostgreSQL 9.1.16 (and I cannot upgrade) with Hot Standby. We have a few batches that perform some heavy writes, resulting in a lot of WAL bein produced in a short period of time. The ...
I was using extended events to trace checkpoint activity of a database with indirect checkpoints enabled. The event stream looks like this: And the details of the selected event are: The ...
Under PostgreSQL 9.2.2 (Windows 32 bits), I have a pg_restore command that systematically results in log warnings about the checkpoint frequency, for example: LOG: checkpoints are occurring too ...
I have a DB on a SQL Server 2014 instance. I have a memory-optimized filegroup, but as yet, no memory optimized tables. I also have a FILESTREAM filegroup, which contains 1 FILETABLE and a Primary ...