Re: [BUGS] performance problems on updates on large tables with indexes

2002-02-27 Thread Tom Lane
Reinhard Max <[EMAIL PROTECTED]> writes: > It has a unique index on id, non-unique indexes on all othe columns, > and contains approx. 35 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? C

[BUGS] performance problems on updates on large tables with indexes

2002-02-27 Thread Reinhard Max
Hi, I am not sure whether the behaviour described below is to be expected or to be considered as a bug, but I bet you can tell me ;) I have a table defined as follows: CREATE TABLE "foo" ( "id" int NOT NULL, "name" character varying(256) NOT NULL, "street" character vary