On Dec 2, 2007 11:26 AM, Mindaugas <ml(at)kilimas(dot)com> wrote:
> I execute simple query "select * from bigtable where From='something'". Query returns like 1000 rows and takes 5++ seconds to complete. As far as I understand the query is slow because:
Can you post an EXPLAIN ANALYZE? Which version of PostgreSQL do you use?
--
Guillaume