Re: PLEASE GOD HELP US!

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

In response to

Browse pgsql-admin by date

  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!