From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Zeugswetter Andreas IZ5" <Andreas(dot)Zeugswetter(at)telecom(dot)at> |
Cc: | "pgsql-hackers" <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | RE: [HACKERS] Caution: tonight's commits force initdb |
Date: | 1999-08-24 10:39:03 |
Message-ID: | 000b01beee1c$e27b9f00$2801007e@cadzone.tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> -----Original Message-----
> From: owner-pgsql-hackers(at)postgreSQL(dot)org
> [mailto:owner-pgsql-hackers(at)postgreSQL(dot)org]On Behalf Of Zeugswetter
> Andreas IZ5
> Sent: Tuesday, August 24, 1999 6:48 PM
> To: pgsql-hackers
> Subject: AW: [HACKERS] Caution: tonight's commits force initdb
>
>
>
> > Hmm,Index scan is chosen to select all rows.
> > AFAIK,sequential scan + sort is much faster than index scan in
> > most cases.
> >
> > cost of index scan < cost of sequential scan + cost of sort
> >
> This is usually true. It might need resources though that are not
> available,
Without taking SORT into account
[From my example]
cost of sequential scan = 1716.32 and
cost of index scan = 2284.55
cost of sequential scan > cost of index scan * 0.7
It's unbelievable for me.
> e.g. 8 GB sort space. It also depends on whether the application is
> interested in
> first row (interactive), or all row performance (batch). Other DB's can
> switch modes
> to decide on the wanted behavior. So I think there is no yes/no
> decision on
> this.
>
We could use LIMIT clause to get first rows now and optimizer
should take LIMIT/OFFSET into account(TODO item).
Regards.
Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp
From | Date | Subject | |
---|---|---|---|
Next Message | Ansley, Michael | 1999-08-24 10:56:33 | RE: [HACKERS] Lex and things... |
Previous Message | Leon | 1999-08-24 10:16:00 | Re: [HACKERS] Lex and things... |