Re: simple update queries take a long time - postgres 8.3.1

From: mark <markkicks(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Tomasz Ostrowski" <tometzky(at)batory(dot)org(dot)pl>, pgsql-general(at)postgresql(dot)org
Subject: Re: simple update queries take a long time - postgres 8.3.1
Date: 2008-04-01 20:41:34
Message-ID: 82fa9e310804011341r4950e65h9c959a3aacf4dde8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Apr 1, 2008 at 7:27 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl> writes:
> > I'd also set
> > log_checkpoints=on
> > to get an idea how it behaves.
>
> Yeah, that's really the *first* thing to do. You need to determine
>
I set this on,
log_checkpoints = on

and started postgres using this command

pg_ctl -D /mnt/work/database -l /mnt/work/logs/pgsql.log start

nothing is getting logged in the logfile. should I turn on some other
settings?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-04-01 21:12:17 Re: Connection reset by peer / broken pipe
Previous Message sam 2008-04-01 20:34:44 Too many commands in a transaction