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
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 |