Sounds more like a school project than a proper performance question. On 11/28/09, Reydan Cankur <reydan.cankur@xxxxxxxxx> 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 > > > > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance