Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Sat, 3 Apr 2021 08:10:23 -0600
Cc
: Pgsql Performance <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <CAN0SRDFV=Fv0zXHCGbh7gh=MTfw05Xd1x7gjJrZs5qn-TEphOw@mail.gmail.com>
References
: <CAN0SRDFV=Fv0zXHCGbh7gh=MTfw05Xd1x7gjJrZs5qn-TEphOw@mail.gmail.com>
It seems like something is missing. Is this table partitioned? How long ago was migration done? Has vacuum freeze and analyze of tables been done? Was index created after populating data or reindexed after perhaps? What version are you using?
Follow-Ups
:
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
From:
aditya desai
References
:
SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
From:
aditya desai
Prev by Date:
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Next by Date:
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Previous by thread:
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Next by thread:
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
