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

do you need all of verbose information?? VACUUM FULL ANALYZE VERBOSE give me a lot of infomation, so i just cut zipcode parts. ==start=== INFO:Â vacuuming "public.zipcode" INFO:Â "zipcode": found 0 removable, 47705 non

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

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. Y