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 11:23:29 |
Message-ID: | 617185BB0AA2D111872400105AD899AD1490D6@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 |
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Long | 2000-03-06 15:27:16 | RE: [SQL] database with 1000000 rows is very slow |
Previous Message | Karel Zak - Zakkr | 2000-03-06 10:20:00 | Re: [SQL] dayname() doubt |