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