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.
