bma questions

bma answers

• Store the day of the week and time?
• Postgresql creating users with a function
• Adding leading zero if length is not equal to 10 digit using sql
• Dynamic table partitioning in postgres
• Speeding up checking of IP address membership in CIDR ranges, for large datasets
• Postgres Array Prefix Matching
• PostgreSQL 9.0.13 doing a pg_restore but no evidence that disk space is being used
• update table with limit and offset in postgres
• how to prefix a string before sequence generated by postgresql?
• Danger in killing autovacuum: VACUUM queries (to prevent wraparound)