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

Re: High update activity, PostgreSQL vs BigDBMS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
Cc: "Guy Rouillier" <guyr-ml1(at)burntmail(dot)com>, "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: High update activity, PostgreSQL vs BigDBMS
Date: 2006-12-28 14:56:54
Message-ID: 6903.1167317814@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"Shoaib Mir" <shoaibmir(at)gmail(dot)com> writes:
> Here are my few recommendations that might help you:
> [ snip good advice ]

Another thing to look at is whether you are doing inserts/updates as
individual transactions, and if so see if you can "batch" them to
reduce the per-transaction overhead.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Jeff FrostDate: 2006-12-28 22:15:31
Subject: Re: High update activity, PostgreSQL vs BigDBMS
Previous:From: Simon RiggsDate: 2006-12-28 13:19:44
Subject: Re: Advice on selecting good values for work_mem?

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