a table is like following:
-- Table: accgroups
-- DROP TABLE accgroups;
CREATE TABLE accgroups
(
accgroupid serial NOT NULL,
accgroupidname character varying(150) NOT NULL DEFAULT ''::character varying,
accgroupname character varying,
createdby integer DEFAULT 0,
createdtimestamp timestamp without time zone DEFAULT ('now'::text)::timestamp without time zone,
locked smallint,
lastmodifiedby integer DEFAULT 0,
lastmodifiedtimestamp timestamp without time zone,
remark character varying(255) DEFAULT NULL::character varying,
cobranchid integer DEFAULT 0,
.
.
.
.
againstid integer DEFAULT 0,
)
WITH (OIDS=FALSE);
This table has currently 1,65,000+ rows.
Query is fairly simple.
update accgroups set cobranchid=2 where cobranchid=1;
Thanks
CPKulkarni
On Thu, Feb 19, 2009 at 6:54 PM, Richard Huxton <dev@xxxxxxxxxxxx> wrote:
> What can be done for such updates to make them faster?You're going to have to provide some sort of information before anyone
can help you.
You might want to start with: basic hardware details: ram, number of
disks etc, O.S. version, PostgreSQL version, basic configuration changes
you've made, sample queries that are slow along with explain analyse
output (if it's not just a blanket update), table definitions...
--
Richard Huxton
Archonet Ltd