From: | "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com> |
---|---|
To: | "Bruce Momjian" <bruce(at)momjian(dot)us> |
Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org, PGSQL-Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] [Fwd: Index Advisor] |
Date: | 2007-04-12 12:55:14 |
Message-ID: | 65937bea0704120555x7e41ff54l372b7e80445d0e1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On 4/12/07, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>
> Gurjeet Singh wrote:
> > The interface etc. may not be beautiful, but it isn't ugly either!
> It is
> > a lot better than manually creating pg_index records and inserting them
> into
> > cache; we use index_create() API to create the index (build is
> deferred),
> > and then 'rollback to savepoint' to undo those changes when the advisor
> is
> > done. index_create() causes pg_depends entries too, so a 'RB to SP' is
> far
> > much safer than going and deleting cache records manually.
>
> My complaint was not that the API used in the code was non-optimal(which
> I think was Tom's issue), but that the _user_ API was not very clean.
> Not sure what to recommend, but I will think about it later.
>
>
That can be fixed/improved with minimal efforts, but if it is the internal
API usage, or the architecture we're bothered about, then IMO just an
overhaul of the code will not be sufficient, rather, it will require rework
from scratch.
Best regards,
--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | yahoo }.com
17°29'34.37"N 78°30'59.76"E - Hyderabad
18°32'57.25"N 73°56'25.42"E - Pune *
From | Date | Subject | |
---|---|---|---|
Next Message | NikhilS | 2007-04-12 12:56:14 | Re: Bug about column references within subqueries used in selects |
Previous Message | Jim Nasby | 2007-04-12 12:51:06 | Re: elog(FATAL) vs shared memory |
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2007-04-12 13:26:24 | Re: Slow Postgresql server |
Previous Message | Alvaro Herrera | 2007-04-12 12:42:51 | Re: autovacuum multiworkers, patch 5 |