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:40:05

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 dont 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 friendly

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