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.


You've got a table full of dead rows.  Try VACUUM FULL ...


			regards, tom lane

Advertising