Reinhard Max <[EMAIL PROTECTED]> writes:
> It has a unique index on id, non-unique indexes on all othe columns,
> and contains approx. 350000 rows.
Do you actually *need* an index on every single column? How many of
those columns are you actually going to use for searches on a frequent
basis?
Creating an index is a straightforward tradeoff of more time spent for
updates to save on searches. I suspect you have made a bad tradeoff.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
