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;
, December 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 public.big_wf
Column | Type | Modifiers