Thread: ENC: PostgreSQL: Uses cases and features

ENC: PostgreSQL: Uses cases and features

From
Renato Cramer
Date:
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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: ENC: PostgreSQL: Uses cases and features

From
Josh Berkus
Date:
Renato,

I have forwarded your e-mail again -- to Diogo, who leads our rather large
Brazillian community of PostgreSQL users.   He should be able to answer all
of your questions.

--
Josh Berkus
Aglio Database Solutions
San Francisco