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

=?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 -

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

hello~ i'm curious about this situation. here is my test. my zipcode table has 47705 rows, and schema looks like this. pgsql=# \d zipcode Table "public.zipcode" Column | Type | Modifiers -+---+--- zipcode | character(7) | not null sido | character varying(4) |