Re: Disk usage

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Jay O'Connor" <joconnor(at)cybermesa(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Disk usage
Date: 2003-04-16 09:35:57
Message-ID: 200304161035.57896.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 16 Apr 2003 2:41 am, Jay O'Connor wrote:
> I'm looking for any information I can find about how disk usage increases
> as database volume increases. Basically I'm converting a web site form a
> homegrown file-based storage solution to a postgresql solution and I need
> information on disk usage patterns for estimaing hardware needs.

In addition to Shridhar's comments, take a look at Ch 11 of the Administrators
guide for some details on monitoring disk usage of tables etc.

Check the archives too, there's been discussion of calculating row sizes
several times (I thought there was something on techdocs about it, but can't
find it now).

--
Richard Huxton

In response to

  • Disk usage at 2003-04-16 01:41:26 from Jay O'Connor

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-04-16 11:23:36 Re: high availability
Previous Message Shridhar Daithankar 2003-04-16 07:55:14 Re: Are we losing momentum?