Date: Wed, 25 Jul 2007 20:06:10 +0100 From: "Martin Hepworth" <maxsec@gmail.com> To: "Pat Maddox" <pergesu@gmail.com> Cc: freebsd-questions@freebsd.org Subject: Re: Having bad performance issues Message-ID: <72cf361e0707251206l1baf0157x66a56501eafb4dfb@mail.gmail.com> In-Reply-To: <810a540e0707251052j6a1b2ac2jb61dd8af4efa083d@mail.gmail.com> References: <810a540e0707251052j6a1b2ac2jb61dd8af4efa083d@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Pat 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@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@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to " > freebsd-questions-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?72cf361e0707251206l1baf0157x66a56501eafb4dfb>