Re: High update activity, PostgreSQL vs BigDBMS - Mailing list pgsql-performance

From Tom Lane
Subject Re: High update activity, PostgreSQL vs BigDBMS
Date
Msg-id 6903.1167317814@sss.pgh.pa.us
Whole thread Raw
In response to Re: High update activity, PostgreSQL vs BigDBMS  ("Shoaib Mir" <shoaibmir@gmail.com>)
Responses Re: High update activity, PostgreSQL vs BigDBMS
List pgsql-performance
"Shoaib Mir" <shoaibmir@gmail.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

pgsql-performance by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: Advice on selecting good values for work_mem?
Next
From: "fabrix peñuelas"
Date:
Subject: Postgresql Configutation and overflow