Re: [PERFORM] design question: general db performance

2003-11-25 Thread Richard Huxton
On Tuesday 25 November 2003 18:42, shane hill wrote: > > Our db is getting to be a respectable size (about 10GB right now) and is > growing slower and slower. I have been charged with making it faster and > with a smaller footprint while retaining all of the current > functionality. here is one of

Re: [PERFORM] design question: general db performance

2003-11-25 Thread Jeff
On Tue, 25 Nov 2003 10:42:47 -0800 shane hill <[EMAIL PROTECTED]> wrote: > Our db is getting to be a respectable size (about 10GB right now) and > is growing slower and slower. I have been charged with making it > faster and with a smaller footprint while retaining all of the current > functionali

Re: [PERFORM] design question: general db performance

2003-11-25 Thread Josh Berkus
Shane, > Disclaimer: I am relatively new to RDBMSs, so please do not laugh at me > too loudly, you can laugh, just not too loudly and please do not point. :) Hey, we all started somewhere. Nobody was born knowing databases. Except maybe Neil Conway. > I am working on an Automated Installer

Re: [PERFORM] design question: general db performance

2003-11-25 Thread Jord Tanner
[small chuckle] By George, I think he's got it! You are on the right track. Have a look at this link on database normalization for more info: http://databases.about.com/library/weekly/aa080501a.htm On Tue, 2003-11-25 at 10:42, shane hill wrote: > Hi folks, > > Disclaimer: I am relatively n

[PERFORM] design question: general db performance

2003-11-25 Thread shane hill
Hi folks, Disclaimer: I am relatively new to RDBMSs, so please do not laugh at me too loudly, you can laugh, just not too loudly and please do not point. :) I am working on an Automated Installer Testing System for Adobe Systems and I am doing a DB redesign of the current postgres db: 1. We