| From: | Dennis Björklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | Martin Foster <martin(at)ethereal-realms(dot)org> |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: [PERFORM] Extreme high load averages |
| Date: | 2003-07-07 09:07:15 |
| Message-ID: | Pine.LNX.4.44.0307071102390.1516-100000@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-performance |
On Sun, 6 Jul 2003, Martin Foster wrote:
> The processor seems to be purposely sitting there twiddling it's thumbs.
> Which leads me to believe that perhaps the nice levels have to be
> changed on the server itself?
It could also be all the usual things that affect performance. Are your
queries using indexes where it should? Do you vacuum analyze after you
have updated/inserted a lot of data?
It could be that some of your queries is not as efficient as it should,
like doing a sequenctial scan over a table instead of an index scan. That
translates into more IO needed and slower response times. Especially when
you have more connections figthing for the available IO.
--
/Dennis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | wong siew hui | 2003-07-07 10:32:14 | Problems with Installation of Perl-DBD-PG |
| Previous Message | Martin Foster | 2003-07-07 04:21:29 | Re: [PERFORM] Extreme high load averages |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-07-07 09:22:52 | Re: Moving postgresql.conf tunables into 2003... |
| Previous Message | Matthew Hixson | 2003-07-07 07:19:33 | Re: Moving postgresql.conf tunables into 2003... |