Re: Load performance with partitioned table

2016-09-18 Thread naveen mahadevuni
hi Franke, 1) We are using 4 indentical AWS machines. 8 vCPUs, 32 GB RAM. 1 TB storage 2) Setting up bloom filters only on two other string columns. Not all of them. 3) The data is any event data ex: Syslog. 4) Queries usually run on timestamp range with additional predicates on other columns (mos

Re: Load performance with partitioned table

2016-09-15 Thread Jörn Franke
What is your hardware setup? Are the bloom filters necessary on all columns? Usually they make only sense for non-numeric columns. Updating bloom filters take time and should be avoided where they do not make sense. Can you provide an example of the data and the select queries that you execute o