[GENERAL] Needs Suggestion

cut technique. -- Thank You, Subham Roy, CSE IIT Bombay.

[GENERAL] Needs Suggestion

? -- Thank You, Subham Roy, CSE IIT Bombay.

Re: [GENERAL] Needs Suggestion

Tools Informations... pgPool unavailable!* However,it generates few reports on the mentioned directory. But I am not able to understand how to use it to measure the performance for each query that I run. -- Thank You, Subham Roy, CSE IIT Bombay.

[GENERAL] Number of Physical I/Os

Can we measure the number of Physical I/Os or Disk I/Os for a particular query in Postgres? In Oracle we can do this with the help of a TraceFile & TKPROF. -- Thank You, Subham Roy, CSE IIT Bombay.

[GENERAL] Problem with encoding

s it impose any problem while querying, i.e. while running queries. -- Thank You, Subham Roy, CSE IIT Bombay.

[GENERAL] Needs Suggestion

Can I calculate the *Buffer Hit ratio* *of a particular query* in postgres? That is *how many times it finds the required page* in its buffer cache, pg_buffercache or the linux buffer cache. -- Thank You, Subham Roy, CSE IIT Bombay.

Re: [GENERAL] Needs Suggestion

I am using postgres 8.4.8, the above command explain(analyze,buffers) is not working. Is there a way to do that. -- Thank You, Subham Roy, CSE IIT Bombay.

[GENERAL] explain analyze buffer

I am using postgres 8.4.8. EXPLAIN (ANALYZE,BUFFERS) is not working. So is there any patch available for it? If so, kindly specify from where to get it and how to install it. -- Thank You, Subham Roy, CSE IIT Bombay.

[GENERAL] Needs Suggestion

buffers* that postgres uses? -- Thank You, Subham Roy, CSE IIT Bombay.