Reinhard Max <max(at)suse(dot)de> 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
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
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2002-02-27 23:04:09|
|Subject: Re: missing foreign key fails silently using COPY |
|Previous:||From: Jean-Paul ARGUDO||Date: 2002-02-27 16:36:01|
|Subject: Re: function tree_level(varchar) (from OpenACS) no longer work under 7.2|