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

From Josh Berkus
Subject Re: Performance Anomalies in 7.4.5
Date
Msg-id 200410280907.00445.josh@agliodbs.com
Whole thread Raw
In response to Re: Performance Anomalies in 7.4.5  ("Alban Medici (NetCentrex)" <amedici@fr.netcentrex.net>)
Responses Re: Performance Anomalies in 7.4.5  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom,

> 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?

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: "Anjan Dave"
Date:
Subject: Re: Summary: can't handle large number of INSERT/UPDATEs
Next
From: Tom Lane
Date:
Subject: Re: Performance Anomalies in 7.4.5