From: | "Ing(dot) Gabriel Monsalvo" <gmonsalvo(at)rentastucuman(dot)gov(dot)ar> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Database Server is too Slow |
Date: | 2002-12-13 14:50:27 |
Message-ID: | 002a01c2a2b6$fa1a9970$4d00a8c0@77 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi!
I need help, i mounted a Postgresql server on IBM netserver with RAID 5 134 GB, 2.5 GB de RAM and two Xeon 1.4 ghz.
I installed postgresql 7.3 in this box, my database have over 25 millons of records, and everything is slow.
i optimized with indexes,vacuum analyze and tuning up the kernel for shared memory usage.
but the server is too slow when:
- create index for any table with more than 5 millions
- vacuum takes over four hours in this type of tables.
- select max (field) from table where field2=xxxx takes a lot of time.
explain select max(numoble) from obligacion where periodo=200100;
QUERY PLAN
-------------------------------------------------------------------------------------------------
Aggregate (cost=6160676.57..6160676.57 rows=1 width=16)
-> Index Scan using obligacion8 on obligacion (cost=0.00..6156384.72 rows=1716743 width=16)
Index Cond: (periodo = 200100::numeric)
(3 rows)
please, i need help about this, i read a lot of documantation for tune up a postgresql server and still having problems.
anybody have a similar problem? how to solve it???
thanks in advance.
From | Date | Subject | |
---|---|---|---|
Next Message | Murthy Kambhampaty | 2002-12-13 15:35:46 | Re: how to cancel a query ? |
Previous Message | Harald Krake | 2002-12-13 11:44:19 | Re: Applictaion data Logging |