[COMMITTERS] pqa - pqa: Applied "[ #1000227 ] Better number normalization" patch
Log Message: --- Applied "[ #1000227 ] Better number normalization" patch Modified Files: -- pqa/lib: pqa.rb (r1.73 -> r1.74) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pqa/pqa/lib/pqa.rb.diff?r1=1.73&r2=1.74) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] pqa - pqa: Query constructor Adding initialization of @duration :
Log Message: --- Query constructor Adding initialization of @duration : suppresses warnings for ruby 1.6.8 Modified Files: -- pqa/lib: pqa.rb (r1.74 -> r1.75) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pqa/pqa/lib/pqa.rb.diff?r1=1.74&r2=1.75) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pqa - pqa: Changes PG log line to better continuation detection closes
Log Message: --- Changes PG log line to better continuation detection closes bug [ #106 ] PG log line continuations are sometimes skipped Modified Files: -- pqa/lib: pqa.rb (r1.75 -> r1.76) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pqa/pqa/lib/pqa.rb.diff?r1=1.75&r2=1.76) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pqa - pqa: New Syslog Line Parser.
Log Message: --- New Syslog Line Parser. This patch mainly changes the key for connections (pids). It also changes continuation tests, so contexts and errors are not logged anymore. Modified Files: -- pqa/lib: pqa.rb (r1.77 -> r1.78) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pqa/pqa/lib/pqa.rb.diff?r1=1.77&r2=1.78) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pqa - pqa: More normalization changes This patch changes display of
Log Message:
---
More normalization changes
This patch changes display of normalized results for enhanced readability :
- replacing string is now "{ }"
- it drops quotes around strings
Also it makes normalization work on ruby 1.6 by changing gsub args to regexp
for stripping \'.
Tested it on 1.8.1 and 1.6.8.
Modified Files:
--
pqa/lib:
pqa.rb (r1.76 -> r1.77)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pqa/pqa/lib/pqa.rb.diff?r1=1.76&r2=1.77)
---(end of broadcast)---
TIP 8: explain analyze is your friend
[COMMITTERS] pqa - pqa: This patch makes a great deal of changes in the structure : -
Log Message: --- This patch makes a great deal of changes in the structure : - parser is now a line factory - one accumulator for both pg/syslog (might be common with MySQL's) - 2 parsers for syslog and pglog, but inheriting from a common pg parser - one line object class by line type - a LogStreamer, that follows pids and manage a query stack for dealing with contexts - Accumulator is now linked to LogStreamer, It solves/adds/modify/breaks those : - Factorized Both PG parsers - solves bug 1000211 "PQA 1.4, PG 8.0 incompatibility" (works on the attached sample) - should solve bug 106 "PG log line continuations are sometimes skipped" (as r1.76 should) - seems to solve bug 1000201 "./pga.rb:521:in cannot convert nil into Float (TypeError)" : tested on attached log : works. - include patch equivalent to Patch 1000226 "Tracking pid in PGlog" - adds feature request 1000189 "option to parse query info out of duration line" - breaks MySQL support : need to create MySQLLine classes and parser - Added framework for a future SQL error report. Modified Files: -- pqa/lib: pqa.rb (r1.78 -> r1.79) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pqa/pqa/lib/pqa.rb.diff?r1=1.78&r2=1.79) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] pqa - pqa: Fix Typo Minor correction for ruby 1.8
Log Message: --- Fix Typo Minor correction for ruby 1.8 Modified Files: -- pqa/lib: pqa.rb (r1.79 -> r1.80) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pqa/pqa/lib/pqa.rb.diff?r1=1.79&r2=1.80) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[COMMITTERS] pqa - pqa: PostgreSQL 8.0 compatibility Changed Context function
Log Message: --- PostgreSQL 8.0 compatibility Changed Context function pattern for PG8.0. Modified Files: -- pqa/lib: pqa.rb (r1.80 -> r1.81) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pqa/pqa/lib/pqa.rb.diff?r1=1.80&r2=1.81) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pqa - pqa: Added WARNING/FATAL/PANIC errors Those are now taken into
Log Message: --- Added WARNING/FATAL/PANIC errors Those are now taken into account. Error report is still not implemented. Modified Files: -- pqa/lib: pqa.rb (r1.81 -> r1.82) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pqa/pqa/lib/pqa.rb.diff?r1=1.81&r2=1.82) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] pqa - pqa: Add a crude SQL error report This patch introduces a new
Log Message: --- Add a crude SQL error report This patch introduces a new flag '-errors' that publish a full log of all SQL errors. Errors are not normalize and the log does not (yet) tries to make errors unique. Modified Files: -- pqa/lib: pqa.rb (r1.82 -> r1.83) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pqa/pqa/lib/pqa.rb.diff?r1=1.82&r2=1.83) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] pqa - pqa: Choose your reports from command line Adds the ability to
Log Message: --- Choose your reports from command line Adds the ability to choose produced reports from command line Minor : adds DELETE and EXEC to keywords Modified Files: -- pqa/lib: pqa.rb (r1.83 -> r1.84) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pqa/pqa/lib/pqa.rb.diff?r1=1.83&r2=1.84) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
