pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Roger Strandberg / Hamsta <roger.strandberg@hamsta.se>
To: hubert depesz lubaczewski <depesz@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Database size, and table size
Date: Sat, 22 Oct 2005 20:01:11 +0200
Message-ID: <00e201c5d732$964d4470$03997483@rogercud6b5ksq> (raw)
References: <00aa01c5d690$597a5030$03997483@rogercud6b5ksq>
	<9e4684ce0510212305x1492b246g4ed8f02ef775586f@mail.gmail.com>

Okay i did so, result:
html_slave=# select pg_size_pretty(relation_size('quick_search'));
 pg_size_pretty
----------------
 490 MB
(1 row)

html_slave=# select pg_size_pretty(relation_size('html_company'));
 pg_size_pretty
----------------
 1567 MB
(1 row)

html_slave=# select pg_size_pretty(database_size('html_slave'));
 pg_size_pretty
----------------
 4120 MB
(1 row)

Okay the quic_search_table is aroun 490, but then i need to ask why does the machine reboot when i only make use of 510MB of the 2.8G mfs disk. ..... 

I need to mail freebsd then.

/R

  ----- Original Message ----- 
  From: hubert depesz lubaczewski 
  To: Roger Strandberg / Hamsta 
  Cc: pgsql-admin@postgresql.org 
  Sent: Saturday, October 22, 2005 8:05 AM
  Subject: Re: [ADMIN] Database size, and table size


  On 10/22/05, Roger Strandberg / Hamsta <roger.strandberg@hamsta.se> wrote:
    I wondering about file size of a table.

  dont wonder :) install dbsize module from postgresql contrib, and check.

  depesz

view thread (3+ messages)

Message-ID: <00e201c5d732$964d4470$03997483@rogercud6b5ksq>
Permalink:  ../00e201c5d732$964d4470$03997483@rogercud6b5ksq/
Also on:    postgresql.org/message-id/00e201c5d732$964d4470$03997483@rogercud6b5ksq

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: roger.strandberg@hamsta.se, depesz@gmail.com
  Subject: Re: Database size, and table size
  In-Reply-To: <00e201c5d732$964d4470$03997483@rogercud6b5ksq>
  References: <00aa01c5d690$597a5030$03997483@rogercud6b5ksq> <9e4684ce0510212305x1492b246g4ed8f02ef775586f@mail.gmail.com> <00e201c5d732$964d4470$03997483@rogercud6b5ksq>

* 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