Hi Folks
I want to log all of the inserts and delete that occur in a postgres database. Whats
the easiest way to do this?
--
Cheers
Tony
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
On Sat, 2002-01-26 at 13:30, Antony Stace wrote:
>
> Hi Folks
>
> I want to log all of the inserts and delete that occur in a postgres database.
>Whats the easiest way to do this?
tweak your postgresql.conf
Markus Bertheau
---(end of broadcast)
Thanks for the reply Markus. I have added
log_connections = yes
log_timestamp = true
log_pid = true
syslog = 2
to my postgresql.conf file but it dosent seem to have caused any logging to occur in
/var/log/postgresql
Anything else I need to do?
> tweak your postgresql.conf
>
> Markus Berthe
On Sat, 2002-01-26 at 16:12, Antony Stace wrote:
> Thanks for the reply Markus. I have added
>
> log_connections = yes
> log_timestamp = true
> log_pid = true
> syslog = 2
>
> to my postgresql.conf file but it dosent seem to have caused any logging to occur in
>
> /var/log/postgresql
>
> Any
>
> > log_connections = yes
> > log_timestamp = true
> > log_pid = true
> > syslog = 2
> >
> > to my postgresql.conf file but it dosent seem to have caused any logging to occur
>in
> >
> > /var/log/postgresql
> >
> > Anything else I need to do?
>
> add
>
> debug_print_query = true
>
I jus
Hi Chad,
good try, but there is unfortunately no parameter related to memory.
sysctl -a displays all of the parameters and their current settings,
nothing amongst them which looks like it's of help here.
Thanks for the help, I guess, I have to see if I can talk to somebody
@ Apple or one of t
On Sat, 2002-01-26 at 16:51, Antony Stace wrote:
>
> >
> > > log_connections = yes
> > > log_timestamp = true
> > > log_pid = true
> > > syslog = 2
> > >
> > > to my postgresql.conf file but it dosent seem to have caused any logging to
>occur in
> > >
> > > /var/log/postgresql
> > >
> > > An
Chris-
This thread from Darwin might help you identify someone who is in the know
about shared memory:
http://www.darwinfo.org/devlist.php3?number=1385
-Nick
--
Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax
Antony Stace <[EMAIL PROTECTED]> writes:
> restarted postgres and then did a few queries in the database. But nothing
> is being logged in /var/log/postgresql. Any ideas what else might be wrong?
If you're not seeing any log output at all, then either:
1. Postgres is logging to postmaster's st
We have a fresh database and have begun to observe performance degradation
for INSERTs as a table went from empty to 100,000-ish rows. Initial
INSERTs were sub second while after 30k rows, they were 1-3 seconds.
Note that we have done NO performance tuning yet nor are there any indexes
on the ta
Marc Mitchell wrote:
> We have a fresh database and have begun to observe performance degradation
> for INSERTs as a table went from empty to 100,000-ish rows. Initial
> INSERTs were sub second while after 30k rows, they were 1-3 seconds.
>
> Note that we have done NO performance tuning yet nor
"Marc Mitchell" <[EMAIL PROTECTED]> writes:
> We have a fresh database and have begun to observe performance degradation
> for INSERTs as a table went from empty to 100,000-ish rows. Initial
> INSERTs were sub second while after 30k rows, they were 1-3 seconds.
> Note that we have done NO perfor
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Marc Mitchell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 26, 2002 11:06 PM
Subject: Re: [ADMIN] INSERT performace.
> "Marc Mitchell" <[EMAIL PROTECTED]> writes:
> > We have a fresh database and have
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Marc Mitchell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 26, 2002 10:51 PM
Subject: Re: [ADMIN] INSERT performace.
> Marc Mitchell wrote:
> > We have a fresh database and have begun to observe p
14 matches
Mail list logo
