From: Steve Crawford <scrawford@pinpointresearch.com>
To: Shane | SkinnyCorp <shanew@skinnycorp.com>
To: PgSQL ADMIN <pgsql-admin@postgresql.org>
Subject: Re: PLEASE GOD HELP US!
Date: Fri, 1 Oct 2004 14:47:01 -0700
Message-ID: <200410011447.01983.scrawford@pinpointresearch.com> (raw)
In-Reply-To: <008701c4a7ec$8b4b39e0$3402a8c0@shanepc>
References: <002801c4a7d0$66797ad0$3402a8c0@shanepc>
<200410011208.18450.scrawford@pinpointresearch.com>
<008701c4a7ec$8b4b39e0$3402a8c0@shanepc>
On Friday 01 October 2004 12:26 pm, Shane | SkinnyCorp wrote:
> Funny...
>
> I vacuum full EVERY night @ midnight...
>
> And yes, that's great about your similar machine with more RAM...
> only... does YOUR table have 60+ users @ 120-some queries per
> second at any given moment?
>
> ...
>
> I didn't need a friggin' tutorial on vacuum man... I need some
> advice. I don't need a class in database design either, and I know
> quite well how postgresql works, but aside from this I opted to
> drop whatever I *think* I know about pgsql, and ask some of the
> 'experts' on this list...
>
> And all I'm getting is shit straight out of the damn manual. Which
> I've read. Many times...
>
> Got any other suggestions?
>
> - Shane
Um, a new attitude would help - if you knew all the answers you
wouldn't be asking the questions. Before biting off the heads of
those trying to help you, try reading
http://linuxmafia.com/faq/Essays/smart-questions.html by Eric S.
Raymond and Rick Moen.
I assume from your reading list you also read:
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
Some of your postgresql.conf settings look _way_ out of the normal
range. A couple that jump out:
...
> wal_buffers = 8192 # min 4, 8KB each
64 MB for wal_buffers? What analysis led you to set this to over 2000
times higher than the default? Mine is set to 64 buffers which seems
fine but of course ymmv. At least it is shared rather than
per-process memory so it's not completely killing you.
> vacuum_mem = 127072
Also looks way too high. This is settable per connection. Bump it up
when running your vacuum fulls if you need to.
You only showed pg processes from top. What is the swapping activity
on your machine? Do you have memory left over for caching?
Cheers,
Steve
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: scrawford@pinpointresearch.com, shanew@skinnycorp.com
Subject: Re: PLEASE GOD HELP US!
In-Reply-To: <200410011447.01983.scrawford@pinpointresearch.com>
References: <002801c4a7d0$66797ad0$3402a8c0@shanepc> <200410011208.18450.scrawford@pinpointresearch.com> <008701c4a7ec$8b4b39e0$3402a8c0@shanepc> <200410011447.01983.scrawford@pinpointresearch.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