Hi Konstantin I have an issue with pgbench. Any idea ?
# mkdir /tmp/PGS # chown pgstbf.staff /tmp/PGS # su pgstbf $ /opt/freeware/bin/initdb -D /tmp/PGS The files belonging to this database system will be owned by user "pgstbf". This user must also own the server prcess. The database cluster will be initialized with locale "C". The default database encoding has accordingly been set to "SQL_ASCII". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /tmp/PGS ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting dynamic shared memory implementation ... posix creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: $ /opt/freeware/bin/pg_ctl -D /tmp/PGS -l /tmp/PGS/logfile start server starting $ /opt/freeware/bin/pg_ctl -D /tmp/PGS -l /tmp/PGS/logfile status pg_ctl: server is running (PID: 11599920) /opt/freeware/bin/postgres_64 "-D" "/tmp/PGS" $ /usr/bin/createdb pgstbf $ $ pgbench -i -s 1000 creating tables... 100000 of 100000000 tuples (0%) done (elapsed 0.29 s, remaining 288.09 s) ... 100000000 of 100000000 tuples (100%) done (elapsed 42.60 s, remaining 0.00 s) ERROR: could not extend file "base/16384/24614": wrote only 7680 of 8192 bytes at block 131071 HINT: Check free disk space. CONTEXT: COPY pgbench_accounts, line 7995584 PQendcopy failed After cleaning all /tmp/PGS and symlinking it to /home, where I have 6GB free, I've retried and I got nearly the same: 100000000 of 100000000 tuples (100%) done (elapsed 204.65 s, remaining 0.00 s) ERROR: could not extend file "base/16384/16397.6": No space left on device HINT: Check free disk space. CONTEXT: COPY pgbench_accounts, line 51235802 PQendcopy failed Do I need more than 6GB ??? Thanks Tony $ df -k . Filesystem 1024-blocks Free %Used Iused %Iused Mounted on /dev/hd1 45088768 6719484 86% 946016 39% /home bash-4.3$ pwd /tmp/PGS bash-4.3$ ll /tmp/PGS lrwxrwxrwx 1 root system 10 Feb 2 08:43 /tmp/PGS -> /home/PGS/ $ df -k Filesystem 1024-blocks Free %Used Iused %Iused Mounted on /dev/hd4 524288 277284 48% 10733 14% / /dev/hd2 6684672 148896 98% 49303 48% /usr /dev/hd9var 2097152 314696 85% 24934 18% /var /dev/hd3 3145728 2527532 20% 418 1% /tmp /dev/hd1 45088768 6719484 86% 946016 39% /home /dev/hd11admin 131072 130692 1% 7 1% /admin /proc - - - - - /proc /dev/hd10opt 65273856 829500 99% 938339 41% /opt /dev/livedump 262144 261776 1% 4 1% /var/adm/ras/livedump /aha - - - 18 1% /aha $ cat logfile LOG: database system was shut down at 2017-02-02 09:08:31 CST LOG: MultiXact member wraparound protections are now enabled LOG: autovacuum launcher started LOG: database system is ready to accept connections ERROR: could not extend file "base/16384/16397.6": No space left on device HINT: Check free disk space. CONTEXT: COPY pgbench_accounts, line 51235802 STATEMENT: copy pgbench_accounts from stdin $ ulimit -a core file size (blocks, -c) 1048575 data seg size (kbytes, -d) 131072 file size (blocks, -f) unlimited max memory size (kbytes, -m) 32768 open files (-n) 2000 pipe size (512 bytes, -p) 64 stack size (kbytes, -s) 32768 cpu time (seconds, -t) unlimited max user processes (-u) unlimited virtual memory (kbytes, -v) unlimited bash-4.3$ ll /tmp/PGS lrwxrwxrwx 1 root system 10 Feb 2 08:43 /tmp/PGS -> /home/PGS/ bash-4.3$ ls -l total 120 -rw------- 1 pgstbf staff 4 Feb 2 09:08 PG_VERSION drwx------ 6 pgstbf staff 256 Feb 2 09:09 base drwx------ 2 pgstbf staff 4096 Feb 2 09:09 global -rw------- 1 pgstbf staff 410 Feb 2 09:13 logfile drwx------ 2 pgstbf staff 256 Feb 2 09:08 pg_clog drwx------ 2 pgstbf staff 256 Feb 2 09:08 pg_commit_ts drwx------ 2 pgstbf staff 256 Feb 2 09:08 pg_dynshmem -rw------- 1 pgstbf staff 4462 Feb 2 09:08 pg_hba.conf -rw------- 1 pgstbf staff 1636 Feb 2 09:08 pg_ident.conf drwx------ 4 pgstbf staff 256 Feb 2 09:08 pg_logical drwx------ 4 pgstbf staff 256 Feb 2 09:08 pg_multixact drwx------ 2 pgstbf staff 256 Feb 2 09:08 pg_notify drwx------ 2 pgstbf staff 256 Feb 2 09:08 pg_replslot drwx------ 2 pgstbf staff 256 Feb 2 09:08 pg_serial drwx------ 2 pgstbf staff 256 Feb 2 09:08 pg_snapshots drwx------ 2 pgstbf staff 256 Feb 2 09:08 pg_stat drwx------ 2 pgstbf staff 256 Feb 2 09:17 pg_stat_tmp drwx------ 2 pgstbf staff 256 Feb 2 09:08 pg_subtrans drwx------ 2 pgstbf staff 256 Feb 2 09:08 pg_tblspc drwx------ 2 pgstbf staff 256 Feb 2 09:08 pg_twophase drwx------ 3 pgstbf staff 256 Feb 2 09:08 pg_xlog -rw------- 1 pgstbf staff 88 Feb 2 09:08 postgresql.auto.conf -rw------- 1 pgstbf staff 22236 Feb 2 09:08 postgresql.conf -rw------- 1 pgstbf staff 46 Feb 2 09:08 postmaster.opts -rw------- 1 pgstbf staff 69 Feb 2 09:08 postmaster.pid bash-4.3$ ls -l base total 112 drwx------ 2 pgstbf staff 16384 Feb 2 09:08 1 drwx------ 2 pgstbf staff 12288 Feb 2 09:08 12407 drwx------ 2 pgstbf staff 12288 Feb 2 09:09 12408 drwx------ 2 pgstbf staff 16384 Feb 2 09:14 16384 bash-4.3$ ls -l base/16384/ total 15200 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 112 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 113 -rw------- 1 pgstbf staff 57344 Feb 2 09:09 12243 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 12243_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12243_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 12245 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12247 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12248 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 12248_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12248_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 12250 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12252 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12253 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 12253_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12253_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 12255 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12257 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12258 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 12258_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12258_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 12260 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12262 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12263 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 12263_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12263_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 12265 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12267 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12268 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 12268_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12268_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 12270 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12272 -rw------- 1 pgstbf staff 0 Feb 2 09:09 12273 -rw------- 1 pgstbf staff 0 Feb 2 09:09 12275 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 12277 -rw------- 1 pgstbf staff 73728 Feb 2 09:14 1247 -rw------- 1 pgstbf staff 24576 Feb 2 09:14 1247_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:14 1247_vm -rw------- 1 pgstbf staff 368640 Feb 2 09:14 1249 -rw------- 1 pgstbf staff 24576 Feb 2 09:14 1249_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:14 1249_vm -rw------- 1 pgstbf staff 589824 Feb 2 09:09 1255 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 1255_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 1255_vm -rw------- 1 pgstbf staff 90112 Feb 2 09:14 1259 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 1259_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:14 1259_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 1417 -rw------- 1 pgstbf staff 0 Feb 2 09:09 1417_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 1418 -rw------- 1 pgstbf staff 0 Feb 2 09:09 1418_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 16385 -rw------- 1 pgstbf staff 450560 Feb 2 09:14 16388 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 16388_fsm -rw------- 1 pgstbf staff 0 Feb 2 09:09 16391 -rw------- 1 pgstbf staff 40960 Feb 2 09:14 16394 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 16394_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 174 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 175 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2187 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2328 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2328_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 2336 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2336_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2337 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2600 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2600_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2600_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2601 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2601_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2601_vm -rw------- 1 pgstbf staff 49152 Feb 2 09:09 2602 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2602_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2602_vm -rw------- 1 pgstbf staff 40960 Feb 2 09:09 2603 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2603_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2603_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 2604 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2604_vm -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2605 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2605_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2605_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2606 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2606_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2606_vm -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2607 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2607_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2607_vm -rw------- 1 pgstbf staff 450560 Feb 2 09:14 2608 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2608_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:14 2608_vm -rw------- 1 pgstbf staff 278528 Feb 2 09:09 2609 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2609_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2609_vm -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2610 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2610_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2610_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 2611 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2611_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2612 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2612_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2612_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 2613 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2613_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2615 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2615_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2615_vm -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2616 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2616_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2616_vm -rw------- 1 pgstbf staff 122880 Feb 2 09:09 2617 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2617_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2617_vm -rw------- 1 pgstbf staff 98304 Feb 2 09:09 2618 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2618_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2618_vm -rw------- 1 pgstbf staff 122880 Feb 2 09:14 2619 -rw------- 1 pgstbf staff 24576 Feb 2 09:14 2619_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:14 2619_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 2620 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2620_vm -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2650 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2651 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2652 -rw------- 1 pgstbf staff 40960 Feb 2 09:09 2653 -rw------- 1 pgstbf staff 40960 Feb 2 09:09 2654 -rw------- 1 pgstbf staff 40960 Feb 2 09:09 2655 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2656 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2657 -rw------- 1 pgstbf staff 106496 Feb 2 09:14 2658 -rw------- 1 pgstbf staff 73728 Feb 2 09:14 2659 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2660 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2661 -rw------- 1 pgstbf staff 32768 Feb 2 09:14 2662 -rw------- 1 pgstbf staff 40960 Feb 2 09:14 2663 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2664 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2665 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2666 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2667 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2668 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2669 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2670 -rw------- 1 pgstbf staff 319488 Feb 2 09:14 2673 -rw------- 1 pgstbf staff 352256 Feb 2 09:14 2674 -rw------- 1 pgstbf staff 172032 Feb 2 09:09 2675 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2678 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2679 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2680 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2681 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2682 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2683 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2684 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2685 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2686 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2687 -rw------- 1 pgstbf staff 40960 Feb 2 09:09 2688 -rw------- 1 pgstbf staff 40960 Feb 2 09:09 2689 -rw------- 1 pgstbf staff 81920 Feb 2 09:09 2690 -rw------- 1 pgstbf staff 253952 Feb 2 09:09 2691 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2692 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2693 -rw------- 1 pgstbf staff 16384 Feb 2 09:14 2696 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2699 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2701 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2702 -rw------- 1 pgstbf staff 16384 Feb 2 09:14 2703 -rw------- 1 pgstbf staff 40960 Feb 2 09:14 2704 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2753 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2753_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2753_vm -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2754 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2755 -rw------- 1 pgstbf staff 32768 Feb 2 09:09 2756 -rw------- 1 pgstbf staff 32768 Feb 2 09:09 2757 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2830 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2830_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2831 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2832 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2832_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2833 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2834 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2834_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2835 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2836 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2836_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2837 -rw------- 1 pgstbf staff 385024 Feb 2 09:09 2838 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2838_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2838_vm -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2839 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2840 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 2840_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2840_vm -rw------- 1 pgstbf staff 16384 Feb 2 09:09 2841 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2995 -rw------- 1 pgstbf staff 0 Feb 2 09:09 2995_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 2996 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3079 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 3079_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3079_vm -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3080 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3081 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3085 -rw------- 1 pgstbf staff 0 Feb 2 09:09 3118 -rw------- 1 pgstbf staff 0 Feb 2 09:09 3118_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3119 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3164 -rw------- 1 pgstbf staff 0 Feb 2 09:09 3256 -rw------- 1 pgstbf staff 0 Feb 2 09:09 3256_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3257 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3258 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3394 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 3394_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3394_vm -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3395 -rw------- 1 pgstbf staff 32768 Feb 2 09:14 3455 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3456 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 3456_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3456_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 3466 -rw------- 1 pgstbf staff 0 Feb 2 09:09 3466_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3467 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3468 -rw------- 1 pgstbf staff 0 Feb 2 09:09 3501 -rw------- 1 pgstbf staff 0 Feb 2 09:09 3501_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3502 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3503 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3534 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3541 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 3541_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3541_vm -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3542 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3574 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3575 -rw------- 1 pgstbf staff 0 Feb 2 09:09 3576 -rw------- 1 pgstbf staff 0 Feb 2 09:09 3576_vm -rw------- 1 pgstbf staff 0 Feb 2 09:09 3596 -rw------- 1 pgstbf staff 0 Feb 2 09:09 3596_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3597 -rw------- 1 pgstbf staff 0 Feb 2 09:09 3598 -rw------- 1 pgstbf staff 0 Feb 2 09:09 3598_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3599 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3600 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 3600_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3600_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3601 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 3601_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3601_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3602 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 3602_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3602_vm -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3603 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 3603_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3603_vm -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3604 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3605 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3606 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3607 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3608 -rw------- 1 pgstbf staff 32768 Feb 2 09:09 3609 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3712 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3764 -rw------- 1 pgstbf staff 24576 Feb 2 09:09 3764_fsm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 3764_vm -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3766 -rw------- 1 pgstbf staff 16384 Feb 2 09:09 3767 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 548 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 549 -rw------- 1 pgstbf staff 0 Feb 2 09:09 826 -rw------- 1 pgstbf staff 0 Feb 2 09:09 826_vm -rw------- 1 pgstbf staff 8192 Feb 2 09:09 827 -rw------- 1 pgstbf staff 8192 Feb 2 09:09 828 -rw------- 1 pgstbf staff 4 Feb 2 09:09 PG_VERSION -rw------- 1 pgstbf staff 512 Feb 2 09:09 pg_filenode.map -rw------- 1 pgstbf staff 112660 Feb 2 09:09 pg_internal.init Le 01/02/2017 à 21:26, Konstantin Knizhnik a écrit : On 02/01/2017 08:30 PM, REIX, Tony wrote: Hi Konstantin, .... If you could share scripts or instructions about the tests you are doing with pgbench, I would reproduce here. You do not need any script. Just two simple commands. One to initialize database: pgbench -i -s 1000 And another to run benchmark itself: pgbench -c 100 -j 20 -P 1 -T 1000000000 ... Regards, Tony Le 01/02/2017 à 16:59, Konstantin Knizhnik a écrit : Hi Tony, On 01.02.2017 18:42, REIX, Tony wrote: Hi Konstantin XLC. I'm on AIX 7.1 for now. I'm using this version of XLC v13: # xlc -qversion IBM XL C/C++ for AIX, V13.1.3 (5725-C72, 5765-J07) Version: 13.01.0003.0003 With this version, I have (at least, since I tested with "check" and not "check-world" at that time) 2 failing tests: create_aggregate , aggregates . With the following XLC v12 version, I have NO test failure: # /usr/vac/bin/xlc -qversion IBM XL C/C++ for AIX, V12.1 (5765-J02, 5725-C72) Version: 12.01.0000.0016 So maybe you are not using XLC v13.1.3.3, rather another sub-version. Unless you are using more options for the configure ? Configure. What are the options that you give to the configure ? export CC="/opt/IBM/xlc/13.1.3/bin/xlc" export CFLAGS="-qarch=pwr8 -qtune=pwr8 -O2 -qalign=natural -q64 " export LDFLAGS="-Wl,-bbigtoc,-b64" export AR="/usr/bin/ar -X64" export LD="/usr/bin/ld -b64 " export NM="/usr/bin/nm -X64" ./configure --prefix="/opt/postgresql/xlc-debug/9.6" Hard load & 64 cores ? OK. That clearly explains why I do not see this issue. pgbench ? I wanted to run it. However, I'm still looking where to get it plus a guide for using it for testing. pgbench is part of Postgres distributive (src/bin/pgbench) I would add such tests when building my PostgreSQL RPMs on AIX. So any help is welcome ! Performance. - Also, I'd like to compare PostgreSQL performance on AIX vs Linux/PPC64. Any idea how I should proceed ? Any PostgreSQL performance benchmark that I could find and use ? pgbench ? pgbench is most widely used tool simulating OLTP workload. Certainly it is quite primitive and its results are rather artificial. TPC-C seems to be better choice. But the best case is to implement your own benchmark simulating actual workload of your real application. - I'm interested in any information for improving the performance & quality of my PostgreSQM RPMs on AIX. (As I already said, BullFreeware RPMs for AIX are free and can be used by anyone, like Perzl RPMs are. My company (ATOS/Bull) sells IBM Power machines under the Escala brand since ages (25 years this year)). How to help ? How could I help for improving the quality and performance of PostgreSQL on AIX ? We still have one open issue at AIX: see https://www.mail-archive.com/pgsql-hackers@postgresql.org/msg303094.html It will be great if you can somehow help to fix this problem. -- Konstantin Knizhnik Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Konstantin Knizhnik Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
