Author: Martin(Chengxi) Sun

Enterprise PostgreSQL Solutions

Martin(Chengxi) Sun

Join highgo in 2019. I'm still new to PostgreSQL. I was very interested in system level coding related topics in grad school. Current interest is to study the principle of database

Database monitoring is a very essential for most of the database system, it can prevent system crises, improve performance, database failure and auditing the traffic for identify any unwanted access. PostgreSQL has an extension called pg_stat_statements, which can capture a

There are many advantages to using bind variables in SQL statements, especially in conditional statements. Using bind variables can save the trouble to parse and optimize the query in every execution. There are also disadvantages such as bind variable will