From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: stored procs |
Date: | 2011-09-30 15:41:27 |
Message-ID: | 4E85E327.6060801@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 09/30/11 2:09 AM, J.V. wrote:
> Some tables have millions of rows,
well, something like UPDATE tablename SET
id=generate_series(1,numberofrows); will update every row to a
sequential value. However, I have no idea how you would match the
foreign key references in other tables to these new sequence values.
anything that updates a field on a million rows will be causing every
row to be updated... postgres never updates anything in place, it will
be copying the whole row to a new one (this is how it implements MVCC,
and its fundamental to the architecture, there's nothing you can do to
override this behavior).
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
From | Date | Subject | |
---|---|---|---|
Next Message | pasman pasmański | 2011-09-30 16:17:19 | Re: how to improve this similarity query? |
Previous Message | Jason Long | 2011-09-30 14:55:23 | Re: Any was to prevent a join if no columns are selected from a view? |