Re: Slow table update - Mailing list pgsql-performance

From Laszlo Nagy
Subject Re: Slow table update
Date
Msg-id 49589BCE.5080201@shopzeus.com
Whole thread Raw
In response to Re: Slow table update  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
>> My other idea was that there are so many indexes on this table, maybe
>> the update is slow because of the indexes?
>>
>
> Updating indexes is certainly very far from being free.  How many is
> "many"?
>
Number of indexes = 15.

3 indexex are on "text" type column, 500MB in size each.
Other are on int8 and timestamp columns, cca. 200MB each.



pgsql-performance by date:

Previous
From: Ted Allen
Date:
Subject: Re: Troubles dumping a very large table.
Next
From: "Gregory Williamson"
Date:
Subject: Re: Slow table update