Re: [PERFORM] Using "LIMIT" is much faster even though, searching

[Hyun-Sung, Jang]

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