uess "channel" must not be the primary key to "valueseries" and
> that's why you use an IN().
Correct. We create a new valueseries in some circumstances, so multiple
valueseries can point to the same channel.
On 2022-04-27 10:22, David Rowley wrote:
On Wed, 27 Apr
Buffers: shared read=3
...
Planning Time: 1.169 ms
Execution Time: 0.524 ms
Regards
Emil
On 2022-04-25 18:00, Tom Lane wrote:
Emil Iggland writes:
The query that is giving us issues is the following, channel 752433 has
NO values, 752431 has values.
(Channel 752433 only has valueseries 75
Dear mailing list
We are investigating a strange performance issue with our database.
Our use case is a sensor reading database where we have sensor location
(called channels), parameter settings (called valueseries) and reading
(called datavalues). Datavalues is partitioned per month.
Like t
