Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.

From:	Michael Lewis <mlewis(at)entrata(dot)com>
To:	aditya desai <admad123(at)gmail(dot)com>
Cc:	Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject:	Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Date:	2021-04-03 14:10:23
Message-ID:	CAHOFxGpDwsbfYFbn7n-d+A7Nho3KAiFXFbDBCj8ZGou=ag7eJg@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2021-04-03 13:38:22 from aditya desai <admad123(at)gmail(dot)com>  2021-04-03 13:47:47 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>  2021-04-03 14:08:01 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>   2021-04-03 14:16:51 from Justin Pryzby <pryzby(at)telsasoft(dot)com>    2021-04-03 15:08:18 from aditya desai <admad123(at)gmail(dot)com>     2021-04-03 15:12:01 from Bruce Momjian <bruce(at)momjian(dot)us>      2021-04-03 15:22:25 from aditya desai <admad123(at)gmail(dot)com>      2021-04-03 15:24:02 from Bruce Momjian <bruce(at)momjian(dot)us>      2021-04-03 15:39:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2021-04-03 15:41:14 from Justin Pryzby <pryzby(at)telsasoft(dot)com>        2021-04-03 15:43:36 from Bruce Momjian <bruce(at)momjian(dot)us>         2021-04-04 01:25:46 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎          2021-04-08 21:38:13 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎          2021-04-09 01:50:53 from Michael Paquier <michael(at)paquier(dot)xyz>           2021-04-09 03:17:18 from Justin Pryzby <pryzby(at)telsasoft(dot)com>            2021-04-09 11:39:28 from Bruce Momjian <bruce(at)momjian(dot)us>             2021-04-12 05:01:17 from Michael Paquier <michael(at)paquier(dot)xyz>              2021-04-12 05:28:37 from Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>              2021-04-12 05:40:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>               2021-04-13 07:34:23 from Michael Paquier <michael(at)paquier(dot)xyz>                2021-04-13 12:31:39 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                 2021-04-14 06:57:21 from Michael Paquier <michael(at)paquier(dot)xyz>                  2021-04-23 18:23:26 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                   2021-04-24 01:50:21 from Michael Paquier <michael(at)paquier(dot)xyz>                    2021-04-24 02:57:35 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                2021-04-13 14:12:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2021-04-14 04:54:34 from Michael Paquier <michael(at)paquier(dot)xyz>           2021-04-29 04:24:04 from Justin Pryzby <pryzby(at)telsasoft(dot)com>            2021-05-08 16:39:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2021-04-03 15:44:33 from aditya desai <admad123(at)gmail(dot)com>         2021-04-03 17:36:57 from aditya desai <admad123(at)gmail(dot)com>          2021-04-03 17:41:50 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>           2021-04-03 17:45:47 from aditya desai <admad123(at)gmail(dot)com>            2021-04-03 17:50:38 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>             2021-04-04 11:10:33 from aditya desai <admad123(at)gmail(dot)com>       2021-04-03 15:42:59 from Bruce Momjian <bruce(at)momjian(dot)us>   2021-04-03 15:33:42 from aditya desai <admad123(at)gmail(dot)com>  2021-04-03 14:10:23 from Michael Lewis <mlewis(at)entrata(dot)com>   2021-04-03 14:59:22 from aditya desai <admad123(at)gmail(dot)com>    2021-04-03 15:04:17 from Bruce Momjian <bruce(at)momjian(dot)us>     2021-04-03 15:30:24 from aditya desai <admad123(at)gmail(dot)com>      2021-04-03 15:35:36 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>      2021-04-03 15:38:12 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:	pgsql-hackers pgsql-performance

In response to

• SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. at 2021-04-03 13:38:22 from aditya desai

Responses

• Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. at 2021-04-03 14:59:22 from aditya desai

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Justin Pryzby	2021-04-03 14:16:51	Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Previous Message	Pavel Stehule	2021-04-03 14:08:01	Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Justin Pryzby	2021-04-03 14:16:51	Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Previous Message	Pavel Stehule	2021-04-03 14:08:01	Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.