pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: shane hill <shill@adobe.com>
To: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: design question: general db performance
Date: Tue, 25 Nov 2003 11:12:47 -0800
Message-ID: <200311251112.47473.josh@agliodbs.com> (raw)
In-Reply-To: <3FC3A2A7.6060804@adobe.com>
References: <3FC26E96.9090101@be-a-part.de>
	<3FC27071.9000001@bigfoot.com>
	<3FC3A2A7.6060804@adobe.com>

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 Testing System for Adobe Systems 
> and I am doing a DB redesign of the current postgres db:

Cool!    We're going to want to talk to you about a case study later, if you 
can get your boss to authorize it ....

> Our db is getting to be a respectable size (about 10GB right now) and is 
> growing slower and slower. 

Slower and slower?   Hmmm ... what's your VACUUM. ANALYZE & REINDEX schedule?  
What PG version?  What are your postgresql.conf settings?   Progressive 
performance loss may indicate a problem with one or more of these things ...

> then in my data I would just store 1,2,3 or 4 instead of the whole 
> permissions string.
> 
> it seems to me that we would save lots of space and over time not see 
> the same performance degradation.

Yes, this is a good idea.   Abstracting other repetitive data is good too.  
Also keep in mind that the permissions themselves can be represented as octal 
numbers instead of strings, which takes less space.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco




view thread (5+ messages)  latest in thread

Message-ID: <200311251112.47473.josh@agliodbs.com>
Permalink:  ../200311251112.47473.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200311251112.47473.josh@agliodbs.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: josh@agliodbs.com, shill@adobe.com
  Subject: Re: design question: general db performance
  In-Reply-To: <200311251112.47473.josh@agliodbs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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