before test, I already executed VACUUM FULL.|
this result show up after vacuum full.
Tom Lane ì ê:
=?UTF-8?B?7J6l7ZiE7ISx?= <[EMAIL PROTECTED]> writes:but, sequence scan, as you see above result, there is big time difference between using LIMIT and without using it.You've got a table full of dead rows. Try VACUUM FULL ...regards, tom lane
- Re: [PERFORM] Using "LIMIT" is much faster even ... Hyun-Sung, Jang