schema/db design wrt performance

From: CaptainX0r <captainx0r(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: schema/db design wrt performance
Date: 2003-01-16 13:51:40
Message-ID: 20030116135140.32097.qmail@web21106.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

All,

I just noted in another thread that use of foreign keys in postgres
significantly hinders performance. I'm wondering what other aspects we should
take into consideration in the design of our database. We're coming from
Sybase and trying to design a more encompassing, modular, generic database that
won't take a serious performance hit under postgres.

Thanks,

-X

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Fernando Papa 2003-01-16 14:07:25 Re: schema/db design wrt performance
Previous Message CaptainX0r 2003-01-16 13:45:02 Re: Sun vs. Mac - gprof output