Re: Putting index entries to XLog

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Putting index entries to XLog
Дата
Msg-id 20100228113610.GA27450@svana.org
обсуждение исходный текст
Ответ на Putting index entries to XLog  (Carsten Kropf <ckropf2@fh-hof.de>)
Список pgsql-general
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,
howto set it up properly) using my index. However, when I don't have the situation of working with a temporary table, I
needto put entries using XLogInsert(...). The problem for me is, that based on the fact, that I don't have the access
tothe RM, I can't put proper entries to the xlog facility. How can I achieve that my index structure can be stored
properlyat 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
doingXLogInsert calls to work with the component properly I don't know which data to put in there. When I'm using some
kindof 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
ofmy 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

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

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas
Дата:
Сообщение: does writer process also write data to WAL log files ?
Следующее
От: Bastiaan Wakkie
Дата:
Сообщение: Re: regexp_replace: LF, CR, or tab