Re: [PERFORM] Parsing VACUUM VERBOSE

2007-06-18 Thread Guillaume Smet
On 6/18/07, Y Sidhu <[EMAIL PROTECTED]> wrote: I am following this discussion with great interest. I have PG running on FreeBSD and am forced to run pgFouine on a separate Linux box. I am hoping I can create a log file. and then copy that over and have pgFouine analyze it on the Linux box. a.

Re: [PERFORM] Parsing VACUUM VERBOSE

2007-06-18 Thread Guillaume Smet
On 6/18/07, Sabin Coanda <[EMAIL PROTECTED]> wrote: Hi Guillaume, I tried pgFouine.php app on a sample log file but it reports me some errors. Could you give me some startup support, please ? I attach the log here to find what's wrong. Sorry for the delay. I answered to your private email this

Re: [PERFORM] Parsing VACUUM VERBOSE

2007-06-18 Thread Y Sidhu
On 6/18/07, Sabin Coanda <[EMAIL PROTECTED]> wrote: ""Guillaume Smet"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Sabin, > > On 6/14/07, Sabin Coanda <[EMAIL PROTECTED]> wrote: >> I'd like to understand completely the report generated by VACUUM VERBOSE. >> Please tell me wher

Re: [PERFORM] Parsing VACUUM VERBOSE

2007-06-18 Thread Sabin Coanda
""Guillaume Smet"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Sabin, > > On 6/14/07, Sabin Coanda <[EMAIL PROTECTED]> wrote: >> I'd like to understand completely the report generated by VACUUM VERBOSE. >> Please tell me where is it documented ? > > You can take a look to what I

Re: [PERFORM] Parsing VACUUM VERBOSE

2007-06-14 Thread Y Sidhu
On 6/14/07, Guillaume Smet <[EMAIL PROTECTED]> wrote: On 6/14/07, Y Sidhu <[EMAIL PROTECTED]> wrote: > Can anyone share what value they have set log_min_duration_statement to? It's OT but we use different values for different databases and needs. On a very loaded database with a lot of complex

Re: [PERFORM] Parsing VACUUM VERBOSE

2007-06-14 Thread Guillaume Smet
On 6/14/07, Y Sidhu <[EMAIL PROTECTED]> wrote: Can anyone share what value they have set log_min_duration_statement to? It's OT but we use different values for different databases and needs. On a very loaded database with a lot of complex queries (lots of join on big tables, proximity queries,

Re: [PERFORM] Parsing VACUUM VERBOSE

2007-06-14 Thread Y Sidhu
On 6/14/07, Dimitri Fontaine <[EMAIL PROTECTED]> wrote: Le jeudi 14 juin 2007, Sabin Coanda a écrit: > I'd like to understand completely the report generated by VACUUM VERBOSE. > Please tell me where is it documented ? Try the pgfouine reporting tool : http://pgfouine.projects.postgresql.org/

Re: [PERFORM] Parsing VACUUM VERBOSE

2007-06-14 Thread Sabin Coanda
Hi Guillaume, Very interesting ! Merci beaucoup, Sabin ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [PERFORM] Parsing VACUUM VERBOSE

2007-06-14 Thread Dimitri Fontaine
Le jeudi 14 juin 2007, Sabin Coanda a écrit : > I'd like to understand completely the report generated by VACUUM VERBOSE. > Please tell me where is it documented ? Try the pgfouine reporting tool : http://pgfouine.projects.postgresql.org/ http://pgfouine.projects.postgresql.org/reports/sample_

Re: [PERFORM] Parsing VACUUM VERBOSE

2007-06-14 Thread Guillaume Smet
Sabin, On 6/14/07, Sabin Coanda <[EMAIL PROTECTED]> wrote: I'd like to understand completely the report generated by VACUUM VERBOSE. Please tell me where is it documented ? You can take a look to what I did for pgFouine: http://pgfouine.projects.postgresql.org/vacuum.html -- Guillaume --