Users of PostgreSQL often choose it because of the serious way it treats the data it receives. At the same time, many PostgreSQL users are under tremendous pressure to deliver desired features to the users very quickly. Development periods are short, and testing periods are often close to non-existent.
This talk presents some lessons the author learned in an environment of too-short deadlines where software was to be presented to the world. Some of these remarks are PostgreSQL specific, and some are just tips for how to play nicely with those whose SQL skill you think needs some help.
Andrew works supporting PostgreSQL with his colleagues at Command Prompt. Before joining that company, he worked at Afilias, where he was one of the principal offenders behind Slony's refusal to do DDL easily. He lives in Toronto, with a fierce dog and a very nice wife. He has no cats, although the dog would be pleased to meet some if you have extras.