Re: Performance Anomalies in 7.4.5

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance Anomalies in 7.4.5
Date: 2004-10-28 16:31:28
Message-ID: 2815.1098981088@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rod Taylor 2004-10-28 17:20:56 Re: Performance Anomalies in 7.4.5
Previous Message Josh Berkus 2004-10-28 16:07:00 Re: Performance Anomalies in 7.4.5