Skip site navigation (1) Skip section navigation (2)

Re: Large database help

From: Ragnar Kjørstad <postgres(at)ragnark(dot)vestdata(dot)no>
To: xbdelacour(at)yahoo(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Large database help
Date: 2001-04-24 00:31:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Mon, Apr 23, 2001 at 08:15:05PM -0400, xbdelacour(at)yahoo(dot)com wrote:
> Then, please correct me if I'm wrong: I should be able to test your 
> hypothesis by creating a small DB (of say 2MB) and setting up at least a 
> dozen backends to tag it. If I get the same symptoms w/ respect to disk 
> activity/performance then we could say that the problem is not related to 
> shared memory/the amount of data/swapping.

I'm no expert, but I guess so.

> What log files are output from postgres? I was under the impression that 
> postmaster's stdout/stderr were the only output. I've been postmaster 
> xyz >& log.txt'ing it. I'll check into this.

There is a transaction log named pg_log. I'm not sure exactly under what
conditions postgres writes to that file, and what - others will be able
to answer that.

Ragnar Kjørstad

In response to

pgsql-admin by date

Next:From: xbdelacourDate: 2001-04-24 00:32:40
Subject: Re: Large database help
Previous:From: Tom LaneDate: 2001-04-24 00:24:16
Subject: Re: Large database help

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group