Christo Du Preez wrote: > The actual table I noticed the problem has a million rows and it still > doesn't use indexing
So ANALYZE it. -- Alvaro Herrera Developer, http://www.PostgreSQL.org/ "Amanece. (Ignacio Reyes) El Cerro San Cristóbal me mira, cínicamente, con ojos de virgen" ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
