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]
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
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:13
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,
"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