22 Articles tagged “skytools”

Londiste Trick

So, you’re using londiste and the ticker has not been running all night long, due to some restart glitch in your procedures, and the on call admin didn’t notice the restart failure. If you blindly restart the replication daemon, it will load in memory all those events produced during the night, at once, because you now have only one tick where to put them all. The following query allows you to count how many events that represents, with the magic tick numbers coming from pgq.



Dimitri Fontaine

PostgreSQL Major Contributor

Open Source Software Engineer

France