Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tiago Antão <tra(at)fct(dot)unl(dot)pt>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan
Date: 2000-08-20 18:03:15
Message-ID: 10706.966794595@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

=?iso-8859-1?Q?Tiago_Ant=E3o?= <tra(at)fct(dot)unl(dot)pt> writes:
> PS - I'm starting the thesis part of a MSc which will be about query
> optimization in pg. Here the thesis part of the MSc takes arround one
> year, so at least for the next year I'll try to work hard on pg.

Cool! Please keep us posted on what you're doing or thinking about
doing, so that there's not duplicate or wasted effort.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2000-08-20 18:16:01 Re: CREATE/DROP SCHEMA considered harmful
Previous Message Don Baccus 2000-08-20 17:48:44 Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan