Re: OpenMP in PostgreSQL-8.4.0

Sounds more like a school project than a proper performance question.

On 11/28/09, Reydan Cankur <reydan.cankur@gmail.com> wrote:
> Hi,
>
> I am trying to run postgresql functions with threads by using OpenMP.
> I tried to parallelize slot_deform_tuple function(src/backend/access/
> common/heaptuple.c) and added below lines to the code.
>
> #pragma omp parallel
> {
>     #pragma omp sections
>     {
>         #pragma omp section
>         values[attnum] = fetchatt(thisatt, tp + off);
>
>         #pragma omp section
>         off = att_addlength_pointer(off, thisatt->attlen, tp + off);
>     }
> }
>
> During ./configure I saw the information message for  heaptuple.c as
> below:
> "OpenMP defined section was parallelized."
>
> Below is the configure that I have run:
> ./configure CC="/path/to/icc -openmp" CFLAGS="-O2" --prefix=/path/to/
> pgsql --bindir=/path/to/pgsql/bin --datadir=/path/to/pgsql/share --
> sysconfdir=/path/to/pgsql/etc --libdir=/path/to/pgsql/lib --
> includedir=/path/to/pgsql/include --mandir=/path/to/pgsql/man --with-
> pgport=65432 --with-readline --without-zlib
>
> After configure I ran gmake and gmake install and I saw "PostgreSQL
> installation complete."
>
> When I begin to configure for initdb and run below command:
>   /path/to/pgsql/bin/initdb -D /path/to/pgsql/data
>
> I get following error:
>
> The files belonging to this database system will be owned by user
> "reydan.cankur".
> This user must also own the server process.
>
> The database cluster will be initialized with locale en_US.UTF-8.
> The default database encoding has accordingly been set to UTF8.
> The default text search configuration will be set to "english".
>
> fixing permissions on existing directory /path/to/pgsql/data ... ok
> creating subdirectories ... ok
> selecting default max_connections ... 100
> selecting default shared_buffers ... 32MB
> creating configuration files ... ok
> creating template1 database in /path/to/pgsql/data/base/1 ... FATAL:
> could not create unique index "pg_type_typname_nsp_index"
> DETAIL:  Table contains duplicated values.
> child process exited with exit code 1
> initdb: removing contents of data directory "/path/to/pgsql/data"
>
> I could not get the point between initdb process and the change that I
> have made.
> I need your help on solution of this issue.
>
> Thanks in advance,
> Reydan
>
>
>
>