Thanks, I'll try this

select drop_partition('tablename')

I get this error often while dropping partitions ERROR 2083: A Moveout operation is already in progress on projection XXX Is there a command to drop partitions which incorporates a "wait" till the moveout is done? Dropping partitions is critical as space usage needs to be reclaimed. This requires sc...

I dont agree

Try purging a day's worth of 2 billion log entries on a daily basis without partitions.

You have to partition by date to have a smooth way to purge historical data.

If I create a table with a partition like partition by date_trunc('day',dt) where dt is a timestamp columns... then queries like where dt >= date_trunc('day',current_timestamp) will be slower than dt >= date_trunc('day',current_timestamp::timestamp) This is also true for postgres...I would expect th...

If i create a projection with a sort order like

order by col1,col2,col3

what does that translate to from a storage perspective...

Does it mean that col1,col2 and col3 are independently stored sorted ? Is there any collocation of rows based on this column ordering

Is there a way to see how a query performs with respect to IO calls made / Cache hits / Memory Used / Network Wait

I understand that the Web Admin Interface has a graphical component that does something similar. I am looking for an accurate profile of resource usage by a query