Postgres Pro
Downloads
Home   >   mailing lists

Re: Multiple indexes, huge table - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Multiple indexes, huge table
Date
Msg-id 4382660.bXDxzT0j2R@skynet.simkin.ca
Whole thread Raw
In response to Re: Multiple indexes, huge table  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: Multiple indexes, huge table
List pgsql-general
Tree view 
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 ...

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL server embedded in NAS firmware?
Next
From: Tom Lane
Date:
Subject: Re: Multiple indexes, huge table