PostgreSQL best practices?
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
At present time, your best bet is to drop in on the IRC channel and ask
questions there. You'll normally get an immediate reply, even if it's
just a URL to look at.
On Tue, Jan 24, 2006 at 10:23:26PM +0800, Leonard Soetedjo wrote:
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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
On Tuesday 31 January 2006 14:09, Jim C. Nasby wrote:
At present time, your best bet is to drop in on the IRC channel and ask
questions there. You'll normally get an immediate reply, even if it's
just a URL to look at.
As a beginner, I feel not knowing where to start and what to ask in IRC or
mailing list (e.g. previously I didn't know that PostgreSQL has replication,
until I join the mailing list for some time). And in the mailing list, I saw
that there are repetitive questions asking about replication advice such as
what are the current choices, difference, caveats etc. I suppose that trend
is due to lack of beginner's documentation? (the answer might be in
PostgreSQL documentation, but I do find it rather technical for a beginner
like me to understand).
Is there a FAQ or wiki that has a list of answer to beginners' questions? It
might not be complete or specific answers, but at least it gives some
direction to the questioner.
I found Varlena.com's PostgreSQL General Bits to be quite good. However the
archives are sorted by date and therefore more difficult to discover
articles/tips (regarding new PostgreSQL features, for example).
Regards,
Leonard Soetedjo
Read the FAQ.
---------------------------------------------------------------------------
Leonard Soetedjo wrote:
On Tuesday 31 January 2006 14:09, Jim C. Nasby wrote:
At present time, your best bet is to drop in on the IRC channel and ask
questions there. You'll normally get an immediate reply, even if it's
just a URL to look at.As a beginner, I feel not knowing where to start and what to ask in IRC or
mailing list (e.g. previously I didn't know that PostgreSQL has replication,
until I join the mailing list for some time). And in the mailing list, I saw
that there are repetitive questions asking about replication advice such as
what are the current choices, difference, caveats etc. I suppose that trend
is due to lack of beginner's documentation? (the answer might be in
PostgreSQL documentation, but I do find it rather technical for a beginner
like me to understand).Is there a FAQ or wiki that has a list of answer to beginners' questions? It
might not be complete or specific answers, but at least it gives some
direction to the questioner.I found Varlena.com's PostgreSQL General Bits to be quite good. However the
archives are sorted by date and therefore more difficult to discover
articles/tips (regarding new PostgreSQL features, for example).Regards,
Leonard Soetedjo
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073