Postgres Pro
Downloads
Home   >   mailing lists

Re: simple update queries take a long time - postgres 8.3.1 - Mailing list pgsql-general

From mark
Subject Re: simple update queries take a long time - postgres 8.3.1
Date
Msg-id 82fa9e310804011341r4950e65h9c959a3aacf4dde8@mail.gmail.com
Whole thread Raw
In response to Re: simple update queries take a long time - postgres 8.3.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: simple update queries take a long time - postgres 8.3.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
On Tue, Apr 1, 2008 at 7:27 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Tomasz Ostrowski <tometzky@batory.org.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?

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: Using tables in other PostGreSQL database
Next
From: sam
Date:
Subject: Too many commands in a transaction