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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mark <markkicks(at)gmail(dot)com>
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 21:22:08
Message-ID: 14626.1207084928@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

mark <markkicks(at)gmail(dot)com> writes:
> 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?

You're probably looking in the wrong logfile. Depending on what your
log destination settings are, the file mentioned in pg_ctl -l is likely
to see only early-postmaster-startup messages (before it's read the
configuration file and adopted those settings).

regards, tom lane

In response to

Browse pgsql-general by date

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