Re: [PERFORM] 2 server with same configuration but huge difference in performance

rence between these 2 databases. Thanks & Regards, Sumeet Shukla On Tue, Aug 1, 2017 at 9:05 PM, Scott Marlowe wrote: > On Tue, Aug 1, 2017 at 6:41 AM, Sumeet Shukla > wrote: > > Hi, > > > > I have 2 PG servers with same h/w and configuration and they are not in >

[PERFORM] 2 server with same configuration but huge difference in performance

be highly appreciated. Thanks & Regards, Sumeet Shukla

Re: [PERFORM] Dataset is fetched from cache but still takes same time to fetch records as first run

Yes, but when I actually execute the query in pgAdmin3, it takes exactly the same time of 19.5 secs. How is that possible? Thanks & Regards, Sumeet Shukla On Thu, Jun 22, 2017 at 7:54 PM, Dave Stibrany wrote: > The numbers you posted look exactly as I would expect. The first read hits

[PERFORM] Dataset is fetched from cache but still takes same time to fetch records as first run

ion time: 108.626 ms" *Second Run:* "Seq Scan on d_payer (cost=0.00..8610.40 rows=121788 width=133) (actual time=0.010..18.456 rows=121788 loops=1)" " *Buffers: shared hit=2521*" "Planning time: 0.083 ms" "Execution time: 27.288 ms" Can anyone please help me understand and fix this. Thanks & Regards, Sumeet Shukla