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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2002-10-09 04:55:21 | Re: What does this tell me? |
Previous Message | Josh Berkus | 2002-10-09 04:33:52 | Re: What does this tell me? |