On Dec 2, 2007 11:26 AM, Mindaugas <[EMAIL PROTECTED]> 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

Reply via email to