Skip site navigation (1) Skip section navigation (2)


From: Werdin Jens <jens(dot)werdin(at)siemens(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Performance
Date: 2004-11-24 13:53:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

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
Gbyte Ram.
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
smaller tables.

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 WhiteDate: 2004-11-24 14:13:35
Subject: Nesting Stored Procedure Calls
Previous:From: Doug McNaughtDate: 2004-11-24 13:39:14
Subject: Re: Moving/Using Postgres Binaries on multiple machines

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group