Hi there,
I wanted to make a *rough* estimates of how much time does
each of the SQL query sent to Postgresql takes.
The objective is to indentify slow running queries and optimise
them. also to do some statistical analysis on the queries ,
like most frequent queries etc ,etc.
To accomplish it
On 12 May 2002 at 12:49, Brian McCane wrote:
> I am on FreeBSD 5.0.
There is a reason why you must be on 5.0? That is not recommended for
"sane" people.
5.0 is -current and not the best place to be running important
applications At present 5.0 is -current, which is the version which
change
Tom,
I was going to do a pg_ctl stop/start cycle to try to fix the
error, however
What do I need to do to debug? I am on FreeBSD 5.0. I assume I can use
GDB to connect to a running backend, but have not done any serious
debugging in gdb for 4-5 years. If it is too ugly, I might co
Brian McCane <[EMAIL PROTECTED]> writes:
> Okay, now I am a little scared. Before I started rebuilding indexes, I
> decided to do the VACUUM FULL thing on all of my tables. On my two most
> referenced tables I am getting:
> ERROR: No one parent tuple was found
Oh, that's interesting. We've g
Brian McCane <[EMAIL PROTECTED]> writes:
> Also, I disabled my nightly VACUUM ANALYZE from cron while I was doing
> this because I was unsure what would happen with multiple VACUUM's
> running.
Multiple VACUUMs work fine (except possibly for driving your system
load to the moon ;-)). Somewhere b
Brian McCane <[EMAIL PROTECTED]> writes:
> Would I possibly see another performance boost if I rebuilt the
> indexes involved like I used to in 7.1.3? I still have the Perl script
> sitting around here some place, but assumed from things said by you and
> Bruce in the past few months about 7.2.x
I receive often the NOTICE of the subject,
what does mean ?
Ciao
Gaetano
--
#exclude
#include
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t\b\b\b\b\b\b");
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]