Re: Performance Anomalies in 7.4.5 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Performance Anomalies in 7.4.5
Date
Msg-id 2815.1098981088@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance Anomalies in 7.4.5  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Performance Anomalies in 7.4.5  (Rod Taylor <pg@rbt.ca>)
List pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
>> One drawback to this is that it would require an additional lseek per table
>> while planning, but that doesn't seem like a huge penalty.

> Hmmm ... would the additional lseek take longer for larger tables, or would it
> be a fixed cost?

Should be pretty much a fixed cost: one kernel call per table.

            regards, tom lane

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Performance Anomalies in 7.4.5
Next
From: Rod Taylor
Date:
Subject: Re: Performance Anomalies in 7.4.5