Horton

Re: indexes greatly slowing data entry

Tom Burke <lists@spamex.com>

View thread View on postgr.es
From: "Tom Burke" <lists@spamex.com>
To: "DE Sesa, Michael C." <michael.desesa@exeloncorp.com>, <pgsql-general@postgresql.org>
Date: 2002-06-25T19:21:48Z
Lists: pgsql-general 
> I do an automated vacuum analyze nightly.  Performance is not increased
> afterward.

I have experienced problems with indexes on varchar columns causing
updates to be very slow. You might also try doing a REINDEX TABLE 
command on the relevant tables. I have found this to give a 
performance increase for queries/updates, but generally still find 
character indexes to drag down insert/update performance.

Tom Burke
Eppend
http://www.eppend.com/