Jie Liang <jliang(at)ipinc(dot)com> writes:
> I vacuumed urlinfo already.
VACUUM ANALYZE, or just VACUUM?
> urlinfo_pkey is primary key (id), urlinfo_ukey is unique key (url)
> when I:
> SELECT id FROM urlinfo WHERE url='http://*.yahoo.com';
> It seems taking me longer than before.
What does EXPLAIN say about it?
regards, tom lane