[Pgpool-general] Pgpool's data and index storage limitation

[Tatsuo Ishii]

pgpool-II does not use for storing data nor indexes.
So you don't need to worry about your memory size limit. The major
limitation of pgpool-II with parallel mode is, complex joins tends to
slow. See docs for modetail how to optimise for the case.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Hi everyone,
> 
> I gotta a question about the pgpool-II limitation in regards to
> storing data and indexes.
> 
> I want to use it in the parallel mode (I tried with mysqlcluster
> before, and it failed for what I need).
> The thing is that in the case of mysql cluster the indexes must be
> stored in RAM, so you can grow your database until your indexes fill
> all your RAM memory.
> In my  case, for instance, I had 4GB DB size, but I can only insert up to 3GB.
> 
> In the case of pgpool-II, I would like to know if it is possible to
> store data and indexes in *disk* in the parallel mode?
> If so, what are the limitations?
> 
> Thanks in advance for your answers,
> 
> Giovane
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general