Re: Deadlock in XLogInsert at AIX

On 02.02.2017 18:20, REIX, Tony wrote:
>
> Hi Konstantin
>
> I have an issue with pgbench. Any idea ?
>
>

Pgbench -s options specifies scale.
Scale 1000 corresponds to 1000 million rows and requires about 16Gb at disk.

> # 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 *XL**C 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 compa//ny (ATOS/Bull) sells IBM Power
>>>>> machines under the Escala brand s//ince 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(at)postgresql(dot)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
>

--
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company