Skip site navigation (1) Skip section navigation (2)

Re: MVCC performance issue

From: Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
To: Kyriacos Kyriacou <kyriacosk(at)prime-tel(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: MVCC performance issue
Date: 2010-11-12 15:53:35
Message-ID: 4CDD62FF.4020009@gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
12.11.10 15:47, Kyriacos Kyriacou написав(ла):
> PROBLEM DECRIPTION
> ------------------
> As an example, consider updating the "live" balance
> of a customer for each phone call where the entire customer record has
> to be duplicated again and again upon each call just for modifying a
> numeric value!
>    
Have you considered splitting customer record into two tables with 
mostly read-only data and with data that is updated often? Such 1-1 
relationship can make a huge difference to performance in your case. You 
can even try to simulate old schema by using an updateable view.

Best regards, Vitalii Tymchyshyn

In response to

Responses

pgsql-performance by date

Next:From: Pavel StehuleDate: 2010-11-12 16:12:26
Subject: Re: postmaster consuming /lots/ of memory with hash aggregate. why?
Previous:From: Kenneth MarshallDate: 2010-11-12 15:37:08
Subject: Re: MVCC performance issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group