Maximum columns for optimum performance (fwd) - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Maximum columns for optimum performance (fwd)
Date
Msg-id Pine.LNX.4.21.0002170026540.1328-100000@localhost.localdomain
Whole thread Raw
Responses Re: [HACKERS] Maximum columns for optimum performance (fwd)
List pgsql-hackers
Can anybody comment on this?

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

---------- Forwarded message ----------
Date: Wed, 16 Feb 2000 11:16:48 -0600
From: Jude Weaver <exec@shreve.net>
To: Peter Eisentraut <peter_e@gmx.net>
Subject: Maximum columns for optimum performance

One of our tables have 476 columns and only 12 records or rows in it. We are
coding in Java. When we compile and run against this table it is super slow.

Is there a maximum number of columns past which performance suffers? Would we
be better off building several smaller tables with fewer columns instead of
one big table? Does the number of columns in a table affect speed?






pgsql-hackers by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: [HACKERS] Date/time types: big changeu
Next
From: Bruce Momjian
Date:
Subject: psql password prompt