pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: andrew@pillette.com
To: John Arbash Meinel <john@arbash-meinel.com>
Cc: SpaceBallOne <space_ball_one@hotmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: poor performance of db?
Date: Mon, 24 Jan 2005 22:18:11 -0800
Message-ID: <200501250618.j0P6IBN19000@pillette.com> (raw)

This is a multi-part message in MIME format.

--bound1106633891
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

I'm also an autodidact on DB design, although it's well more than a year now. If you are planning to clean up the design, I strongly suggest getting a visual tool. Google for something like "database design tool". Some are extremely expensive (e.g. ERwin, which I think is renamed having been bought out). There's a very cheap shareware one that I won't mention by name because it crashed my machine consistently. Right now I'm using "Case Studio", which has some very eccentric UI (no one enforced consistency of UI across modules, which is rather ironic in a design tool) but capable and user-extensible. ERwin's manual also had the best explanation of denormalization I've read, short and to the point.

The ability to make schema revisions quickly lets me concentrate on *better-written queries* and *improved table definition* without having to overcome inertia.

--bound1106633891--



view thread (8+ messages)  latest in thread

Message-ID: <200501250618.j0P6IBN19000@pillette.com>
Permalink:  ../200501250618.j0P6IBN19000@pillette.com/
Also on:    postgresql.org/message-id/200501250618.j0P6IBN19000@pillette.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: andrew@pillette.com, john@arbash-meinel.com, space_ball_one@hotmail.com
  Subject: Re: poor performance of db?
  In-Reply-To: <200501250618.j0P6IBN19000@pillette.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