Skip to content

Instantly share code, notes, and snippets.

@dPeS
Created September 30, 2015 17:39
Show Gist options
  • Save dPeS/71caf85d9fc70dba3dc6 to your computer and use it in GitHub Desktop.
Save dPeS/71caf85d9fc70dba3dc6 to your computer and use it in GitHub Desktop.
# size of the buffer for storing unread stream tuples
tuple_buffer_blocks = 256MB # 128MB
# synchronization level for combiner commits; off, local, remote_write, or on
continuous_query_combiner_synchronous_commit = off
# maximum amount of memory to use for combiner query executions
continuous_query_combiner_work_mem = 1024MB
# maximum memory to be used by the combiner for caching; this is independent
# of combiner_work_mem
continuous_query_combiner_cache_mem = 32MB
# the default fillfactor to use for continuous views
#continuous_view_fillfactor = 50
# the time in milliseconds a continuous query process will wait for a batch
# to accumulate
continuous_query_max_wait = 1000 # 10
# the maximum number of events to accumulate before executing a continuous query
# plan on them
continuous_query_batch_size = 20000
# the number of parallel continuous query combiner processes to use for
# each database
continuous_query_num_combiners = 1
# the number of parallel continuous query worker processes to use for
# each database
continuous_query_num_workers = 1
shared_buffers = 1024MB
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment