On 31/03/2008 20:16, mark wrote:
is the query I am running , and it takes over 10 seconds to complete
this query...
update users set number_recieved=number_recieved+1 where uid=738889333;
table has about 1.7 million rows.. i have an index on column uid and
also on number_received. .. this is also slowing down the inserts that
happen.
Are you VACUUMing the table regularly?
Also, can you show us the EXPLAIN ANALYZE output from the query?
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@xxxxxx
---------------------------------------------------------------
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
