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 my ideas.  Please tell me if I am crazy:

Your idea of using an integer makes sense - that's how it is stored on unix 
anyway.

Are you familiar with VACUUM/VACUUM FULL/REINDEX and when you should use them? 
If not, that's a good place to start. Try a VACUUM FULL on frequently updated 
tables and see if that reduces your disk size.

You'll probably want to check the performance notes too: 
http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php



-- 
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to