Hi All!
First, thanks for answers!
Richard Huxton wrote:
On Thursday 07 August 2003 09:24, Yaroslav Mazurak wrote:
IIRC there is a limit on filesystem cache on freeBSD. 300MB by default.
If that is the case, you might have to raise it to make
effective_cache_size really effective..
Hello people.
I'm installing Postgresql under linux for better
performance and i want to know how is the best configuration.
My server is a dual pentium3 1ghz/1gb ram/36gb
scsi. running only postgresql. My question is:
1. What is the best linux distribuition for better
performance?
2. Does
Hi All!
Shridhar Daithankar wrote:
On 7 Aug 2003 at 10:05, Yaroslav Mazurak wrote:
It needs to reflect how much cache the system is using - try the free
command to see figures.
I'm not found free utility on FreeBSD 4.7. :(
rant
Grr.. I don't like freeBSD for it's top
Oh, and I forgot to mention: it's highly compressed (bzip2 -9) and is
109M.
Scott
On Tue, 2003-08-05 at 11:01, Scott Cain wrote:
Joe,
Good idea, since I may not get around to profiling it this week. I
created a dump of the data set I was working with. It is available at
Agreed.. WAL cannot recover something when WAL no longer exists due to a
filesystem corruption.
It is true that ext2 isn't good because the file system may not recover,
but BSD UFS isn't a journalled file system, but does guarantee file
system recovery after a crash --- it is especially
On Fri, Aug 08, 2003 at 03:34:44PM -0400, Bruce Momjian wrote:
It is true that ext2 isn't good because the file system may not recover,
but BSD UFS isn't a journalled file system, but does guarantee file
system recovery after a crash --- it is especially good using soft
updates.
Sorry. I
On 8 Aug 2003 at 12:28, mixo wrote:
I have just installed redhat linux 9 which ships with Pg
7.3.2. Pg has to be setup so that data inserts (blobs) should
be able to handle at least 8M at a time. The machine has
two P III 933MHz CPU's, 1.128G RAM (512M*2 + 128M), and
a 36 Gig hd with 1 Gig