Tutorial: sizes of tables and databases in PostgreSQL 19 March 2017 Posted in: Database About: How big are PostgreSQL tables in terms of rows and disk space? Here are some queries to get their sizes.
Optimizing a very simple MySQL query: use WHERE instead of LIMIT 02 April 2016, edited 08 July 2016 Posted in: Sysadmin About: A friend had problems with MySQL because it was not using an existing index for a query. A huge number of queries were rebuild into one which was 4000x faster than each of the previous ones.