Re: UPDATE

1.5 GB RAM, Pentium dual core, single 80 GB disk, Windows XP sp3, PostgreSQL
8.3.6
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(at)archonet(dot)com> 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
>