In the previous article of this series, we saw how to extract WAL records related to the exact SQL commands we want, INSERTs on heap tables, and what the structure of those records was. In this article we will focus on the heap specific information contained in those records and how to extract SQL queries from them.| rjuju's home
Is it actually possible to extract SQL commands from WAL generated in “replica” wal_level?| rjuju's home
plpgsql_check version 1.14.0 was just released and brings some improvement for performance diagnostic.| rjuju's home
Write-Ahead Logs is a critical part of PostgreSQL, that ensures data durability. While there are multiple configuration parameters , there was no easy to monitor WAL activity, or what is generating it.| rjuju's home
Depending on your workload, the planning time can represent a significant part of the overal query procesing time. This is especially import in OLTP workload, but OLAP queries with numerous tables being joined and an aggressive configuration on the JOIN order search can also lead to hight planning time.| rjuju's home
Nouvelle colonne leader_pid dans la vue pg_stat_activity| rjuju's home
Selectivity estimation error is one of the main cause of bad query plans. It’s quite straighforward to compute those estimation error using EXPLAIN (ANALYZE), either manually or with the help of explain.depesz.com (or other similar tools), but until now there were now tool available to get this information automatically and globally. Version 2 of pg_qualstats fixes that, thanks a lot to Oleg Bartunov for the original idea!| rjuju's home
New leader_pid column in pg_stat_activity view| rjuju's home
Parvenir à une suggestion d’index de qualité peut être une tâche complexe.| rjuju's home
Coming up with good index suggestion can be a complex task. It requires knowledge of both application queries and database specificities. Over the year multiple projects tried to solve this problem, one of which being PoWA with the version 3, with the help of pg_qualstats extension. It can give pretty good index suggestion, but it requires to install and configure PoWA, while some users wanted to only have the global index advisor. In such case and for simplicity, the algorithm used in PoWA i...| rjuju's home
Cet article fait partie d’une série d’article sur la beta de PoWA| rjuju's home
This article is part of the PoWA 4 beta series, and describes the new powa-collector daemon.| rjuju's home
Cet article fait partie d’une série d’article sur la beta de PoWA| rjuju's home
This article is part of the PoWA 4 beta series, and describes the changes done in powa-archivist.| rjuju's home
PoWA 4 is available in beta.| rjuju's home
PoWA 4 est disponible en beta.| rjuju's home
Data checksums| rjuju's home
Data checksums| rjuju's home
J’entends régulièrement des complaintes sur la quantité d’espace disque gâchée| rjuju's home
Vous avez la possibilité de visualiser les Wait Events dans PoWA 3.2.0 grâce à l’extension pg_wait_sampling extension.| rjuju's home