]
Sent: Wed 11/14/2007 1:46 PM
To: Kevin Grittner
Cc: Tena Sakai; [email protected]
Subject: Re: [ADMIN] postgres bogged down beyond tolerance
On Nov 14, 2007 3:33 PM, Kevin Grittner <[EMAIL PROTECTED]> wrote:
> >>> On Wed, Nov 14, 2007 at 3:16 PM, in message
> <[E
On Nov 14, 2007 3:33 PM, Kevin Grittner <[EMAIL PROTECTED]> wrote:
> >>> On Wed, Nov 14, 2007 at 3:16 PM, in message
> <[EMAIL PROTECTED]>, "Scott Marlowe"
> <[EMAIL PROTECTED]> wrote:
>
> > On Nov 14, 2007 2:26 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
> >> INFO: vacuuming "public.allele"
> >>
rom: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Wed 11/14/2007 11:47 AM
To: Tena Sakai
Cc: [email protected]
Subject: Re: [ADMIN] postgres bogged down beyond tolerance
On Nov 14, 2007 12:56 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>
> The postgres server I have (on redhat
>>> On Wed, Nov 14, 2007 at 3:16 PM, in message
<[EMAIL PROTECTED]>, "Scott Marlowe"
<[EMAIL PROTECTED]> wrote:
> On Nov 14, 2007 2:26 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>> INFO: vacuuming "public.allele"
>> INFO: "allele": found 2518282 removable, 1257262 nonremovable row versions
>
On Nov 14, 2007 2:26 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>
> Hi Scott,
>
> Many thanks for your suggestion. I have issued a
> bit heavier command prior to reading your mail.
>
> At psql prompt, I (as superuser) typed:
># vacuum full verbose analyse;
OK, I had just wanted vacuum verbo
On Nov 14, 2007 12:56 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>
> The postgres server I have (on redhat linux 2.6 with recent
> Dell hardware (4 cpus)) is running terribly slow.
>
> A job it should have gotten done in less than 1 hour
> took 7.5 hours last night.
OK, before you try to fix th
Tena Sakai wrote:
> I checked kernel parameter
> shmmax and it was set as 33554432. I "fixed" it as
> suggested by the manual:
> http://www.postgresql.org/docs/8.2/static/kernel-resources.html
Note that just by changing shmmax you're not doing anything to Postgres
itself. If you want Postgres t
Hi Everybody,
The postgres server I have (on redhat linux 2.6 with recent
Dell hardware (4 cpus)) is running terribly slow.
A job it should have gotten done in less than 1 hour
took 7.5 hours last night.
The job I am referencing above gets run via crontab every
evening and I comb the log file fa
