From: Rosser Schwarz <rosser.schwarz@gmail.com>
To: Shane|SkinnyCorp <shanew@skinnycorp.com>
Cc: PgSQL ADMIN <pgsql-admin@postgresql.org>
Subject: Re: PLEASE GOD HELP US!
Date: Fri, 1 Oct 2004 11:14:56 -0500
Message-ID: <37d451f704100109147777fc7@mail.gmail.com> (raw)
In-Reply-To: <002801c4a7d0$66797ad0$3402a8c0@shanepc>
References: <002801c4a7d0$66797ad0$3402a8c0@shanepc>
while you weren't looking, Shane | SkinnyCorp wrote:
> Hey, my name is Shane Witschen and I'm the Systems Administrator (mainly a
> developer) for a small web development company. We recently switched over
> to PostgreSQL after going over some of the powerful features that it holds
> over MySQL.
What kind of query load are you experiencing? (That is,
hits/views/queries per second/minute/whatever.)
What's your disk subsystem?
What indices do you have defined on which tables? Run EXPLAIN ANALYZE
on your longer-running queries and check to see if your indices are
being used or not.
How often are you vacuuming?
/rls
--
:wq
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: rosser.schwarz@gmail.com, shanew@skinnycorp.com
Subject: Re: PLEASE GOD HELP US!
In-Reply-To: <37d451f704100109147777fc7@mail.gmail.com>
References: <002801c4a7d0$66797ad0$3402a8c0@shanepc> <37d451f704100109147777fc7@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox