ENC: PostgreSQL: Uses cases and features

Hi All,

The questions below was done to Mr. Bruce Momjian, what request me to post
it in this list.
Please, I will want of answers.

Thanks in advance.
Renato Cramer.

----------------------------------
Renato Cramer wrote:
> Dear Mr. Bruce Momjian,
>
> I will want of informations about PostgreSQL for explain it to
directorship
> of the software development company in which I work.
>
> Our products are systems to accountancy's offices, we have three thousand
> customers dispersed by all Brazilian territory. Today, our applications
run
> only in installations of the customers, using PowerBuilder and Sybase SQL
> Anywhere. In future, must are used Java in model ASP (Aplication Service
> Provider) in a datacenter's structure. Maybe the current model also will
are
> mantened, isn't decided.
>
> I already analysis MaxDB and MySQL, both aren't meet databases as our
needs.
> We will work with PostgreSQL or any commercial database.
>
> I examine the PostgreSQL features and, based in ours priorities, will want
> of clarifies about:
> - High available (24x7): is possible an uninterrupted operating?
> - What is the degree of performance falling in online backup?
> - The performance with large databases is good?
> - Exists forecast of stored procedures in java?
> - Is possible read the system tables through of SQL statements
> (users authorizeds)?
> - Subqueries are possibles in select list, from and where clause?
> - "Encrypted database connections with SSL or SSH" means what isn't
> need have OpenSSL installed?
> - Already exists a "production version" with automatic vacuum?
>
> Thank you very much for your attention and for any help what you can give
> us.
>
> p.s.: I'm, particularly, sympathizer of the PostgreSQL project. I ready
your
> interview in SQL Magazine (Brazilian) and identify me with several things.
> Excuse me for my bad English.
>
> Best Regards,
>
> Renato Cramer
> Analista de Sistemas
> Depto. de Desenvolvimento
> Dom?nio Sistemas Ltda.
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073