Nick Barnes questions

Nick Barnes answers

• postgres INSERT trigger fires even with ON CONFLICT DO NOTHING
• Postgresql COPY encoding, how to?
• Best way to delete large no of random rows in PostgreSQL
• Performance of NUMERIC type with high precisions and scales in PostgreSQL
• WAL archive: FAILED (please make sure WAL shipping is setup)
• SELECT where value in collection of ranges
• Psycopg2 peer authentication for user postgres
• Is it possible to combine the ANY and BETWEEN operator
• Postgres 9.6 parallel XPath
• PostgreSQL: enforce 1:1 for optional Plugin