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 528CCD8243 for ; Fri, 21 Oct 2005 19:41:49 -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 13247-06 for ; Fri, 21 Oct 2005 22:41:42 +0000 (GMT) Received: from secure.internetverket.se (unknown [62.65.105.10]) by svr1.postgresql.org (Postfix) with ESMTP id 72923DA9FB for ; Fri, 21 Oct 2005 19:41:42 -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 j9LMeuxI014434 for ; Sat, 22 Oct 2005 00:40:56 +0200 Message-ID: <00aa01c5d690$597a5030$03997483@rogercud6b5ksq> From: "Roger Strandberg / Hamsta" To: Subject: Database size, and table size Date: Sat, 22 Oct 2005 00:39:51 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00A7_01C5D6A1.1CCEC9C0" X-Priority: 1 X-MSMail-Priority: High 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.245 required=5 tests=[AWL=-0.193, FORGED_RCVD_HELO=0.05, HTML_60_70=0.027, HTML_MESSAGE=0.001, X_MSMAIL_PRIORITY_HIGH=0.267, X_PRIORITY_HIGH=0.093] X-Spam-Level: X-Archive-Number: 200510/246 X-Sequence-Number: 19318 This is a multi-part message in MIME format. ------=_NextPart_000_00A7_01C5D6A1.1CCEC9C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi. I wondering about file size of a table. The table has 43000 pages and in documentation is say's its around 8kb. It makes it supose to be around 336Mb on disk. The table is simple just: org_no varchar (12) Name varachar(225) But when i create a tablespace on a mfs disk and just loads the data on = to the new table (with no index) The file on the disk increase to more the 500MB and a few seconds later = the machine crach. If i input only 1Milion it's okay but 4 milion is not okay. What does i not understand about tablespaces and the space a 8.0.4 = postgresql takes on a frebsd5.4 ????? /Roger ------=_NextPart_000_00A7_01C5D6A1.1CCEC9C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi.
 
I wondering about file size of a=20 table.
 
The table has 43000 pages and in = documentation is=20 say's its around 8kb.
It makes it supose to be around 336Mb = on=20 disk.
The table is simple just:
org_no varchar (12)
Name varachar(225)
 
But when i create a tablespace on = a mfs disk=20 and just loads the data on to the new table (with no index)
The file on the disk increase = to more the=20 500MB and a few seconds later the machine crach.
If i input only 1Milion it's okay but 4 = milion is=20 not okay.
 
What does i not understand about = tablespaces=20 and the space a 8.0.4 postgresql takes on a frebsd5.4 ?????
 
/Roger  
------=_NextPart_000_00A7_01C5D6A1.1CCEC9C0--