pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedEffect of too many columns
2+ messages / 2 participants
[nested] [flat]
* Effect of too many columns
@ 2004-04-12 11:54 Rajesh Kumar Mallah <mallah@trade-india.com>
0 siblings, 1 reply; 2+ messages in thread
From: Rajesh Kumar Mallah @ 2004-04-12 11:54 UTC (permalink / raw)
To: pgsql-performance
Greetings,
Is there any performance penalty of having too many columns in
a table in terms of read and write speeds.
To order to keep operational queries simple (avoid joins) we plan to
add columns in the main customer dimension table.
Adding more columns also means increase in concurrency in the table
as more and more applications will access the same table.
Any ideas if its better to split the table application wise or is it ok?
Regds
mallah.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Effect of too many columns
@ 2004-04-12 12:17 Bruno Wolff III <bruno@wolff.to>
parent: Rajesh Kumar Mallah <mallah@trade-india.com>
0 siblings, 0 replies; 2+ messages in thread
From: Bruno Wolff III @ 2004-04-12 12:17 UTC (permalink / raw)
To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: pgsql-performance
On Mon, Apr 12, 2004 at 17:24:17 +0530,
Rajesh Kumar Mallah <mallah@trade-india.com> wrote:
>
> Greetings,
>
> Is there any performance penalty of having too many columns in
> a table in terms of read and write speeds.
>
> To order to keep operational queries simple (avoid joins) we plan to
> add columns in the main customer dimension table.
>
> Adding more columns also means increase in concurrency in the table
> as more and more applications will access the same table.
>
> Any ideas if its better to split the table application wise or is it ok?
This is normally a bad idea. If you properly implement constraints in
what is effectively a materialized view, you might end up with a slower
system, depending on your mix of queries. (Generally updating will take
more resources.) So you probably want to test your new design under a
simulated normal load to see if it actually speeds things up in your
case before making the change.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-04-12 12:17 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-12 11:54 Effect of too many columns Rajesh Kumar Mallah <mallah@trade-india.com>
2004-04-12 12:17 ` Bruno Wolff III <bruno@wolff.to>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox