hawq-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marek Wiewiorka <marek.wiewio...@gmail.com>
Subject Controlling number of threads per segment
Date Sun, 21 Feb 2016 21:28:07 GMT
Hi All,
I've spent a lot of time trying to figure out how to control the number of
segments instances/threads per node in Hawq and could find any information
on that.
In fact I'm a bit confused:
1)in this blog entry:

I found that Alexey had a cluster of 4 nodes with 10threads running on each
If I query the same table (gp_segment_configuration) in my installation I
get only 5 rows - one per each node - this might indicate that I have only
one segment instance running per node.

2) On the other hand when I monitor cpu utilization while running some test
queries I can observe
that actually 8 threads per node are active. I can also see that all my
tables have 40 segments at maximum.

I found some pieces of information on 2 params:
The number of segment instances to run per segment

The amount of memory allowed to a single segment instance on a host.

But when I tried to put them in posgresql.conf of my nodes I found in log
that both are unrecognized:

2016-02-21 20:16:36.720257
configuration parameter
2016-02-21 20:16:36.720913
configuration parameter ""NSegs""",,,,,,,,"set_config_option","guc.c",9933,

So my question is how to:
1)Control number of threads/segment instances per node?
2)Control number of segments per table?
I suspect that these 2 things might be somehow interconnected.

Many thanks for any hints on that.


View raw message