Re: can postgresql handle these large tables - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: can postgresql handle these large tables
Date
Msg-id 4123C7FF.7040907@bigfoot.com
Whole thread Raw
In response to can postgresql handle these large tables  (Dino Vliet <dino_vliet@yahoo.com>)
List pgsql-general
Dino Vliet wrote:
> Hi folks,
> I'm busy with analyzing some data and therefore will
> have to store 2 big tables containing 50 million obs &
> 25 million obs. Selecting some interesting obs can
> decrease these tables with maybe a factor 10 but
> eventually I will have to combine them using a join.
> These tables contain almost 20 colums and after
> selecting the appropriate ones I will have maybe 10
> colums.
>
> Off course I will have to make use of indexes and try
> to optimize the settings in postgresql.conf file like:
>
> geqo=true
> geqo_treshold=11
> geqo_effort= 1
> geqo_generations=5

These value will affect only if you join more then "geqo_threshold"
tables, it doesn't depend on the number of column and/or
rows number.


Regards
Gaetano Mendola

pgsql-general by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Web application: Programming language/Framework: Summary
Next
From: Alvaro Herrera
Date:
Subject: Re: scripting & psql issues