Hi all,
I am interested in the answer as well -- how to get a table name (or
an operator name)
from an OID.the parser must know how to do this, but the segment
of code is hard
to locate.
thanks a lot,
Huaxin
On 11/7/05, Paresh Bafna <[EMAIL PROTECTED]> wrote:
> Actually I want to do this fr
I need a way to tell how many pages loaded from disk for a particular
index seek operation.
What I did is to set a global flag to true before calling the
following statement
(inside index_getnext() in "/backend/access/indexam.c")
found = DatumGetBool(FunctionCall2(&scan->fn_getnext,
not sure where to put this.
I run two queries:
1. select count(*) from table where indexed_column<10;
2. select * from table where indexed_column<10;
the indexed column is not clustered at all. I saw from the trace that
both query runs
through index scans on that index and takes the same amoun
i am using postgresql 8.0.3 as a single user by running "postgres"
I want to purge all contents in the bufferpool, and I did this by
calling "InitBufTable(256)" (buf_table.c) after each query. However,
this seems not working for each followup query I still get less disk read
(tracked by "smgrread
I am new to this hacker's job. What I was looking for was to record
the actual disk IO performed for arbituary query plan. I searched
in backend/executor but not sure if that was the right place to
add a tracer. would the /backend/storage be the place that controls
the actual I/O? btw, is t
