Derek Nelson
Derek Nelson
Yea this is pretty straightforward, kind of an interesting little project actually. I bumped it off the next release because we're prioritizing refactor work, but this issue is still pretty...
As a side note, you'll want to use `clock_timestamp()` instead of `now()` for that sliding window. `now()` returns the time that the xact started whereas `clock_timestamp()` always returns wall time....
https://github.com/pipelinedb/docs/issues/20
Probably not, because aggregates over a stream technically would never return. Did you have a use case or particular query in mind?
Hi @mich43l, Can you share a `docker` command that will run a container with the same OS your RP is using? If you can provide that, we'll take it from...
@andrew-blake how long after creating the database did you run `DROP DATABASE`? If you immediately try to drop it after creating it, you'll see this error.
The `reaper` should also be smart enough to efficiently drop partitions that are out of window.
Hi @pinkerltm, did you try running with a shared memory volume? e.g., docker run -v /dev/shm:/dev/shm pipelinedb/pipelinedb:0.9.7
@pinkerltm got it. Can you let us know where you end up with this? We're happy to take a deeper look if there's a problem somewhere.
We've made it this far without these columns, so I don't actually think it's worth introducing a non-critical catalog change before the extension refactor. This information can be pulled from...