When I tried to use the 7.3.2 dump, and use 7.4.1 import, I had several
issues- mostly with data. I actually had to dump with the 7.4.1 dumpall
command, upgrade the DB to 7.4.1, and then everything imported correctly.
Hope this helps,
Corey
Try looking at your kernel- make sure that you don't have any debugging
turned on, and comment out all unnecessary devices. Read the man page on
tuning.
What is slow? Are any metrics at 100%, i.e. IO or CPU?
If you need more help, please provide additional information.
Corey
A really good email from Cheryl Bender near a month ago:
Michael;
What version of FreeBSD? What version of PostGres?
On my server, running FreeBSD 5.1 and pg 7.3, the values are
kern.ipc.shmmax: 33554432
kern.ipc.shmmin: 1
kern.ipc.shmmni: 192
kern.ipc.shmseg: 128
kern.ipc.shmall: 8192
kern.ip
I have all of these on my server, but postgres does not fail when using
semaphores. What happens when you 'gmake check'?
Thanks,
Corey
[EMAIL PROTECTED]
How is your query written, and are you dealing with any referential
interegrity?
Corey
"Priya Nair"
