subject:"\[GENERAL\] puzzled by deletion performance"

Re: [GENERAL] puzzled by deletion performance

2017-07-14 Thread Tom Lane

"Zhu, Joshua" writes: > I have the following (hypothetical) tables and their relationships (primary > keys are in square brackets): > [server_id] [device_id][sensor_id][property_id] > SERVER --- 1:n --- DEVICE --- 1:n --- SENSOR --- 1:n --- PROPERTY

[GENERAL] puzzled by deletion performance

2017-07-14 Thread Zhu, Joshua

I have the following (hypothetical) tables and their relationships (primary keys are in square brackets): [server_id] [device_id][sensor_id][property_id] SERVER --- 1:n --- DEVICE --- 1:n --- SENSOR --- 1:n --- PROPERTY | |