Re: less than 2 sec for response - possible?

From: trafdev <trafdev(at)mail(dot)ru>
To: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: less than 2 sec for response - possible?
Date: 2016-07-19 14:28:38
Message-ID: fbea2bea-63dc-f721-4e0e-82f9abe5e3ea@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>> The difference is - you're fetching\grouping 8 times less rows than I:
>
> Huh? The explain output certainly doesn't show that.

Why not?

My output:
Buffers: shared hit=1486949

Torsten's output:
Buffers: shared hit=155711

This is amount of rows fetched for further processing (when all data is
in memory), isn't it?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim Nasby 2016-07-19 14:41:27 Re: less than 2 sec for response - possible?
Previous Message Jim Nasby 2016-07-19 14:28:20 Re: DELETE takes too much memory