Performance Issues - Mailing list pgsql-general

From John Menke
Subject Performance Issues
Date
Msg-id NEBBJPBNELAMDGEPHPNJIEEICNAA.john@eagleinfosystems.com
Whole thread Raw
List pgsql-general
I am in the design phase of a new database that contains one very long thin table.  Are there any peformance issues with index lookups to a table like this if table becomes extremly long?  Lets say hundreds of thousands to millions of records...  Remember, the table only has one column. 
 
Another question.  If the size of data in this record were to vary greatly, would that have an impact on performance? 
 
 
thanks for any replys....
 
 


    


 

pgsql-general by date:

Previous
From: Mirko Zeibig
Date:
Subject: variable name RESULT in PLPGSQL does not work (PG7.1)
Next
From: Bruno Wolff III
Date:
Subject: access checking using sql in 7.1beta3