Ich have a big performance problem.
I'm running postgres 7.4.2 on Suse Linux 9.0 on a dual Xeon 3.0 GHz with 3
In postgres.conf I'm using the defaults. Filesystem is ext3 with writeback
I have 3 tables with ca 10 million entries with a gist index on GIS data and
5 tables with 10 million entries with an index on (timestamp,double,double).
There are 10 tables with 1 million entries and index on int. and some
With 1 Gbyte Ram all went fine. Than I added a new table and it startet to
swap. I added 2 Gbyte but the Problem is still there.
The kswapd and kjournald are running nearly permanently.
The first time I do a query it takes very long. But the second time it goes
a lot faster.
Is postgres only using a certain amount of Ram for the indexes? But why my
Ram is full then?
Am I too short of Ram? Is the filesystem too slow?
Can anyone help me?
pgsql-general by date
|Next:||From: Larry White||Date: 2004-11-24 14:13:35|
|Subject: Nesting Stored Procedure Calls|
|Previous:||From: Doug McNaught||Date: 2004-11-24 13:39:14|
|Subject: Re: Moving/Using Postgres Binaries on multiple machines|