"lt" <[EMAIL PROTECTED]> writes:
> I have tried add query=4 in pq_options file,
> but nothing recorded in syslog.
Are you starting the postmaster with -S ? That suppresses its log...
regards, tom lane
Hi,
I am running a productive server of postgresql 7.03, but sometimes it have a high
load average value more than 10, it must be caused by a trouble query, although I have
carefully checked my queries, I still can not find which query made this. I wish there
is a way to monitor the query,
Title: RE: [ADMIN] v7.1b4 bad performance
I thought that -F only turned off the shared mem fsyncing. Obviously not. I'll rethink my analysis ;-)
-Original Message-
From: Tom Lane
To: Michael Ansley
Cc: 'Schmidt, Peter '; ''Bruce Momjian' '; ''[EMAIL PROTECTED]' '
Sent: 2-17-01 4:1
Michael Ansley <[EMAIL PROTECTED]> writes:
> I would consider this perfectly acceptable. Official benchmarks can only be
> without the -F switch prior to 7.1, so in raw performance terms (with
> acceptable safety) you have to compare 7.0.2 without -F to 7.1beta4 with -F,
> because those are the f
Title: RE: [ADMIN] v7.1b4 bad performance
I would consider this perfectly acceptable. Official benchmarks can only be without the -F switch prior to 7.1, so in raw performance terms (with acceptable safety) you have to compare 7.0.2 without -F to 7.1beta4 with -F, because those are the faste
Timothy J Hitchens writes:
> Does anyone have a reference that includes all of the functions like
> date_part that shows the usages etc eg what it will accept in what place etc
> etc
http://www.postgresql.org/users-lounge/docs/7.0/postgres/functions.htm
--
Peter Eisentraut [EMAIL PROTECTE
Title: RE: [ADMIN] v7.1b4 bad performance
My understanding is that the TPC-3 test are not about complex SQL, they are about transaction benching, and as such, it doesn't need to be complex SQL, it just needs to test the transactional speed of the engine. The pgbench appears to be a relatively
Does anyone have a reference that includes all of the functions like
date_part that shows the usages etc eg what it will accept in what place etc
etc
Timothy Hitchens (Hitcho)
Web Evangelist/Technologist
Voice: +61 7 3396 3500
Fax: +61 7 3396 2633
Cell: +61 419 521 440
SMS: [EMAIL PROTECTED] (sub