Hi all, I am new to Postgres. I read an old article comparing MySQL to Postgres and wanted to get answers to following questions. All questions are w.r.t. Postgres 14:
- do postgres secondary indexes point directly to tuples on disk? - does postgres use a separate process for each connection? - does postgres use any application cache similar to innodb_buffer_pool? Thanks a lot. If you can provide references to documentation, that would be great.