From: | Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com> |
---|---|
To: | Shane|SkinnyCorp <shanew(at)skinnycorp(dot)com> |
Cc: | PgSQL ADMIN <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: PLEASE GOD HELP US! |
Date: | 2004-10-01 16:14:56 |
Message-ID: | 37d451f704100109147777fc7@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2004-10-01 16:23:35 | Re: PLEASE GOD HELP US! |
Previous Message | Shane | SkinnyCorp | 2004-10-01 16:04:57 | PLEASE GOD HELP US! |