Hello Richard,
> > I decreased the import time from >40 minutes to 32 minutes with changing
> > the parameters to:
> >
> > shared_buffers = 45 # kept same
> > temp_buffers = 10# kept same
> >
> > work_mem = 32768 # now 32mb , before: 102400 = 100mb
> > maintenanc
Gellert, Andre wrote:
Hello Richard,
We have such a testsystem now, 4 x AMD Opteron (double core techn.)
885 2.6ghz , running with 32 GB Ram and fast 10.000rpm SAS discs,
How many disks? What RAID?
4 Disks, RAID1.
Is your disk I/O saturating? Try vmstat/iostat (or whatever the Solaris
equ
Hello Richard,
> > We have such a testsystem now, 4 x AMD Opteron (double core techn.)
> > 885 2.6ghz , running with 32 GB Ram and fast 10.000rpm SAS discs,
>
> How many disks? What RAID?
4 Disks, RAID1.
> Is your disk I/O saturating? Try vmstat/iostat (or whatever the Solaris
> equivalent i
Gellert, Andre wrote:
Hello all,
I need some hints how to setup Postgresql on a brand new testsystem.
Due to heavy load on the current database servers, my boss decided to
test a big server as a replacement for 5 other servers. ;-) The
system is used in a extranet environment - over 50 percen
Hello all,
I need some hints how to setup Postgresql on a brand new testsystem.
Due to heavy load on the current database servers, my boss decided to test a
big server as a replacement for 5 other servers. ;-) The system is used in a
extranet environment - over 50 percent of the load is prod
