Обсуждение: 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
theindividual or entity to which it is addressed, and may contain information that is privileged, confidential or
exemptfrom disclosure under applicable law. If you are not the intended recipient or it appears that this e-mail has
beenforwarded to you without proper authority, you are notified that any use or dissemination of this information in
anymanner is strictly prohibited. In such cases, please notify us immediately at mailmaster@mphasis.com and delete this
mailfrom 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