| From: | Eugeny N Dzhurinsky <bofh(at)redwerk(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: getting better performance |
| Date: | 2006-07-06 15:11:26 |
| Message-ID: | 20060706151126.GA9239@office.redwerk.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Jul 06, 2006 at 09:28:39AM -0500, Scott Marlowe wrote:
> On Thu, 2006-07-06 at 01:40, Eugeny N Dzhurinsky wrote:
> Do you add / remove tables a lot? Could be you've got system catalog
> bloat.
Yes, almost each table is dropped and re-created in 3-5 days.
> do you have autovacuum running?
Yes.
> What version of pgsql are you running?
psql -V
psql (PostgreSQL) 8.0.0
> What OS?
CentOS release 3.7 (Final)
> What file system?
ext3
> What kind of machine are you using?
Pentium IV, 1.8 GHz
> How much memory does it have?
512 Mb RAM
> How many disk drives?
single
> Are you using RAID? hardware / software? battery backed cache or no?
no
> Do you have one or two, or thousands of connections at a time?
something like 20 connections (peak).
> Do you use connection pooling if you have lots of connections to handle?
My application uses Jakarta Commons DBCP module.
--
Eugene Dzhurinsky
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2006-07-06 15:26:54 | Re: getting better performance |
| Previous Message | Merlin Moncure | 2006-07-06 14:44:26 | Re: Opteron/FreeBSD/PostgreSQL performance poor |