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

Help how to tune-up my Database

From: "Michael Ryan S(dot) Puncia" <mpuncia(at)census(dot)gov(dot)ph>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Help how to tune-up my Database
Date: 2004-05-07 11:07:23
Message-ID: 200405071054.i47Asbh9012448@mail.census.gov.ph (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,

            I am a newbie here and just starting to use postgresql. My
problems is how to tune up my server because it its too slow.

We just ported from DBF to postgresql.

 

This is my PC specs: P4, 512Ram, Linux 9

 

Because I am working in a statistical organization we have a very large data
volume

These are my data:

 

Table 1 with 60 million data but only with 10 fields

Table 2 with 30 million data with 15 fields

Table 3 with 30 million data with 10 fields

 

I will only use this server for querying ... I already read and apply those
articles found in the archives section but still the performance is not
good.

I am planning to add another 512 RAM .Another question is how to calculate
shared_buffer size ..

 

Thanks a lot and hoping for your kind answers ..

 

Michael Puncia

Philippines

 

 

 

 

                                   

 

Responses

pgsql-performance by date

Next:From: scott.marloweDate: 2004-05-07 16:00:03
Subject: Re: Help how to tune-up my Database
Previous:From: Gavin SherryDate: 2004-05-06 22:29:11
Subject: Re: [PERFORM] [OFF-TOPIC] - Known maximum size of

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