Received: from netvisorpdc.intranet.netvisor.hu (root@www.netvisor.hu [212.3.95.17]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA17131 for ; Mon, 6 Mar 2000 04:56:05 -0500 (EST) (envelope-from zoltan.sebestyen@netvisor.hu) From: zoltan.sebestyen@netvisor.hu Received: by netvisorpdc.intranet.netvisor.hu with Internet Mail Service (5.5.2650.21) id ; Mon, 6 Mar 2000 11:10:30 +0100 Message-ID: <617185BB0AA2D111872400105AD899AD1490D2@netvisorpdc.intranet.netvisor.hu> To: pgsql-sql@postgreSQL.org Subject: index file's growing big Date: Mon, 6 Mar 2000 11:10:30 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: multipart/mixed; boundary="----_=_NextPart_000_01BF8754.339AAA40" This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01BF8754.339AAA40 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Hi, I wrote a web+commandline based package with PostgreSQL database = backend. My problem is that as time goes by the index file grows to a huge size [80Mb]. If I dump and then reload it the database in question I'll get = the very same data with a quite small index file. So, there's no = inconsistency or corrupt database, but it's still annoying that I must handle = manually. What I think is tha the command-line app I wrote for populating the database uses some wrong strategy, I mean there's no erroneous SQL = phares, just may be it uses wrong tactics that's why it grows the index file to = a quite big size. Any ideas? > Zoltan Sebestyen > NETvisor Kft > 1111 Muegyetem rkpt.9. Fsz.8. > Budapest, Hungary. > Fax: (+36-1) 463-4396 > Tel: (+36-1) 463-4392, 463-4393 >=20 > "Programming is an art, not a science, > and not all programmers are Picassos." >=20 >=20 <>=20 ------_=_NextPart_000_01BF8754.339AAA40 Content-Type: application/octet-stream; name="=?iso-8859-2?Q?Sebesty=E9n_Zolt=E1n=2Evcf?=" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="=?iso-8859-2?Q?Sebesty=E9n_Zolt=E1n=2Evcf?=" BEGIN:VCARD VERSION:2.1 N:Sebesty=E9n;Zolt=E1n FN:Sebesty=E9n Zolt=E1n ORG:NETvisor Ltd. TITLE:rendszer programoz=F3 NOTE:rendszer programoz=F3 TEL;WORK;VOICE:(+36) 1-463-4392 ADR;WORK:;;M=FCegyetem rkp. 9. R.ep Fsz. 8.;Budapest;;H-1111;Hungary LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:M=3DFCegyetem rkp. 9. R.ep Fsz. = 8.=3D0D=3D0ABudapest H-1111=3D0D=3D0AHungary EMAIL;PREF;INTERNET:zoltan.sebestyen@netvisor.hu REV:20000301T164555Z END:VCARD ------_=_NextPart_000_01BF8754.339AAA40--