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?
- SELECT Query taking 200 ms on PostgreSQL compared to 4 m... aditya desai
- Re: SELECT Query taking 200 ms on PostgreSQL compar... Bharath Rupireddy
- Re: SELECT Query taking 200 ms on PostgreSQL compar... Pavel Stehule
- Re: SELECT Query taking 200 ms on PostgreSQL co... Justin Pryzby
- Re: SELECT Query taking 200 ms on PostgreSQ... aditya desai
- Re: SELECT Query taking 200 ms on Postg... Bruce Momjian
- Re: SELECT Query taking 200 ms on ... aditya desai
- Re: SELECT Query taking 200 ms on ... Bruce Momjian
- Re: SELECT Query taking 200 ms on PostgreSQL co... aditya desai
- Re: SELECT Query taking 200 ms on PostgreSQL compar... Michael Lewis
- Re: SELECT Query taking 200 ms on PostgreSQL co... aditya desai
- Re: SELECT Query taking 200 ms on PostgreSQ... Bruce Momjian
- Re: SELECT Query taking 200 ms on Postg... aditya desai
- Re: SELECT Query taking 200 ms on ... Pavel Stehule
- Re: SELECT Query taking 200 ms on ... Bruce Momjian
