>>>>> "BL" == Bo Lorentsen <bl@netgroup.dk> writes:
BL> Hi ..
BL> He likes to know about others using Postgres and simple replication (we
BL> need it in at 24/7 system), to know how postgres performs, and how
BL> stable it is regarding its data and the backup feature etc.
I use it in 24/7/365 system which is heavily written to and read
from. The drawbacks I have are:
1) upgrade to major versions require dump/restore which is a
significant amount of downtime for a large DB.
2) the need to run vacuum on tables to keep them from bloating too
much. on my system which is very busy, sometimes running vacuum
pushes the disk beyond its limits and slows the whole system to a
crawl.
3) Index bloat is apparently a bigger problem than I thought.
Yesterday I took the hit of reindexing all my tables. On a 2.7Gb
database (those of you who notice my numbers keep changing... this
is the correct value -- I read wrongly before) I just shaved 900Mb
of 'dead' index pages. Unfortunately, my largest table of 92M rows
takes about 43 minutes *per index* to reindex.
I think 2 is probably amplified by 3. We'll see how the system holds
up this week after the indexes have been optimized.
BL> Are there some detailed busisness cases, that he/we can read to feel
BL> more assured that PG is a good choice ?
If you want commercial support, it is out there. There are at least
two companies offering it.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
