pipelinedb

pipelinedb copied to clipboard

We'll probably want to expose separate config params that allow users to specify `max_parallel_workers_per_gather` at the process level, instead of using the global value. This will effect stream-table `JOINs` for...

derekjn

writing to external data store from pipeline db transforms

1

_Continuous Transforms New in version 0.9.0. Continuous transforms can be used to continuously transform incoming data without storing it. Since no data is stored, continuous transforms don’t support aggregations. The...

vtbyrapaneni

Incorrect TTL calculated from explicit sliding window WHERE clause

1

I'm trying to calculate on a sliding basis the total count over the last full 5 minutes, plus the incremental value in the partial minute. I've explicitly set the sliding...

andrew-blake

Regardless of the step_factor value, it's not included in the \d+ psql output. ``` create foreign table source_stream ( id serial, timestamp_tz timestamp with time zone, sid text ) server...

andrew-blake

pg_stat_statements incompatibility

19

I am in the process of migrating a lot of data from 0.9.7 to 0.9.8 and have discovered that `combine` no longer works. ```sql CREATE STREAM s (n int); CREATE...

EliSnow

conflicting types for ‘base_yylex’

8

i'm having problems compiling bison (GNU Bison) 3.0.4 flex 2.6.4 gcc (GCC) 7.1.1 20170630 ``` gram.c:64:25: error: conflicting types for ‘base_yylex’ #define yylex base_yylex ^ scan.c:9205:12: note: in expansion of...

yannick

Does pipelinedb support composite primary key?

5

We notice that we can create view by assigning primary key to avoid an additional key($pk), e.g. CREATE CONTINUOUS VIEW test_pk0 WITH (pk='x') .... Could the 'pk' parameter support multiple...

cailin-lai

Let's establish the generic infrastructure to support online updates to CTs/CVs. This will enable us to do things such as: * Change a transform's output function * Leverage TTL in...

derekjn

don't support lag function

2

when I want to use the lag function, server will close the connection. ``` stats_pipeline=# create continuous view live.test as stats_pipeline-# select user_id, lag(log_content->>'id',1) over (order by user_id, _id) as...

LmYjQ

An interesting new storage engine designed to reduce bloat by allowing in-place updates under certain conditions: https://github.com/EnterpriseDB/zheap

derekjn