index file's growing big - Mailing list pgsql-sql

From zoltan.sebestyen@netvisor.hu
Subject index file's growing big
Date
Msg-id 617185BB0AA2D111872400105AD899AD1490D2@netvisorpdc.intranet.netvisor.hu
Whole thread Raw
List 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

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [SQL] database with 1000000 rows is very slow
Next
From: zoltan.sebestyen@netvisor.hu
Date:
Subject: