Campbell, Lance | 18 Jun 17:04 2007
Picon

Volunteer to build a configuration tool

I am a Java Software architect, DBA, and project manager for the University of Illinois, Department of Web Services.  We use PostgreSQL to serve about 2 million pages of dynamic content a month; everything from calendars, surveys, forms, discussion boards, RSS feeds, etc.  I am really impressed with this tool.

 

The only major problem area I have found where PostgreSQL is really lacking is in “what should my initial configuration settings be?”  I realize that there are many elements that can impact a DBA’s specific database settings but it would be nice to have a “configuration tool” that would get someone up and running better in the beginning. 

 

This is my idea:

 

A JavaScript HTML page that would have some basic questions at the top:

1) How much memory do you have?

2) How many connections will be made to the database?

3) What operating system do you use?

4) Etc…

 

Next the person would press a button, “generate”, found below the questions.  The JavaScript HTML page would then generate content for two Iframes at the bottom on the page.  One Iframe would contain the contents of the postgresql.conf file.  The postgresql.conf settings would be tailored more to the individuals needs than the standard default file.  The second Iframe would contain the default settings one should consider using with their operating system.

 

My web team would be very happy to develop this for the PostgreSQL project.   It would have saved us a lot of time by having a configuration tool in the beginning.  I am willing to make this a very high priority for my team.

 

Thanks,

 

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

 

Mario Gonzalez | 18 Jun 17:16 2007
Picon

Re: Volunteer to build a configuration tool

On 18/06/07, Campbell, Lance <lance <at> uiuc.edu> wrote:
>
> Next the person would press a button, "generate", found below the questions.
>  The JavaScript HTML page would then generate content for two Iframes at the
> bottom on the page.  One Iframe would contain the contents of the
> postgresql.conf file.  The postgresql.conf settings would be tailored more
> to the individuals needs than the standard default file.  The second Iframe
> would contain the default settings one should consider using with their
> operating system.
>

  I think it could be a great help to newbies. IMVHO a bash script in
dialog could be better than a javascript file. There are many
administrators with no graphics navigator or with no javascript.

>

--

-- 
http://www.advogato.org/person/mgonzalez/

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

David Tokmatchi | 18 Jun 17:55 2007
Picon

Postgres VS Oracle

Hello from Paris
I am DBA for Oracle and beginner on Postgres. For an company in France, I must make a comparative study, between Postgres and Oracle. Can you send any useful document which can help me.
Scalability ? Performance? Benchmark ? Availability ? Architecture ? Limitation : users, volumes ? Resouces needed ? Support ?
Regards

cordialement
david tokmatchi
+33 6 80 89 54 74
Jonah H. Harris | 18 Jun 18:10 2007
Picon

Re: [ADMIN] Postgres VS Oracle

On 6/18/07, David Tokmatchi <david.tokmatchi <at> gmail.com> wrote:
> Scalability ? Performance? Benchmark ? Availability ? Architecture ?
> Limitation : users, volumes ? Resouces needed ? Support ?

Aside from the Wikipedia database comparison, I'm not aware of any
direct PostgreSQL-to-Oracle comparison.

--

-- 
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 3rd Floor            | jharris <at> enterprisedb.com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Igor Neyman | 18 Jun 18:25 2007

Re: [ADMIN] Postgres VS Oracle

This document:
 
 
could answer some of your questions.
 
Igor

From: pgsql-admin-owner <at> postgresql.org [mailto:pgsql-admin-owner <at> postgresql.org] On Behalf Of David Tokmatchi
Sent: Monday, June 18, 2007 11:55 AM
To: pgsql-advocacy <at> postgresql.org; pgsql-admin <at> postgresql.org; pgsql-novice <at> postgresql.org; pgsql-general <at> postgresql.org; pgsql-performance <at> postgresql.org
Subject: [ADMIN] Postgres VS Oracle

Hello from Paris
I am DBA for Oracle and beginner on Postgres. For an company in France, I must make a comparative study, between Postgres and Oracle. Can you send any useful document which can help me.
Scalability ? Performance? Benchmark ? Availability ? Architecture ? Limitation : users, volumes ? Resouces needed ? Support ?
Regards

cordialement
david tokmatchi
+33 6 80 89 54 74
Andreas Kostyrka | 18 Jun 18:50 2007

Re: [PERFORM] [ADMIN] Postgres VS Oracle


It's even harder, as Oracle disallows publishing benchmark figures in
their license. As a cynic, I might ask, what Oracle is fearing?

Andreas

Jonah H. Harris wrote:
> On 6/18/07, David Tokmatchi <david.tokmatchi <at> gmail.com> wrote:
>> Scalability ? Performance? Benchmark ? Availability ? Architecture ?
>> Limitation : users, volumes ? Resouces needed ? Support ?
> 
> Aside from the Wikipedia database comparison, I'm not aware of any
> direct PostgreSQL-to-Oracle comparison.
> 
Jonah H. Harris | 18 Jun 19:02 2007
Picon

Re: [PERFORM] [ADMIN] Postgres VS Oracle

On 6/18/07, Andreas Kostyrka <andreas <at> kostyrka.org> wrote:
> As a cynic, I might ask, what Oracle is fearing?

As a realist, I might ask, how many times do we have to answer this
type of anti-commercial-database flamewar-starting question?

--

-- 
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 3rd Floor            | jharris <at> enterprisedb.com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Joshua D. Drake | 18 Jun 19:17 2007

Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

Jonah H. Harris wrote:
> On 6/18/07, Andreas Kostyrka <andreas <at> kostyrka.org> wrote:
>> As a cynic, I might ask, what Oracle is fearing?
> 
> As a realist, I might ask, how many times do we have to answer this
> type of anti-commercial-database flamewar-starting question?

Depends? How many times are you going to antagonize the people that ask?

1. It has *nothing* to do with anti-commercial. It is anti-proprietary 
which is perfectly legitimate.

2. Oracle, Microsoft, and IBM have a "lot" to fear in the sense of a 
database like PostgreSQL. We can compete in 90-95% of cases where people 
would traditionally purchase a proprietary system for many, many 
thousands (if not hundreds of thousands) of dollars.

Sincerely,

Joshua D. Drake

--

-- 

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

PFC | 18 Jun 19:27 2007

Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle


> 2. Oracle, Microsoft, and IBM have a "lot" to fear in the sense of a  
> database like PostgreSQL. We can compete in 90-95% of cases where people  
> would traditionally purchase a proprietary system for many, many  
> thousands (if not hundreds of thousands) of dollars.

	Oracle also fears benchmarks made by people who don't know how to tune  
Oracle properly...

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Joshua D. Drake | 18 Jun 19:32 2007

Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

PFC wrote:
> 
>> 2. Oracle, Microsoft, and IBM have a "lot" to fear in the sense of a 
>> database like PostgreSQL. We can compete in 90-95% of cases where 
>> people would traditionally purchase a proprietary system for many, 
>> many thousands (if not hundreds of thousands) of dollars.
> 
>     Oracle also fears benchmarks made by people who don't know how to 
> tune Oracle properly...

Yes that is one argument that is made (and a valid one) but it is 
assuredly not the only one that can be made, that would be legitimate.

Joshua D. Drake

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
> 
>                http://www.postgresql.org/about/donate
> 

--

-- 

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


Gmane