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

Re: What does this tell me?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: What does this tell me?
Date: 2002-10-09 04:38:10
Message-ID: 200210090438.g994cAU07439@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Josh Berkus wrote:
> > > Rest of postgresql.conf params after my signature.   All
> > suggestions
> > > are welcome.  This server has been acting "sick" since I started
> > with
> > > it, under-performing my workstation and MS SQL Server.  Either I've
> > set
> > > something wrong, or there's a hardware problem I need to track
> > down.
> > > 
> > > BTW, is there any problem for postgres in turning the fill access
> > time
> > > recorder in the host filesystem off?  This is often good for a
> > minor
> > > performance gain.
> > 
> > No problem.
> > 
> > You might want to try pgbench and see if that works.
> 
> Yeah.  I was planning on that -- as well as the postgresql.conf tuner
> -- as soon as I can get through one data transfer so that I have a
> little working time.

I was suggesting pgbench because the system should never lock up on you.
Maybe something is very wrong.

What happens if you issue the CHECKPOINT command?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-performance by date

Next:From: Joe ConwayDate: 2002-10-09 04:55:21
Subject: Re: What does this tell me?
Previous:From: Josh BerkusDate: 2002-10-09 04:33:52
Subject: Re: What does this tell me?

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