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

[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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster