Re: [GENERAL] postgres getting slow

From: Brian <signal(at)shreve(dot)net>
To: "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] postgres getting slow
Date: 1999-05-20 18:51:43
Message-ID: Pine.LNX.4.10.9905201350180.11822-100000@mercury.shreve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> I have something like this in my startup script appended to the invocation
> of the postmaster ( as we discussed yesterday):
>
> >> ${PGLOGFILE} 2>&1
>
> where $PGLOGFILE is a path to postgres.log.
>

What sort of things to do you catch with logging this? I haven't seen a
single thing goto this file since starting it:

export PGLOGFILE=/var/lib/pgsql/pg.log
su postgres -c '/usr/bin/postmaster -B 250 -i -S -D/var/lib/pgsql -o -S 1024 >> ${PGLOGFILE} 2>&1'

[signal(at)norad signal]$ ls -al /var/lib/pgsql/pg.log
-rw-rw-r-- 1 postgres postgres 0 May 14 11:31 /var/lib/pgsql/pg.log

> Brett W. McCoy
> http://www.lan2wan.com/~bmccoy/
> -----------------------------------------------------------------------
> "One basic notion underlying Usenet is that it is a cooperative."
>
> Having been on USENET for going on ten years, I disagree with this.
> The basic notion underlying USENET is the flame.
> -- Chuq Von Rospach
>

-----------------------------------------------------
Brian Feeny (BF304) signal(at)shreve(dot)net
318-222-2638 x 109 http://www.shreve.net/~signal
Network Administrator ShreveNet Inc. (ASN 11881)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Burrows 1999-05-20 22:03:27 libgen on a Sparc
Previous Message Rudy Gireyev 1999-05-20 18:46:15 RE: [GENERAL] Relations between tables.