On Fri, Jan 6, 2017 at 2:38 PM, Masahiko Sawada <sawada.m...@gmail.com> wrote: > table_size | indexes | parallel_degree | time > ------------+---------+-----------------+---------- > 6.5GB | 0 | 1 | 00:00:14 > 6.5GB | 0 | 2 | 00:00:02 > 6.5GB | 0 | 4 | 00:00:02
Those numbers look highly suspect. Are you sure you're not experiencing caching effects? (ie: maybe you ran the second and third vacuums after the first, and didn't flush the page cache, so the table was cached) > 6.5GB | 2 | 1 | 00:02:18 > 6.5GB | 2 | 2 | 00:00:38 > 6.5GB | 2 | 4 | 00:00:46 ... > 13GB | 0 | 1 | 00:03:52 > 13GB | 0 | 2 | 00:00:49 > 13GB | 0 | 4 | 00:00:50 .. > 13GB | 2 | 1 | 00:12:42 > 13GB | 2 | 2 | 00:01:17 > 13GB | 2 | 4 | 00:02:12 These would also be consistent with caching effects -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
