On Dec 2, 2007 11:26 AM, Mindaugas <ml@xxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
