Re: [pgsql-benchmarks] [PERFORM] stats on cursor and query execution troubleshooting

2004-10-08 Thread Tom Lane
=?ISO-8859-1?Q?=22Alban_M=E9dici_=28NetCentrex=29=22?= <[EMAIL PROTECTED]> writes: > Thanks for your repply, but I still don"t understand why the statistic > logs : > ! 0/0 [0/0] filesystem blocks in/out > it told me there is no hard disk access, I'm sure there is, Complain to your friend

Re: [PERFORM] stats on cursor and query execution troubleshooting

2004-10-08 Thread "Alban Médici (NetCentrex)"
Thanks for your repply,  but I still don"t understand why the statistic logs   : !   0/0 [0/0] filesystem blocks in/out it told me there is no hard disk access, I'm sure there is,  I heard my HDD,  and see activity using gkrellm (even using my first query ; big select *) ? 2004-10-08 10

Re: [PERFORM] stats on cursor and query execution troubleshooting

2004-10-06 Thread Tom Lane
=?ISO-8859-1?Q?=22Alban_M=E9dici_=28NetCentrex=29=22?= <[EMAIL PROTECTED]> writes: > I'm looking for the statistic of memory, CPU, filesystem access while=20 > executing some regular SQL query, and I want to compare them to > same kind of results while executing a cursor function. I think your

[PERFORM] stats on cursor and query execution troubleshooting

2004-10-06 Thread "Alban Médici (NetCentrex)"
Hi, I'm looking for the statistic of memory,  CPU,  filesystem access while executing some regular SQL query,  and I want to compare them to same kind of results while executing a cursor function. The stat collector give me good results (sequencial scans ,  acceded tuple .)  for regular