Re: Some questions about Postgres

2022-11-06 Thread Siddharth Jain
Thanks Laurenz. On Fri, Nov 4, 2022 at 1:55 AM Laurenz Albe wrote: > On Thu, 2022-11-03 at 10:42 -0700, Christophe Pettus wrote: > > > On Nov 3, 2022, at 10:38, Siddharth Jain wrote: > > > I read an old article comparing MySQL to Postgres and wanted to get > answers to following questions. > >

Re: Some questions about Postgres

2022-11-04 Thread Laurenz Albe
On Thu, 2022-11-03 at 10:42 -0700, Christophe Pettus wrote: > > On Nov 3, 2022, at 10:38, Siddharth Jain wrote: > > I read an old article comparing MySQL to Postgres and wanted to get answers > > to following questions. > > Given your questions, I suspect that you read the technical note from U

Re: Some questions about Postgres

2022-11-03 Thread Siddharth Jain
Thanks Christophe. Yes that is the article and I read the response as well. On Thu, Nov 3, 2022 at 10:42 AM Christophe Pettus wrote: > > > > On Nov 3, 2022, at 10:38, Siddharth Jain wrote: > > I read an old article comparing MySQL to Postgres and wanted to get > answers to following questions.

Re: Some questions about Postgres

2022-11-03 Thread Christophe Pettus
> On Nov 3, 2022, at 10:38, Siddharth Jain wrote: > I read an old article comparing MySQL to Postgres and wanted to get answers > to following questions. Given your questions, I suspect that you read the technical note from Uber about why they switched back to MySQL from PostgreSQL. There

Some questions about Postgres

2022-11-03 Thread Siddharth Jain
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? - d