Re: less than 2 sec for response - possible? - Mailing list pgsql-performance

From trafdev
Subject Re: less than 2 sec for response - possible?
Date
Msg-id fbea2bea-63dc-f721-4e0e-82f9abe5e3ea@mail.ru
Whole thread Raw
In response to Re: less than 2 sec for response - possible?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: less than 2 sec for response - possible?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List 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?


pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: DELETE takes too much memory
Next
From: Jim Nasby
Date:
Subject: Re: less than 2 sec for response - possible?