Re: [HACKERS] Why is sorting on two columns so slower than sortingon one column?

2010-12-23 Thread Li Jie
ber 23, 2010 10:03 PM Subject: Re: [HACKERS] Why is sorting on two columns so slower than sortingon one column? > On Thu, Dec 23, 2010 at 02:33:12AM -0500, Jie Li wrote: >> Hi, >> >> Here is the test table, >> >> postgres=# \d big_wf >> Table &qu

Re: [HACKERS] Why is sorting on two columns so slower than sortingon one column?

2010-12-23 Thread Kenneth Marshall
On Thu, Dec 23, 2010 at 10:19:46PM +0800, Li Jie wrote: > Hi Ken, > > Thanks for your tips! Yes it is the case, and I run another query sorting on > the second column whose values are random. > > postgres=# explain analyze select * from big_wf order by id; >