Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan
Date
Msg-id 200010140420.AAA22768@candle.pha.pa.us
Whole thread Raw
In response to Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan  (Tiago Antão <tra@fct.unl.pt>)
Responses Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan
List pgsql-hackers
Tree view 
> On Mon, 21 Aug 2000, Tom Lane wrote:
> 
> > >   One thing it might be interesting (please tell me if you think
> > > otherwise) would be to improve pg with better statistical information, by
> > > using, for example, histograms.
> > 
> > Yes, that's been on the todo list for a while.
> 
>   If it's ok and nobody is working on that, I'll look on that subject.
>   I'll start by looking at the analize portion of vacuum. I'm thinking in
> using arrays for the histogram (I've never used the array data type of
> postgres).
>   Should I use 7.0.2 or the cvs version?

If you don't like the analyze part, you can blame me.  It is
non-optimal, but lean.


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan
Next
From: Tom Lane
Date:
Subject: Re: AW: Inserting a select statement result into another ta ble