[HACKERS] How to cache a non-unique index?

2009-12-07 Thread Xin Wang
Hi, I have added a catalog table with an index on a non-unique column. I want to cache this non-unique index like other unique indexes in syscache. Is there any way to cache a non-unique index? I just want the index to reside in the memory to speed up the index lookup. Thank you! Wang -- Sent

[HACKERS] Using a C++ library in PostgreSQL

2009-07-19 Thread Xin Wang
to call a C++ API in a C code base. Could anyone here give me some guidelines to do it? Can the recently discussed "Mostly Harmless C++" patch be helpful to what I want to do? Thank you in advance! Xin Wang

[HACKERS] Memory exhaustion during bulk insert

2009-04-14 Thread Xin Wang
Hi all, I'm doing an experimental project using Postgres as the prototype. I want to store attribute values of xml type in an internal XML table which is created for every XML column. One XML node (element, attribute or text) is stored as a tuple in the XML table. While a 127MB XML document 'dblp.

[HACKERS] How to implement an auto-increment column for a system catalog table?

2009-03-15 Thread Xin Wang
Hi all, I am using Postgres to build the prototype in a research project. I need to create a new system catalog table with an auto-increment column. For a ordinary table, CREATE SEQUENCE or a serial type can be used to implement the auto-increment column, but it seems Postgres do not support creati

[HACKERS] Where can I find the doxyfile?

2008-05-31 Thread Xin Wang
Hi, I don't know where I can find the doxyfile which generate "doxygen.postgresql.org" web site. I found that when reading code the doxygen source code is quite helpful. However, I want to generate an off-line copy of doxygen docs myself, but I can't find the doxyfile in the lastest source release.