From: | Tobias Brox <tobias(at)nordicbet(dot)com> |
---|---|
To: | Frank Wiles <frank(at)wiles(dot)org> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Performance Tuning Article |
Date: | 2005-06-23 01:06:04 |
Message-ID: | 20050623010604.GI7839@tobias |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
[Frank Wiles - Wed at 09:52:27AM -0500]
> I've put together a short article and posted it online regarding
> performance tuning PostgreSQL in general. I believe it helps to bring
> together the info in a easy to digest manner. I would appreciate any
> feedback, comments, and especially any technical corrections.
I did not read through the whole article, but I already have some comments;
work_mem was formerly sort_mem. As many of us still use pg7, you should
probably have a note about it.
There are already quite some short articles at the web about this issue, and
that was actually my starting point when I was assigned the task of tweaking
the database performance. I think diversity is a good thing, some of the
short articles was relatively outdated, others were not very well written.
And also - I still never had the chance to do proper benchmarking of the
impact of my changes in the configuration file, I just chose to trust some
of the advices when I saw almost the same advice repeated in several
articles.
I think we need some comprehensive chapter about this in the manual, with
plenty of pointers - or eventually some separate well-organized pages
telling about all known issues. It seems to me that many of the standard
tips here are repeating themselves over and over again.
--
Tobias Brox, +86-13521622905
Nordicbet, IT dept
From | Date | Subject | |
---|---|---|---|
Next Message | Keith Worthington | 2005-06-23 02:31:29 | Re: Performance Tuning Article |
Previous Message | Josh Berkus | 2005-06-22 21:08:55 | Re: parameterized LIKE does not use index |