Re: 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?= <siche@siche.net> 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
>
>  
>