Re: [PERFORM] Performance problems with large telemetric datasets on 7.4.2

Sven Clement wrote: > Table: "public.tmdata" ... > id| integer | default -2147483684::bigint ... > Table: "public.tmdataintervalsec" ... > id| integer | default -2147483684::bigint Not that this directly addresses the performance issues you described, but

Re: [PERFORM] Slow queries on big table

Tyrrill, Ed wrote: > mdsdb=# \d backup_location > Table "public.backup_location" > Column | Type | Modifiers > ---+-+--- > record_id | bigint | not null > backup_id | integer | not null > Indexes: > "backup_location_pkey" PRIMARY KEY, btree (record_id, backup_