Hi, Paul
Josh helped my company with this issue -- PG doesn't use shared memory like
Oracle, it depends more on the OS buffers. Making shared mem
too large a fraction is disasterous and seriously impact performance. (though I
find myself having to justify this to Oracle trained
DBA's) :)
What I
Yes, I agree it's unnecessary -- but you'll never have to worry about the
postmaster not starting due to lack of allocatable
memory -- when I was testing setups, I got sick of rebooting everytime I had to
make a change to /etc/system, that I threw up my
hands and said, "let it take all it wants".
Hi Tom, I've made changes to postgresql.conf as recommended on Josh's site
and this seems to be working well so far.
Given your comments on shared memory, it would appear that the following
entry in /etc/system is unnecessary:
set shmsys:shminfo_shmmax=0x
Ironically, we both have this id
... Trying again again with right email address -- list server rejected
previous :)
Hi, Paul
Josh helped my company with this issue -- PG doesn't use shared memory like
Oracle, it depends more on the OS buffers. Making shared mem
too large a fraction is disasterous and seriously impact performan
Hi Josh, there are 8 internal disks - all are [EMAIL PROTECTED],000 RPM, fibre
connected.
The O/S is on 2 mirrored disks, the Postgres cluster is on the /data1
filesystem that is striped across the other 6 disks.
The shared_buffers value is a semi-educated guess based on having made 4GB
shared me
Paul,
> I would like to know what /etc/system and postgresql_conf values are
> recommended to deliver as much system resource as possible to Postgres. We
> use this Sun box solely for single user Postgres data warehousing
> workloads.
What's your disk system?
> shared_buffers = 50
This is h
Hi all, we have an Sun E3500 running Solaris 9. It's got 6x336MHz CPU and
10GB RAM.
I would like to know what /etc/system and postgresql_conf values are
recommended to deliver as much system resource as possible to Postgres. We
use this Sun box solely for single user Postgres data warehousing
work
I'm looking for suggestions on tuning Solaris 9 for a SunFire 890 (Ultra
IV chips) connected to an Hitachi 9500V running PostgreSQL 7.4.
Database is approx 160GB in size with a churn of around 4GB per day (2
GB updated, 2GB inserted, very little removed). It's a mixture of OLTP
and reporting.
5%
