Re: Maximum size of database

[Matthias.Pitzl@xxxxxx]

Title: Nachricht

What disk subsystem do you have? Single disks? Raid? Raid with battery buffered write cache?

Last one can improve your performance massively.

 

-- Matthias

-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of roopa perumalraja
Sent: Wednesday, October 18, 2006 8:10 AM
To: pgsql-general@xxxxxxxxxxxxxx
Cc: Michael Fuhr
Subject: Re: [GENERAL] Maximum size of database

Thanks for your reply.

 

I have answered your questions below.

 

1 & 2) System: Microsoft Windows XP Professional
          Version 2002

          Computer: Intel Pentium CPU 3.40GHz, 960MB of RAM

 

3) shared_buffers = 20000
    autovaccum = on

 

4) Yes, I am vacuuming & analyzing the database once every day.

 

5) No concurrent activities, means I run one command at a time.

 

6) Nothing else running on the box other than Postgres.

 

I hope these answers will try to solve my problem. Thanks again.

 

Roopa