Re-added -performance.
On Tue, Mar 27, 2018 at 05:13:25PM +0100, Glenn Pierce wrote:
> Damn as I was playing with the indexes I must have deleted the constraints :(
> Question if I have a constraint like
>
> ALTER TABLE sensor_values_2007q1
> ADD CONSTRAINT sensor_values_2007q1_sensor_id_timest
On Tue, Mar 27, 2018 at 03:14:30PM +0100, Glenn Pierce wrote:
> Hi I am having terrible trouble with a simple partitioned table.
> Select queries are very slow.
> The child tables are all like
> Check constraints:
> "sensor_values_2018q1_timestamp_check" CHECK (ts >= '2018-01-01
> 00:00:00
Hi I am having terrible trouble with a simple partitioned table.
Select queries are very slow.
Ie
SELECT ts::timestamptz, s1.sensor_id, s1.value
FROM sensor_values s1
WHERE s1.sensor_id =
ANY(ARRAY[596304,597992,610978,597998])
