Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Performance decrease
- From: Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de>
- To: Radovan Antloga <radovan(dot)antloga(at)siol(dot)net>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Performance decrease
- Date: Thu, 20 Apr 2006 23:19:44 +0200
On 20.04.2006, at 18:10 Uhr, Radovan Antloga wrote:
I have once or twice a month update on many records (~6000) but not so many. I did not expect PG would have problems with updating 15800 records.
It has no problems with that. We have a database where we often update/insert rows with about one hundred columns. No problem so far. Performance is in the sub 10ms range. The whole table has about 100000 records.
Do you wrap every update in a separate transaction? I do commits every 200 updates for bulk updates.
cug -- PharmaLine, Essen, GERMANY Software and Database Development
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
- References:
- Performance decrease
- From: Radovan Antloga
- Re: Performance decrease
- From: Tom Lane
- Re: Performance decrease
- From: Radovan Antloga
- Performance decrease
- Prev by Date: Re: Recovery will take 10 hours
- Next by Date: Re: Recovery will take 10 hours
- Previous by thread: Re: Performance decrease
- Next by thread: Slow deletes in 8.1 when FKs are involved
- Indexes: