Search Postgresql Archives

Re: Putting index entries to XLog

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I didn't see an answer to this, so I thought I'd point out that you do
not need to do anything with XLOG to make a functional index. It is
only necessary when you want to make it crash-safe or work over SR.

But when you're building a new index type, making it crash safe is one
of the last things on the list. So unless you're really far I'd suggest
dropping everything XLog realted and coming back to it later.

Have  anice day,

On Thu, Feb 25, 2010 at 12:41:36PM +0100, Carsten Kropf wrote:
> Hi *,
> I have encountered a problem while implementing an index structure. I don't have any access to the RM (I don't know, how to set it up properly) using my index. However, when I don't have the situation of working with a temporary table, I need to put entries using XLogInsert(...). The problem for me is, that based on the fact, that I don't have the access to the RM, I can't put proper entries to the xlog facility. How can I achieve that my index structure can be stored properly at least?
> I'm getting lots of errors, when I just put a XLogRecPtr with data {1,1} as LSN of the page. On the other hand when doing XLogInsert calls to work with the component properly I don't know which data to put in there. When I'm using some kind of RM_ID (like RM_GIST_ID or something like that) I'm getting problems because I don't know which code to insert there. I decided to take RM_GIST_ID and an invalid code (so it won't call any of the xlog gist implementations upon recovery) which, however failed, too. Unfortunately my task is to implement a certain structure with PostgreSQL, so all of my current work actually depend on this action.
> I hope that somebody will be able to help me according to this issue.
> Thanks in advance
> 
> Best regards
> 	Carsten Kropf
> -- 
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

-- 
Martijn van Oosterhout   <kleptog@xxxxxxxxx>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while 
> boarding. Thank you for flying nlogn airlines.

Attachment: signature.asc
Description: Digital signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux