From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Robert(dot)Farrugia(at)go(dot)com(dot)mt |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Requirements for a database server |
Date: | 2001-07-18 15:48:59 |
Message-ID: | 5142.995471339@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Robert(dot)Farrugia(at)go(dot)com(dot)mt writes:
> I have been using postgres for the last year now. The database has grown
> from a mere few MBs to over 100GB data and expected to top up 300GB by the
> end of the year. Lately performance of queries, inserts, updates has
> continued to grow worse as the dataset has grown larger, even though most
> queries have indexes on them, while vacuuming the database has become a
> nightmare.
Have you tried dropping and rebuilding the indexes?
Currently, PG doesn't reclaim dead space in indexes very effectively,
so the indexes on a frequently-updated table tend to grow without bound.
(I may or may not be able to fix this for 7.2 --- it's next on my
to-look-at list, but no promises.) In the meantime, an occasional
rebuild may help restore performance.
BTW, the vacuuming issue is pretty well fixed for 7.2 ...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-07-18 16:17:05 | Re: Compile directive -8k limit |
Previous Message | DAVID LIZANO MARCO | 2001-07-18 15:23:14 | Re: Compile directive -8k limit |