index file's growing big

From: zoltan(dot)sebestyen(at)netvisor(dot)hu
To: pgsql-sql(at)postgreSQL(dot)org
Subject: index file's growing big
Date: 2000-03-06 10:10:30
Message-ID: 617185BB0AA2D111872400105AD899AD1490D2@netvisorpdc.intranet.netvisor.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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
>
> "Programming is an art, not a science,
> and not all programmers are Picassos."
>
>
<<Sebestyén Zoltán.vcf>>

Attachment Content-Type Size
=?iso-8859-2?Q?Sebesty=E9n_Zolt=E1n=2Evcf?= application/octet-stream 415 bytes

Browse pgsql-sql by date

  From Date Subject
Next Message zoltan.sebestyen 2000-03-06 10:11:33
Previous Message Peter Eisentraut 2000-03-06 07:22:05 Re: [SQL] database with 1000000 rows is very slow