Postgres Pro
Downloads
Home   >   mailing lists

Re: MVCC and index-only read - Mailing list pgsql-general

From Scara Maccai
Subject Re: MVCC and index-only read
Date
Msg-id 740168.33784.qm@web28104.mail.ukl.yahoo.com
Whole thread Raw
In response to Re: MVCC and index-only read  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: MVCC and index-only read  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-general
Tree view 
> FWIW, I believe that count(*) is pretty slow in Oracle too.

Well COUNT was only an example. I think (but I'm not sure AT ALL) that

SELECT A FROM myTAB where A <10000

only uses the index (if there's an index defined for A) in Oracle.

But mine was just curiosity... which I think you and Sam answered.

Thank you.







      Unisciti alla community di Io fotografo e video, il nuovo corso di fotografia di Gazzetta dello sport:
http://www.flickr.com/groups/iofotografoevideo

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Any risks in using FUNCTIONs (stored procedures) instead of raw sql queries?
Next
From: "Jonah H. Harris"
Date:
Subject: Re: MVCC and index-only read