Sobes.tech

Were aggregation queries executed on the same database where active writes were happening? Were there any side effects? How does PostgreSQL react to data changes during a long aggregation?

235

Tell me about the batch process implementation for recalculating historical data. Why recalculate every night? How much data was stored?

235

Tell us how you optimized queries. What are the reports that take 10-12 minutes now and 5-7 minutes after optimization?

230

```go import ( "fmt" ) func deleteElement(s []int, idx int) []int { return append(s[:idx], s[idx+1:]...) } func main() { all := []int{0, 1, 2, 3, 4, 5, 6, 7, 8, 9} fmt.Println("Original slice: ") fmt.Println(" all: ", all) //---123--- del := deleteElement(all, 5) fmt.Println("After deleting element with idx = 5: ") fmt.Println(" all: ", all) //--- fmt.Println(" del: ", del) // fmt.Println("After del[0] = 999 and del[len(del) - 2] = 998: ") del[0] = 999 del[len(del)-2] = 998 fmt.Println(" all: ", all) //--- fmt.Println(" del: ", del) // } ```

225
/11