performance issues
От | DHSC Webmaster |
---|---|
Тема | performance issues |
Дата | |
Msg-id | 3B276B68.2161696A@dhs-club.com обсуждение исходный текст |
Ответы |
Re: performance issues
|
Список | pgsql-admin |
Hello all, We are running 7.0.3 on a RH 7.0 box w/twin 733 pentium CPUs, 512 meg. ram and a 3 drive raid 5 scsi array. The machine is dedicated. Our main table is about 700,000 rows with an associated table of about 15,000 rows. -N 128 -B 256 logging to a file Without spelling out our complete schema I'll give some basic info main table has 37 columns with 3 indexes, several foreign key constraints and one rule the associated table has about 10 columns all or which are int 4 with the exception of one text Most of our queries are simple select queries, half of which would use the indexes. Now, does this scenario sound about right or do I have a lot of work to do? At any given moment having 12 - 16 queries running (say 1 update & one insert, the rest selects), I'm dragging bad. Vacuum -z was just run. top gives me numbers around 20. Even with just a 2 or 3 queries running top gives me 2 - 3. Does this sound typical? If my information is insufficient to give a ballpark quess, perhaps you could give me some normal types of performance figures. Thank you for your feedback. -- Bill MacArthur Webmaster DHS Club
В списке pgsql-admin по дате отправления: