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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

            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

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

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









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-2017 The PostgreSQL Global Development Group