Re: [GENERAL] Use order by clause, got index scan involved

Hi Jeff Thank you for your reply. I will try to learn about effective_cache_size . Jian gao 2012/11/9 Jeff Janes > On Wed, Nov 7, 2012 at 11:41 PM, 高健 wrote: > >> Hi all: >> >> >> >> What confused me is that: When I select data using order by clause, I >> got the following execution plan: >

Re: [GENERAL] Use order by clause, got index scan involved

On Wed, Nov 7, 2012 at 11:41 PM, 高健 wrote: > Hi all: > > > > What confused me is that: When I select data using order by clause, I > got the following execution plan: > > > > postgres=# set session > enable_indexscan=true; > > > SET > > > postgres=# explain SELECT * FROM pg_proc ORDER BY > oid;

[GENERAL] Use order by clause, got index scan involved

Hi all: What confused me is that: When I select data using order by clause, I got the following execution plan: postgres=# set session enable_indexscan=true; SET postgres=# explain SELECT * FROM pg_proc ORDER BY oid; QUERY PLAN ---