1) Vacuum frequently
You must do that especially after adding or deleting a large number of rows in a table.
2) || means concatenation in PosgreSql
(as opossed to Mysql where it ment OR)
3) PostgreSQL doesn’t know unsigned.
SMALLINT, INTEGER, BIGINT types doesn’t have an unsigned option, as it is in mysql
4) PostgreSQL is case-sensitive for string comparasions
So if [...]
