Re: Multiple indexes, huge table

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Multiple indexes, huge table
Date: 2012-09-07 00:12:29
Message-ID: 4382660.bXDxzT0j2R@skynet.simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday, September 06, 2012 05:06:27 PM Jeff Janes wrote:
> For updating 20 million out of 500 million rows, wouldn't a full table
> scan generally be preferable to an index scan anyway?
>

Not one table scan for each row updated ...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-09-07 00:22:59 Re: Multiple indexes, huge table
Previous Message Adrian Klaver 2012-09-07 00:06:29 Re: PostgreSQL server embedded in NAS firmware?