/07, Decibel! <[EMAIL PROTECTED]> wrote:
> > > On Tue, Aug 07, 2007 at 02:33:19PM +0100,
> Richard Huxton wrote:
> > > > Mark Makarowsky wrote:
> > > > >I have a table with 4,889,820 records in it.
> The
> > > > >table also has 47 f
I have a table with 4,889,820 records in it. The
table also has 47 fields. I'm having problems with
update performance. Just as a test, I issued the
following update:
update valley set test='this is a test'
This took 905641 ms. Isn't that kind of slow? There
aren't any indexes, triggers, con
o
(
firest_id character(8),
fire_dist double precision,
xno character(10)
)
WITHOUT OIDS;
ALTER TABLE fco OWNER TO postgres;
-- Index: fco_xno
-- DROP INDEX fco_xno;
CREATE UNIQUE INDEX fco_xno
ON fco
USING btree
(xno);
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Mark Maka
I am trying to update a field in one table with a
field from another table like:
update co set
firest_id=fco.firest_id,fire_dist=fco.fire_dist from
fco where co.xno=fco.xno
Table co has 384964 records
Table fco has 383654 records
The xno fields in both tables are indexed but they
don't seem to b
