Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 14E6264FD2E for ; Thu, 6 Nov 2008 06:51:47 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 99413-08 for ; Thu, 6 Nov 2008 06:51:46 -0400 (AST) X-Greylist: delayed 00:06:39.292508 by SQLgrey-1.7.6 Received: from web8405.mail.in.yahoo.com (web8405.mail.in.yahoo.com [202.43.219.153]) by mail.postgresql.org (Postfix) with SMTP id 7181C64FCED for ; Thu, 6 Nov 2008 06:51:45 -0400 (AST) Received: (qmail 82734 invoked by uid 60001); 6 Nov 2008 10:45:02 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=fhm8d0+Ch8+Y+oPB4Xk++vQ3XYz08aldn7JYwGuG3C1h+p/CqaoAOpZBq7ksNwguIdyXeHBIHQ6noCkvvRRgSNB12Gs+Oar4nQigOg9JCpyVOTMLuYEGoia1zh4YsQJo3DNMNx/vUZPfhqffq8ogYaeTSj93wgshCQna5Rv4ACI=; X-YMail-OSG: d70tS.AVM1lyeGhvRaOgRGXpoX0MsU00ZqsAIYT0DdEwUw0wG.SohpMHj0KlVH.MzGj0DykFUEynhsu3sa67THjixbmsN1226X6W8Tyb4JZsFcTUCQY.g6bA6scCzgFVZgn2F5I7tmrJJlAvoQs9xlFS.eD9wpQ.3xtDWGznWu5LAw-- Received: from [122.161.123.218] by web8405.mail.in.yahoo.com via HTTP; Thu, 06 Nov 2008 16:15:02 IST X-Mailer: YahooMailWebService/0.7.260.1 Date: Thu, 6 Nov 2008 16:15:02 +0530 (IST) From: brahma tiwari Reply-To: prakashr2n5@yahoo.com Subject: server space increasing very fast but transaction are very low To: tgl@sss.pgh.pa.us, Kevin.Grittner@wicourts.gov, amitjain.bit@gmail.com Cc: pgsql-performance@postgresql.org, heikki@enterprisedb.com, pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1308905425-1225968302=:82667" Message-ID: <551154.82667.qm@web8405.mail.in.yahoo.com> X-Archive-Number: 200811/39 X-Sequence-Number: 30693 --0-1308905425-1225968302=:82667 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi all =C2=A0 My database server db01=C2=A0is on linux environment and size of base folde= r increasing very fast unexpectedly(creating renamed files of 1=C2=A0GB in = base folder like 1667234568.10) details as below =C2=A0 path of the table space/base file =C2=A0 /opt/appl/pgsql82/data/base/453447624/ =C2=A0 [postgres@wcatlsatdb01 453447624]$ ls -ltrh 1662209326* -rw-------=C2=A0 1 postgres postgres 1.0G Aug 27 06:32 1662209326 -rw-------=C2=A0 1 postgres postgres 1.0G Aug 30 02:16 1662209326.1 -rw-------=C2=A0 1 postgres postgres 1.0G Aug 30 17:39 1662209326.2 -rw-------=C2=A0 1 postgres postgres 1.0G Sep=C2=A0 1 05:42 1662209326.3 -rw-------=C2=A0 1 postgres postgres 1.0G Sep=C2=A0 2 09:28 1662209326.4 -rw-------=C2=A0 1 postgres postgres 1.0G Sep=C2=A0 4 10:08 1662209326.5 -rw-------=C2=A0 1 postgres postgres 1.0G Sep=C2=A0 6 02:17 1662209326.6 -rw-------=C2=A0 1 postgres postgres 1.0G Sep=C2=A0 8 03:43 1662209326.7 -rw-------=C2=A0 1 postgres postgres 1.0G Sep=C2=A0 8 08:16 1662209326.8 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 10 10:53 1662209326.9 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 11 04:59 1662209326.10 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 13 05:22 1662209326.11 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 15 01:43 1662209326.12 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 16 08:32 1662209326.13 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 17 14:30 1662209326.14 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 19 07:24 1662209326.15 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 21 02:55 1662209326.16 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 22 09:59 1662209326.17 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 23 06:22 1662209326.18 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 25 08:42 1662209326.19 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 26 04:13 1662209326.20 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 29 03:58 1662209326.21 -rw-------=C2=A0 1 postgres postgres 1.0G Sep 29 08:06 1662209326.22 -rw-------=C2=A0 1 postgres postgres 1.0G Oct=C2=A0 2 02:23 1662209326.23 -rw-------=C2=A0 1 postgres postgres 1.0G Oct=C2=A0 2 06:45 1662209326.24 -rw-------=C2=A0 1 postgres postgres 1.0G Oct=C2=A0 5 03:17 1662209326.25 -rw-------=C2=A0 1 postgres postgres 1.0G Oct=C2=A0 5 14:39 1662209326.26 -rw-------=C2=A0 1 postgres postgres 1.0G Oct=C2=A0 7 08:46 1662209326.27 -rw-------=C2=A0 1 postgres postgres 1.0G Oct=C2=A0 8 18:24 1662209326.28 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 10 08:24 1662209326.29 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 12 03:24 1662209326.30 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 14 02:31 1662209326.31 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 16 02:36 1662209326.32 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 17 02:37 1662209326.33 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 19 02:37 1662209326.34 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 20 04:45 1662209326.35 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 22 02:37 1662209326.36 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 23 02:37 1662209326.37 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 25 02:38 1662209326.38 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 26 02:40 1662209326.39 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 28 02:40 1662209326.40 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 29 02:39 1662209326.41 -rw-------=C2=A0 1 postgres postgres 1.0G Oct 31 05:11 1662209326.42 -rw-------=C2=A0 1 postgres postgres 1.0G Nov=C2=A0 1 02:43 1662209326.43 -rw-------=C2=A0 1 postgres postgres 1.0G Nov=C2=A0 3 03:31 1662209326.44 -rw-------=C2=A0 1 postgres postgres 1.0G Nov=C2=A0 4 03:18 1662209326.45 -rw-------=C2=A0 1 postgres postgres 1.0G Nov=C2=A0 6 02:37 1662209326.46 -rw-------=C2=A0 1 postgres postgres 1.0G Nov=C2=A0 6 02:38 1662209326.47 -rw-------=C2=A0 1 postgres postgres 249M Nov=C2=A0 6 02:39 1662209326.48 [postgres@wcatlsatdb01 453447624]$ what is significance of these files and how can i avoid it.can i delete the= se renamed files from base folder or any thing else. Please=C2=A0 help =C2=A0 with regards! =C2=A0 Brahma Prakash Tiwari DBA=20 iBoss Tech Solutions=20 Sec-63 Noida ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~= ~~~~~~~~~~~~~~~ The contents of this email, including the attachments, are PRIVILEGED AND C= ONFIDENTIAL to the intended recipient at the email address to which it has = been addressed.=20 =C2=A0=0A=0A=0A Get rid of Add-Ons in your email ID. Get yourname@rock= etmail.com. Sign up now! http://in.promos.yahoo.com/address --0-1308905425-1225968302=:82667 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

Hi all
 
My database server db01 is on linux environment and size of base = folder increasing very fast unexpectedly(creating renamed files of 1 G= B in base folder like 1667234568.10)
details as below
 
path of the table space/base file
 
/opt/appl/pgsql82/data/base/453447624/
 
[postgres@wcatlsatdb01 453447624]$ ls -ltrh 1662209326*
-rw-------&= nbsp; 1 postgres postgres 1.0G Aug 27 06:32 1662209326
-rw-------  = 1 postgres postgres 1.0G Aug 30 02:16 1662209326.1
-rw-------  1 po= stgres postgres 1.0G Aug 30 17:39 1662209326.2
-rw-------  1 postgr= es postgres 1.0G Sep  1 05:42 1662209326.3
-rw-------  1 postg= res postgres 1.0G Sep  2 09:28 1662209326.4
-rw-------  1 post= gres postgres 1.0G Sep  4 10:08 1662209326.5
-rw-------  1 pos= tgres postgres 1.0G Sep  6 02:17 1662209326.6
-rw-------  1 po= stgres postgres 1.0G Sep  8 03:43 1662209326.7
-rw-------  1 p= ostgres postgres 1.0G Sep  8 08:16 1662209326.8
-rw-------  1 = postgres postgres 1.0G Sep 10 10:53 1662209326.9
-rw-------  1 post= gres postgres 1.0G Sep 11 04:59 1662209326.10
-rw-------  1 postgre= s postgres 1.0G Sep 13 05:22 1662209326.11
-rw-------  1 postgres postgres 1.0G Sep 15 01:43 1662209326.12
-rw-------  1 po= stgres postgres 1.0G Sep 16 08:32 1662209326.13
-rw-------  1 postg= res postgres 1.0G Sep 17 14:30 1662209326.14
-rw-------  1 postgres= postgres 1.0G Sep 19 07:24 1662209326.15
-rw-------  1 postgres po= stgres 1.0G Sep 21 02:55 1662209326.16
-rw-------  1 postgres postg= res 1.0G Sep 22 09:59 1662209326.17
-rw-------  1 postgres postgres= 1.0G Sep 23 06:22 1662209326.18
-rw-------  1 postgres postgres 1.= 0G Sep 25 08:42 1662209326.19
-rw-------  1 postgres postgres 1.0G = Sep 26 04:13 1662209326.20
-rw-------  1 postgres postgres 1.0G Sep= 29 03:58 1662209326.21
-rw-------  1 postgres postgres 1.0G Sep 29= 08:06 1662209326.22
-rw-------  1 postgres postgres 1.0G Oct = 2 02:23 1662209326.23
-rw-------  1 postgres postgres 1.0G Oct&nbs= p; 2 06:45 1662209326.24
-rw-------  1 postgres postgres 1.0G Oct  5 03:17 1662209326.25
-rw-------  1 postgres postgr= es 1.0G Oct  5 14:39 1662209326.26
-rw-------  1 postgres post= gres 1.0G Oct  7 08:46 1662209326.27
-rw-------  1 postgres po= stgres 1.0G Oct  8 18:24 1662209326.28
-rw-------  1 postgres = postgres 1.0G Oct 10 08:24 1662209326.29
-rw-------  1 postgres pos= tgres 1.0G Oct 12 03:24 1662209326.30
-rw-------  1 postgres postgr= es 1.0G Oct 14 02:31 1662209326.31
-rw-------  1 postgres postgres = 1.0G Oct 16 02:36 1662209326.32
-rw-------  1 postgres postgres 1.0= G Oct 17 02:37 1662209326.33
-rw-------  1 postgres postgres 1.0G O= ct 19 02:37 1662209326.34
-rw-------  1 postgres postgres 1.0G Oct = 20 04:45 1662209326.35
-rw-------  1 postgres postgres 1.0G Oct 22 = 02:37 1662209326.36
-rw-------  1 postgres postgres 1.0G Oct 23 02:= 37 1662209326.37
-rw-------  1 postgres postgres 1.0G Oct 25 02:38 1662209326.38
-rw-------  1 postgres postgres 1.0G Oct 26 02= :40 1662209326.39
-rw-------  1 postgres postgres 1.0G Oct 28 02:40= 1662209326.40
-rw-------  1 postgres postgres 1.0G Oct 29 02:39 16= 62209326.41
-rw-------  1 postgres postgres 1.0G Oct 31 05:11 16622= 09326.42
-rw-------  1 postgres postgres 1.0G Nov  1 02:43 166= 2209326.43
-rw-------  1 postgres postgres 1.0G Nov  3 03:31 1= 662209326.44
-rw-------  1 postgres postgres 1.0G Nov  4 03:18= 1662209326.45
-rw-------  1 postgres postgres 1.0G Nov  6 02:= 37 1662209326.46
-rw-------  1 postgres postgres 1.0G Nov  6 0= 2:38 1662209326.47
-rw-------  1 postgres postgres 249M Nov  6= 02:39 1662209326.48
[postgres@wcatlsatdb01 453447624]$
what is significance of these files and how can i avoid it.can i delet= e these renamed files from base folder or any thing else. Please  help=
 
with regards!

 
Brahma Prak= ash Tiwari
DBA
iBo= ss Tech Solutions
Sec-63 Noida=
~~~~~~~~~~~~~~~~~~~= ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
T= he contents of this email, including the attachments, are PRIVILEGED AND CO= NFIDENTIAL to the intended recipient at the email address to which it has b= een addressed.
 

= =0A
Get rid of Add-Ons in your email ID. Ge= t yourname@rocketmail.com. Sign up now! --0-1308905425-1225968302=:82667--