I have a huge table, containing a text column and having text indexes,
with 22 million rows. The table is partitioned into 4 tables. Is there
anything like /*+ parallel(table,8) */ hint in Oracle RDBMS that I can do
to execute the query in parallel? I am aware of the fact that I can do
that with PgpoolII and SQLGrid, but I need 2 or more machines, in order
to achieve parallelism. Is there any way I can do it on a single SMP
machine?



--
http://mgogala.byethost5.com

Mladen Gogala wrote:
No. In PostgreSQL, only one backend will work for one client.

Yours,
Laurenz Albe