Any way to make this PostgreSQL count query any faster?
- by Ben Dauphinee
I'm running a case-insensitive search on a table with 7.2 million rows, and I was wondering if there was any way to make this query any faster?
Currently, it takes approx 11.6 seconds to execute, with just one search parameter, and I'm worried that as soon as I add more than one, this query will become massively slow.
SELECT count(*)
FROM "exif_parse"
WHERE (description ~* 'canon')