|
|
|
|
|
|
by mistrial9
2949 days ago
|
|
|
recent experience (yesterday) with Postgres 10 from the PGDG repo for Ubuntu.. reading indexes plus data from a 30GB database for analytics on a four-core i5 consumer motherboard with "spinning rust" disks, parallel configs set in postgresql.conf, and shared_mem of about 6GB, the reads from disk are consistantly 30-40 percent faster for the larger tables, with no change in the smaller tables.. (it is easy to see the parallel workers in htop) Great feature from PostgreSQL Global Development Group! |
|
|