MAX_CONNECTIONS ??

We have a very large new customer that is considering using Postgres for
their RDBMS. The size
of the database will be in the several terrabytes range, making
unloading/reloading a time consuming
and disk-eating process. This customer will be running on a Windows
platform.

I've been looking at the upgrade_in_place docs in pgfoundry, but it
seems it is in the "trying to be
revived" stage.

Does anyone have newer information about the move towards upgrades-in-place?

Thanks,
Naomi

--
------------------------------------------------------------------------
Naomi Walker Chief Information Officer
Eldorado Computing, Inc nwalker@eldocomp.com
---An EDS Company 602-604-3100
------------------------------------------------------------------------
Hard things are put in our way, not to stop us, but to call out our
courage and strength. -- Anonymous
------------------------------------------------------------------------

-- CONFIDENTIALITY NOTICE --

Information transmitted by this e-mail is proprietary to MphasiS and/or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this e-mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at mailmaster@mphasis.com and delete this mail from your records.

Quick tip: don't start a new thread by replying to a previous message,
it can mean your message gets missed.

Naomi Walker wrote:

We have a very large new customer that is considering using Postgres for
their RDBMS. The size
of the database will be in the several terrabytes range, making
unloading/reloading a time consuming
and disk-eating process. This customer will be running on a Windows
platform.

For such a large database, I would give serious thought to not running
on Windows. PostgreSQL has a much longer history on the unix side of the
fence, and a larger *nix community of users and developers. If you're
worried about support, I'm sure Red Hat, Novell or Sun would be more
than happy with the money you'd have spent on Windows licencing. There
are also several well established PostgreSQL consulting companies who
can support both the database and operating-system.

I've been looking at the upgrade_in_place docs in pgfoundry, but it
seems it is in the "trying to be
revived" stage.

Does anyone have newer information about the move towards upgrades-in-place?

Work is ongoing for 8.4 (to allow you to upgrade in-place to 8.5). You
have pretty much full access to all development discussions by checking
the pgsql-hackers mailing list (there's also a developers side to the
website). Search for "WIP" on the hackers list. Bear in mind that
there's no guarantee that *any* feature not yet complete will make it
into 8.4 (although there are a lot of big users who really want this
feature, so it's a strong candidate).

HTH

--
Richard Huxton
Archonet Ltd

paulo matadr wrote:

I need help to alter max_connections em my database, this parameter
stay in defalt MAX_CONNECTIONS=100
I want to change for MAX_CONNECTIONS=300. about parameters below,
need to change anything?

1 -sysctl.conf

kernel.shmmax = 68719476736
kernel.shmall = 4294967296

Does your shmmax have one digit too many? 68GB?

# - Memory -

2-Postgresql.conf
shared_buffers = 2048MB
temp_buffers = 12MB
work_mem = 12MB
maintenance_work_mem = 128MB
max_fsm_pages = 4000000
max_fsm_relations = 5000

Should be OK, depending on your work-load.

One question - what do you plan on doing with 300 active connections?
Unless you've got more than 100 processors in this machine you might
want to consider connection-pooling.

--
Richard Huxton
Archonet Ltd

Only kernel.shmmax have

importance in this case?
about kernel.shmmax it has configured not by me.

________________________________
De: Richard Huxton <dev@archonet.com>
Para: paulo matadr <saddoness@yahoo.com.br>
Cc: GENERAL <pgsql-general@postgresql.org>; admin <pgsql-admin@postgresql.org>
Enviadas: Quarta-feira, 12 de Novembro de 2008 14:41:06
Assunto: Re: [ADMIN] [GENERAL] MAX_CONNECTIONS ??

paulo matadr wrote:

I need help to alter max_connections em my database, this parameter
stay in defalt MAX_CONNECTIONS=100
I want to change for MAX_CONNECTIONS=300. about parameters below,
need to change anything?

1 -sysctl.conf

kernel.shmmax = 68719476736
kernel.shmall = 4294967296

Does your shmmax have one digit too many? 68GB?

# - Memory -

2-Postgresql.conf
shared_buffers = 2048MB
temp_buffers = 12MB
work_mem = 12MB
maintenance_work_mem = 128MB
max_fsm_pages = 4000000
max_fsm_relations = 5000

Should be OK, depending on your work-load.

One question - what do you plan on doing with 300 active connections?
Unless you've got more than 100 processors in this machine you might
want to consider connection-pooling.

--
Richard Huxton
Archonet Ltd

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com.
http://br.new.mail.yahoo.com/addresses