Обсуждение: PostgreSQL on e10k

Hi

my company planed to use postgresql on a sun enterprise 10000.
has enyone hints and tricks for me how to setup and configure
the database server?

thx
-Chris

On 7 Jan 2003 at 11:43, Christian Töpp wrote:
> my company planed to use postgresql on a sun enterprise 10000.
> has enyone hints and tricks for me how to setup and configure
> the database server?

Well, that largely depends upon the database size. And when database tuning is
not sufficient, the last advice is to upgrade the machine.

Now that you have a big enough machine, you can start tuning it right away.

One thing I can think of is connection pooling. AFAIK, solaris is not known for
a fast fork. So if your database requires frequent connection, make sure that
database connection pooling is used. That should eliminate the fork timeing
problem..

 HTH

Bye
 Shridhar

--
Kennedy's Market Theorem:    Given enough inside information and unlimited credit,
you've got to go broke.

Hi Chris,

Christian Töpp wrote:
> Hi
>
> my company planed to use postgresql on a sun enterprise 10000.
> has enyone hints and tricks for me how to setup and configure
> the database server?

What's the configuration of the E10k going to be?

+ How many CPU's ( and which Mhz+cache rating), how much memory, how
much disk?
+ How are you going to logically partition up the E10K, or is going to
be just One Big Box?
+ Which version of Solaris?

Only asking because this is the kind of Sun gear I used to do stuff on.

:-)

Regards and best wishes,

Justin Clift


> thx
> -Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi