From: Donncha O Caoimh (donncha.ocaoimh at domain tradesignals.com)
Date: Fri 13 Sep 2002 - 12:12:11 IST
That sounds bad, does that affect the latest 7.x releases?
I had heard the need to vacuum the data on a regular basis was removed and
things worked better in these releases.
Donncha.
On Friday 13 September 2002 12:02, Thomas Bridge wrote:
> Be warned,
>
> Postgresql's indexing implimentation is very sucky to say the least. I
> have one table which can peak at 1.5 million entries, which are regularly
> updated. I need to drop and rebuild the index the UPDATEs are done on
> every 12 hours (where upon the INDEX goes from being 600 MB to 80 MB).
>
This archive was generated by hypermail 2.1.6 : Thu 06 Feb 2003 - 13:18:50 GMT