Having bad performance issues

Martin Hepworth maxsec at gmail.com
Wed Jul 25 19:06:12 UTC 2007


I'd start by looking at tuning Postgresql....look at the queries that are
taking the longest and optimise those.

there's stuff alover the web about tuning PGsql

On 7/25/07, Pat Maddox <pergesu at gmail.com> wrote:
> I'm having some bad perf issues on a 6.2 server running PostgreSQL
> 8.2.4. I really don't know too much about this stuff...but it doesn't
> seem to be related to memory or CPU as they're barely being touched.
> Which leaves IO. Here's some vmstat output. My only guess is that the
> numbers under the faults section are pretty high. But I don't really
> know what that means. I'd appreciate any help.
> Here's the formatted vmstat output:  http://pastie.caboo.se/82165
> Pat
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "
> freebsd-questions-unsubscribe at freebsd.org"

More information about the freebsd-questions mailing list