Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 29 Dec 2008 10:43:42 +0100
- Message-id: <49589BCE.5080201@shopzeus.com> <text/plain>
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.
- Follow-Ups:
- Re: Slow table update
- From: Gregory Williamson
- Re: Slow table update
- References:
- Slow table update
- From: Laszlo Nagy
- Re: Slow table update
- From: Laszlo Nagy
- Re: Slow table update
- From: Gregory Williamson
- Re: Slow table update
- From: Laszlo Nagy
- Re: Slow table update
- From: Tom Lane
- Slow table update
- Prev by Date: Re: Troubles dumping a very large table.
- Next by Date: Re: Slow table update
- Previous by thread: Re: Slow table update
- Next by thread: Re: Slow table update
- Indexes: