Обсуждение: Newbie question PostgreSQL / Postgres Plus / Tuning

--- On Wed, 1/21/09, Nico Callewaert <callewaert.nico@telenet.be> wrote:

> Hi,
>
>
> Is there a difference between the standaard PostgreSQL en
> PostgresPlus from EnterpriseDB. We're planning to
> replace Firebird with PostgreSQL.  We don't know what
> version to download: the one from Postgresql.org or
> enterprisedb.com
>
> I heard many rumours that PostgreSQL out of the box is not
> configured optimally (please don't give me sermon,
> it's just what I heard J).  We would use the database in
> a enterprise ERP system, with lots of Inserts/updates/reads.
>  Approximately max. of 50 users.  Speed is very important
> (of course).  DB server should use all memory available for
> PG.  Are there any things I can check to optimize ?
>
> With Firebird, we had to do Backup/restore to keep the size
> of the DB in place.  How about vacuuming PG ?  Is that done
> automatically ?
>

I don't know anything about PostgresPlus but I don't think PostgreSQL should be that hard to configure for your needs.
Startwith the documentation, especially chapter 17 - OS Environment: 

http://www.postgresql.org/docs/8.3/interactive/runtime.html

and  chapter 18 - Server Configuration:

http://www.postgresql.org/docs/8.3/interactive/runtime-config.html

Sincerely,
Bruce Hyatt

Hi Bruce,

I downloaded the PostgreSQL instead of Postgres Plus.
Thanks a lot for the reply and the links to the sections of the
documentation ! Very helpfull.

Best regards, Nico


----- Original Message -----
From: "Bruce Hyatt" <brucejhyatt@yahoo.com>
To: <pgsql-novice@postgresql.org>; "Nico Callewaert"
<callewaert.nico@telenet.be>
Sent: Thursday, January 22, 2009 3:19 PM
Subject: Re: [NOVICE] Newbie question PostgreSQL / Postgres Plus / Tuning


> --- On Wed, 1/21/09, Nico Callewaert <callewaert.nico@telenet.be> wrote:
>
>> Hi,
>>
>>
>> Is there a difference between the standaard PostgreSQL en
>> PostgresPlus from EnterpriseDB. We're planning to
>> replace Firebird with PostgreSQL.  We don't know what
>> version to download: the one from Postgresql.org or
>> enterprisedb.com
>>
>> I heard many rumours that PostgreSQL out of the box is not
>> configured optimally (please don't give me sermon,
>> it's just what I heard J).  We would use the database in
>> a enterprise ERP system, with lots of Inserts/updates/reads.
>>  Approximately max. of 50 users.  Speed is very important
>> (of course).  DB server should use all memory available for
>> PG.  Are there any things I can check to optimize ?
>>
>> With Firebird, we had to do Backup/restore to keep the size
>> of the DB in place.  How about vacuuming PG ?  Is that done
>> automatically ?
>>
>
> I don't know anything about PostgresPlus but I don't think PostgreSQL
> should be that hard to configure for your needs. Start with the
> documentation, especially chapter 17 - OS Environment:
>
> http://www.postgresql.org/docs/8.3/interactive/runtime.html
>
> and  chapter 18 - Server Configuration:
>
> http://www.postgresql.org/docs/8.3/interactive/runtime-config.html
>
> Sincerely,
> Bruce Hyatt
>
>
>
>
>

Nico,
     You may also benefit from researching and testing PostgreSQL
indexes on your database.  Here is the documentation on PostgreSQL 8.3
indexes: http://www.postgresql.org/docs/8.3/interactive/indexes.html
(don't forget to run the ANALYZE command after adding an index to make
sure it is used in database queries).

Where I work, we have conducted our own internal PostgreSQL testing
with database indexes.  On tables with hundreds of thousands or
millions of rows, indexes on foreign key columns is cutting our query
times by over 90%, every time.

-Mike Swierczek

On Thu, Jan 22, 2009 at 9:22 AM, Nico Callewaert
<callewaert.nico@telenet.be> wrote:
> Hi Bruce,
>
> I downloaded the PostgreSQL instead of Postgres Plus.
> Thanks a lot for the reply and the links to the sections of the
> documentation ! Very helpfull.
>
> Best regards, Nico
>
>
> ----- Original Message ----- From: "Bruce Hyatt" <brucejhyatt@yahoo.com>
> To: <pgsql-novice@postgresql.org>; "Nico Callewaert"
> <callewaert.nico@telenet.be>
> Sent: Thursday, January 22, 2009 3:19 PM
> Subject: Re: [NOVICE] Newbie question PostgreSQL / Postgres Plus / Tuning
>
>
>> --- On Wed, 1/21/09, Nico Callewaert <callewaert.nico@telenet.be> wrote:
>>
>>> Hi,
>>>
>>>
>>> Is there a difference between the standaard PostgreSQL en
>>> PostgresPlus from EnterpriseDB. We're planning to
>>> replace Firebird with PostgreSQL.  We don't know what
>>> version to download: the one from Postgresql.org or
>>> enterprisedb.com
>>>
>>> I heard many rumours that PostgreSQL out of the box is not
>>> configured optimally (please don't give me sermon,
>>> it's just what I heard J).  We would use the database in
>>> a enterprise ERP system, with lots of Inserts/updates/reads.
>>>  Approximately max. of 50 users.  Speed is very important
>>> (of course).  DB server should use all memory available for
>>> PG.  Are there any things I can check to optimize ?
>>>
>>> With Firebird, we had to do Backup/restore to keep the size
>>> of the DB in place.  How about vacuuming PG ?  Is that done
>>> automatically ?
>>>
>>
>> I don't know anything about PostgresPlus but I don't think PostgreSQL
>> should be that hard to configure for your needs. Start with the
>> documentation, especially chapter 17 - OS Environment:
>>
>> http://www.postgresql.org/docs/8.3/interactive/runtime.html
>>
>> and  chapter 18 - Server Configuration:
>>
>> http://www.postgresql.org/docs/8.3/interactive/runtime-config.html
>>
>> Sincerely,
>> Bruce Hyatt
>>
>>
>>
>>
>>
>
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>