Hi,
On Wed, Jan 12, 2022 at 11:23:33AM +0300, Hüseyin Ellezer wrote:
> I mean, despite the execution times shown here PostgreSQL 10 is working
> faster compared to PostgreSQL 14.
Please don't top-post here, see https://wiki.postgresql.org/wiki/Mailing_Lists
for more details.
> Is this speed perf
st 12. 1. 2022 v 9:23 odesílatel Hüseyin Ellezer
napsal:
> I mean, despite the execution times shown here PostgreSQL 10 is working
> faster compared to PostgreSQL 14. Is this speed performance about the
> cached or disk data? How can we see where the data comes from?
>
use EXPLAIN (ANALYZE, BUFF
I mean, despite the execution times shown here PostgreSQL 10 is working
faster compared to PostgreSQL 14. Is this speed performance about the
cached or disk data? How can we see where the data comes from?
Best regards
Pavel Stehule , 11 Oca 2022 Sal, 16:31 tarihinde
şunu yazdı:
>
>
> út 11. 1. 2
út 11. 1. 2022 v 9:41 odesílatel Hüseyin Ellezer
napsal:
> Hello everyone,
>
> I am currently running queries with the same table structures in 2
> different virtual machines and 2 different versions. and I get results like
> below.
>
>
> Execution Query:
>
> select d.device_id from ats_devices d
Hello everyone,
I am currently running queries with the same table structures in 2
different virtual machines and 2 different versions. and I get results like
below.
Execution Query:
select d.device_id from ats_devices d inner join ats_device_detays dd on
dd.device_id=d.device_id;
RESULTS:
po
