ut 8.1
has problems, unless there is something that 8.1 needs tweaked that 8.0
doesn't. In that case, I just need to know what that is and I can tweak
it.
Dual Xeon 2.6GB HTT PowerEdge, 4GB RAM, RAID 5
FreeBSD 5.4 RELEASE, custom-compiled kernel
CFLAGS=-O3 -funroll-loops -pi
ice and CPU affinity of my database process (I use schedtool in my
CK kernel to run it at SCHED_FIFO, nice -15, and CPU affinity confined
to the second processor in my dual Xeon eServer) has got me to the
point that the perpetually high memory usage doesn't affect my
application server.
H
-
#deadlock_timeout = 1000# in milliseconds
#max_locks_per_transaction = 64 # min 10, ~200*max_connections bytes each
#-------
# VERSION/PLATFORM COMPATIBILITY
#---
memory is being used by caching and not reclaimed :-)
If it wasn't for the app server going down, I probably wouldn't care.
--
Jon Brisbin
Webmaster
NPC International, Inc.
---(end of broadcast)---
TIP 1: if posting/reading through Us
e or two of downtime in a restart
is often too much.
Any help you can give in this would be extrememly helpful as I'm very
far from an expert on Linux filesystems and postgres tuning.
Thanks!
--
Jon Brisbin
Webmaster
NPC International, Inc.
---(end of broadcast)-