In PostgreSQL, shared_buffers is a configuration parameter that determines the amount of memory dedicated to caching data blocks in shared memory. This is […]
Read More
Set Statement Timeout to Avoid Runaway Queries
In YSQL establishing a statement timeout via the statement_timeout parameter restricts queries from exceeding a designated duration. This timeout can be configured […]
Read MoreErase Statistics
The ANALYZE command collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system catalog. These […]
Read MoreLoad pg_stat_monitor when YugabyteDB starts
pg_stat_monitor is a Query Performance Monitoring tool for PostgreSQL and supported in YugabyteDB. It collects performance statistics and provides query performance insights […]
Read MoreTrack User Defined Function Execution Counts and Runtimes
In YSQL we can track function call counts and time used by enabling the track_functions parameter. The default is none, but you can […]
Read More