Unexpected message in my logs appear too frequently

[INTELOWIEC]

Hi,

I'm getting strange message pretty often in my logs. How to get rid of it? How to increase parameter required?

2010-02-12 05:53:29 GMTLOG: checkpoints are occurring too frequently (28 seconds apart)
2010-02-12 05:53:29 GMTHINT: Consider increasing the configuration parameter "checkpoint_segments".

----------------

Also every time I start my PC up the same appears as a mistake:

2010-02-11 22:26:16 GMTFATAL: the database system is starting up

What's wrong and what does it mean?

----------------

Last enquiry is about:

http://forums.holdemmanager.com/manager-general/8423-want-stop-postgre-creating-those-large-log-files-heres-how.html

I noticed that it's already changed into "off" in the newest version of postgre sql which I use, but still plenty of logs appear, eg.:

2010-02-11 22:21:01 GMTLOG: database system is ready to accept connections
2010-02-11 22:21:01 GMTLOG: autovacuum launcher started
Server started and accepting connections, etc.

Any idea of how to get rid of them?

Thank you!

[Patvs]

How much RAM do you have?

-1 you can delete the content of the pg_log folder.

-2 Try the editing postgresql.conf tweak (see the top 10 performance tips thread in my signature)

[INTELOWIEC]

I have just 2 MB RAM. I deleted the content of the pg_log folder earlier. I've changed the postgresql.conf file and put the following values in there:

shared_buffers = 256MB
effective_cache_size = 512MB

Should I put 512/1024 or these are the optimal sizes?

[Patvs]

shared_buffers = 256MB
effective_cache_size = 512MB

is perfect.. if you have 2 GB RAM.