Re: [PATCH] Partial indicies again - Mailing list pgsql-general

From Tom Lane
Subject Re: [PATCH] Partial indicies again
Date
Msg-id 28736.994773398@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] Partial indicies again  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: [PATCH] Partial indicies again  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> To actually be able to use ExecInsertIndexTuples, you need to create an
> EState, a ResultRelInfo and put each tuple in a TupleSlot for a while. Does
> it sound like I'm on the right track? That's quite a few changes.

Right.  I'd recommend copy.c as a model.

> Isn't someone else playing with the vacuum code for 7.2 anyway (for
> background vacuums)? We'd better make sure we don't clash.

That would be me.

> Back to other issues. pg_dump now works for partial indicies, as long as the
> pg_get_expr function is defined. To make that an internal function I have
> add it to pg_proc.h and initdb again, right?

Right.  I'd suggest sticking the source in ruleutils.c.

            regards, tom lane

pgsql-general by date:

Previous
From: Janning Vygen
Date:
Subject: Re: Performance tuning for linux, 1GB RAM, dual CPU?
Next
From: Philip Molter
Date:
Subject: Re: Performance tuning for linux, 1GB RAM, dual CPU?