X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 39D90D7003 for ; Sat, 22 Oct 2005 15:03:22 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44679-08 for ; Sat, 22 Oct 2005 18:03:20 +0000 (GMT) Received: from secure.internetverket.se (unknown [62.65.105.10]) by svr1.postgresql.org (Postfix) with ESMTP id 92F0BD6E34 for ; Sat, 22 Oct 2005 15:03:20 -0300 (ADT) Received: from rogercud6b5ksq (host-83-166-7-170.serva.net [83.166.7.170]) (authenticated bits=0) by secure.internetverket.se (8.12.10/8.12.10) with ESMTP id j9MI2RxI008351; Sat, 22 Oct 2005 20:02:28 +0200 Message-ID: <00e201c5d732$964d4470$03997483@rogercud6b5ksq> From: "Roger Strandberg / Hamsta" To: "hubert depesz lubaczewski" Cc: References: <00aa01c5d690$597a5030$03997483@rogercud6b5ksq> <9e4684ce0510212305x1492b246g4ed8f02ef775586f@mail.gmail.com> Subject: Re: Database size, and table size Date: Sat, 22 Oct 2005 20:01:11 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00DF_01C5D743.596F8A70" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.156 required=5 tests=[AWL=0.078, FORGED_RCVD_HELO=0.05, HTML_60_70=0.027, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200510/248 X-Sequence-Number: 19320 This is a multi-part message in MIME format. ------=_NextPart_000_00DF_01C5D743.596F8A70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Okay i did so, result: html_slave=3D# select pg_size_pretty(relation_size('quick_search')); pg_size_pretty ---------------- 490 MB (1 row) html_slave=3D# select pg_size_pretty(relation_size('html_company')); pg_size_pretty ---------------- 1567 MB (1 row) html_slave=3D# 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. = .....=20 I need to mail freebsd then. /R ----- Original Message -----=20 From: hubert depesz lubaczewski=20 To: Roger Strandberg / Hamsta=20 Cc: pgsql-admin@postgresql.org=20 Sent: Saturday, October 22, 2005 8:05 AM Subject: Re: [ADMIN] Database size, and table size On 10/22/05, Roger Strandberg / Hamsta = wrote: I wondering about file size of a table. dont wonder :) install dbsize module from postgresql contrib, and = check. depesz ------=_NextPart_000_00DF_01C5D743.596F8A70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Okay i did so, result:
html_slave=3D# select=20 pg_size_pretty(relation_size('quick_search'));
 pg_size_pretty----------------
 490=20 MB
(1 row)
 
html_slave=3D# select=20 pg_size_pretty(relation_size('html_company'));
 pg_size_pretty----------------
 1567=20 MB
(1 row)
 
html_slave=3D# select=20 pg_size_pretty(database_size('html_slave'));
 pg_size_pretty
-= ---------------
 4120=20 MB
(1 row)
Okay the quic_search_table is aroun = 490, but then i=20 need to ask why does the machine reboot when i only make use of 510MB of = the=20 2.8G mfs disk. .....
 
I need to mail freebsd = then.
 
/R
 
----- Original Message -----
From:=20 hubert = depesz=20 lubaczewski
Sent: Saturday, October 22, = 2005 8:05=20 AM
Subject: Re: [ADMIN] Database = size, and=20 table size

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

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

depesz
------=_NextPart_000_00DF_01C5D743.596F8A70--