Re: Slow table update

From: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Gregory Williamson <Gregory(dot)Williamson(at)digitalglobe(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, Daniel Fekete <danieleff(at)gmail(dot)com>
Subject: Re: Slow table update
Date: 2008-12-29 09:43:42
Message-ID: 49589BCE.5080201@shopzeus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Williamson 2008-12-29 11:00:44 Re: Slow table update
Previous Message Laszlo Nagy 2008-12-29 08:06:51 Re: rebellious pg stats collector (reopened case)