Hi, I have released a PostgreSQL contrib module for encoding database rows into JSON structures.
More information can be found at the JSON Functions for PostgreSQL project page.
Hi, I have released a patch to the CLIPS (and also pyclips) expert system which allows CLIPS users to be able to send SQL queries to a PostgreSQL database from the CLIPS environment.
More information can be obtained at the PostgreSQL Extensions for CLIPS Expert System project page.
If your postgreSQL database performance is not up to your expectations, or queries have started to run slower than before, it’s time to do some optimizations. The first feature to activate on your PostgreSQL engine to enable to logging to log your queries and their running statistics. Second is to run these logs through pgFouine.
pgFouine is a PostgreSQL log analyzer used to generate detailed reports from a PostgreSQL log file. pgFouine can help you to determine which queries you should optimize to speed up your PostgreSQL based application. In addition, pgFouine can also analyze your VACUUM stats to determine if you should increase your FSM parameters, or to perform a VACUUM FULL to reclaim the free space in your tables.
This is the homepage of a 30+ years old software technologist. To get in touch with me, drop me an email
All rights reserved. Contents on this web site are not to be duplicated without explicit permission. Use of these contents is entirely at your own risk.
The views and opinions expressed here represent my own and not those of the people, institutions or organizations that I may or may not be related with unless stated explicitly.