Re: Can PostGreSQL slow down a Windows PC much?

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Greg" <greg(at)officium(dot)co(dot)za>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can PostGreSQL slow down a Windows PC much?
Date: 2006-06-07 14:05:17
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCEA0F9EA@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Our software will be using PostGreSQL as a database. Now I
> was wondering, if the database is installed on lets say an
> entry level Celeron, with 256MB of Ram, will it slow down the
> PC at all?
>
> I'm not taking any queries into account here, just generally,
> does installing the database slow down ones PC a bit?
> Unfortunately I don't have access to such an entry-level PC,
> so I can't test it.

As long as there are no queries running, the effect will be almost
nothing. If you're sure you don't need it, you can turn off autovacuum
which will bring it even closer to zero. (But as long as your db is
reasonably small, having autovacuum check now and then shouldn't be
noticeable either).

When you start putting a query load on it, it will show of course,
depending on what queries you have.

Depending on what you have set for shared memory, some RAM will be used
for it, but it will likely get swapped out if there is no activity.

//Magnus

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-06-07 14:27:50 Re: autovacuum, xid wraparound, pg_database column values
Previous Message Michael Fuhr 2006-06-07 13:59:41 Re: composite data type question