[HACKERS] Ask help for putting SP-Gist into postgresql

Hi, I am trying to put the SP-Gist package, a general index framework for space partitioning trees , into Postgresql source code. SP-Gist was developed for postgresql 8.0. However, now it does not work with the new version. So, for the submitted patch, what version of postgresql is required? And,

[HACKERS] Problem of Magic Block in Postgres 8.2

Hi, I have some old code for extension functions in Postgres 8.0. And, I am trying to make it work with Postgres 8.2. One problem is about the Magic Block. The extension functions was developed by C++ mixed with C. The code is like: extern "C" Datum spgistinsert(PG_FUNCTION_ARGS) { ... } I have

[HACKERS] Get the offset of a tuple inside a table

Hi, When I using an index scan, can I get the offset of the tuple in the table? Thanks -- Pei

Re: [HACKERS] Get the offset of a tuple inside a table

On Tue, Sep 21, 2010 at 5:44 PM, Szymon Guz wrote: > > > On 21 September 2010 23:02, Pei He wrote: > >> Hi, >> When I using an index scan, can I get the offset of the tuple in the >> table? >> >> Thanks >> -- >> Pei >> > > What do you mean by "the offset in the table"? >

Re: [HACKERS] Get the offset of a tuple inside a table

47 PM, Kevin Grittner wrote: > Pei He wrote: > > > The offset is the order of a tuple in a Sequential Scan. > > That's not a safe assumption. Try starting a sequential scan against > a large table on one connection; then before it finishes, start the > same query on ano

Re: [HACKERS] Get the offset of a tuple inside a table

. The bitmapscan needs to remember what have to been retrieved later, so it used the tidbitmap. But, for me, I need the bitmapset. Thanks, your reply helps me to find the bitmapset. Regards -- Pei On Tue, Sep 21, 2010 at 9:32 PM, Tom Lane wrote: > Pei He writes: > > What I want to do

[HACKERS] Compute the number of tuples in a block

Hi, In ctid, there are the block num, and the tuple offset inside the block. How can I know the maximum number of tuples in a block? The block size would be BLCKSZ. I am not quite sure where is the best place to find the size of the tuple in a table. Thanks -- Pei

[HACKERS] About debug two versions of postgresql in eclipse

Hi, I want to run two different versions of postgresql-8.2.5 under eclipse. But, it requires me to change PGDATA and LD_LIBRARY_PATH to switch. Moreover, to let eclipse know the changes, I need to modify .profile under my home folder, and log out and log in. (I am using Ubuntu.) Is there a way t

Re: [HACKERS] About debug two versions of postgresql in eclipse

Thanks, Nicolas. It works. -- Pei On Tue, Aug 24, 2010 at 2:38 PM, Nicolas Barbier wrote: > 2010/8/24 Pei He : > >> I want to run two different versions of postgresql-8.2.5 under eclipse. >> >> But, it requires me to change PGDATA and LD_LIBRARY_PATH to switch. >&g

[HACKERS] About the types of fields in a data structure

Hi, When I check the types of fields in a data structure, I found most fields are defined as general types, as List, Node. Then, To know the content inside the List, I need to track the usage of the fields. For example, the fromClause in SelectStmt is defined as List. And, the content in the ListCe

[HACKERS] How to construct an exact plan

Hi, I have developed a new operators, and I want to do some tests on it. I do not want the optimizer to choose the plan for me, and I need to construct a plan as exact as I want. Can anyone provide me a way to achieve that? Thanks -- Pei -- Sent via pgsql-hackers mailing list (pgsql-hackers@pos

Re: [HACKERS] How to construct an exact plan

I forgot to mention that I am using postgresql 8.2.5. Thanks -- Pei On Mon, Aug 30, 2010 at 1:34 PM, Pei He wrote: > Hi, > I have developed a new operators, and I want to do some tests on it. > I do not want the optimizer to choose the plan for me, and I need to > construct a plan a

Re: [HACKERS] How to construct an exact plan

Hi, I am hacking postgresql 8.2.5. a) and b) do not work for me. The situation is that I made a join operator, and a scan operator. And, The join operator requires the scan operator as the inner. So, I need to have the full control of the join plan. I am not ready to provide the optimization supp