Hi,
Is there any documentation or wiki on PostgreSQL best practices? For example:
- run vacuum regularly and how to judge the frequency of running vacuum
- when to use rule or trigger
- etc.
What I realized is that I joined PostgreSQL's mailing list and kept some of
the advise that I feel might come in handy in my email client. However,
sometimes it is very tedious search through my archived emails and read
through all the emails in the thread. You can call me lazy, but I think it's
good to have a set of best practices in using PostgreSQL, especially for the
beginners (unless of course I don't know that there is an existing ones).
Thanks :)
Regards,
Leonard Soetedjo