You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
PostgreSQL version (output of postgres --version): 13.2
TimescaleDB version (output of \dx in psql): 2.2.0
Installation method: Official Docker image - timescale/timescaledb:2.2.0-pg13
Describe the bug
According to the pg 13 documentation, pg_stat_progress_create_index should show index creation progress. However, index creation on hypertables doesn't seem to show up.
I've been creating an index on a large dataset for several hours now and select query from pg_stat_activity; shows several worker threads executing a CREATE INDEX on the hypertable, but pg_stat_progress_create_index doens't show anything.
In case it's relevant, I'll mention that the hypertable has compression enabled, and the index is being built on the segment-by columns.
Expected behavior
Progress towards index creation should show up in pg_stat_progress_create_index
The text was updated successfully, but these errors were encountered:
@mkindahl
Is there a list somewhere of postgres features that aren't supposed to work on hypertables? It's sometimes hard to tell the difference between features and bugs when some standard postgres thing doesn't work as expected on a hypertable.
I would be nice to have a list of known places where the hypertable abstraction is leaking.
I would also really like this as well. Especially since CREATE INDEX CONCURRENTLY. Right now if you add an index to a hypertable it will lock and you're not sure when it will become available again.
At least for me...if CONCURRENTLY and this take the same amount of work, I would prefer CONCURRENTLY 😄
Relevant system information:
postgres --version
): 13.2\dx
inpsql
): 2.2.0Describe the bug
According to the pg 13 documentation,
pg_stat_progress_create_index
should show index creation progress. However, index creation on hypertables doesn't seem to show up.I've been creating an index on a large dataset for several hours now and
select query from pg_stat_activity;
shows several worker threads executing aCREATE INDEX
on the hypertable, butpg_stat_progress_create_index
doens't show anything.In case it's relevant, I'll mention that the hypertable has compression enabled, and the index is being built on the
segment-by
columns.Expected behavior
Progress towards index creation should show up in
pg_stat_progress_create_index
The text was updated successfully, but these errors were encountered: