Re: What's faster? - Mailing list pgsql-performance

From Tom Lane
Subject Re: What's faster?
Date
Msg-id 8602.1072486147@sss.pgh.pa.us
Whole thread Raw
In response to What's faster?  ("Keith Bottner" <kbottner@comcast.net>)
List pgsql-performance
"Keith Bottner" <kbottner@comcast.net> writes:
> I have a database where the vast majority of information that is related to
> a customer never changes. However, there is a single field (i.e. balance)
> that changes potentially tens to hundreds of times per day per customer
> (customers ranging in the 1000s to 10000s). This information is not indexed.
> Because Postgres requires VACUUM ANALYZE more frequently on updated tables,
> should I break this single field out into its own table,

Very likely a good idea, if the primary key that you'd need to add to
identify the balance is narrow.  Hard to say exactly how large the
benefit would be, but I'd think the update costs would be reduced
considerably.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Keith Bottner"
Date:
Subject: What's faster?
Next
From: Mike Nolan
Date:
Subject: Re: What's faster?