index file's growing big
От
zoltan.sebestyen@netvisor.hu
Тема
index file's growing big
Дата
Msg-id
617185BB0AA2D111872400105AD899AD1490D2@netvisorpdc.intranet.netvisor.hu
Список
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." > > <>
В списке pgsql-sql по дате отправления