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

nice updates

From: michael lush <mjlush(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: nice updates
Date: 2011-08-23 08:23:52
Message-ID: CACXX7Menztz3-dtUvQ0k-jAPUdgNgipSw-o7YOv3PCrf6Xc3Dw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
I've got a regular large update running on postgres 8.4.2 (under
CentOS 5), that when its running slows other updates to a crawl.

Is it possible to renice the large update so it does not block the
other updates?

--
Michael

pgsql-novice by date

Next:From: chouaffe frannck-edmondDate: 2011-08-23 15:21:50
Subject: PGobject issue
Previous:From: Merlin MoncureDate: 2011-08-22 21:27:18
Subject: Re: Data corruption after an update set ...?

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