| From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
|---|---|
| To: | trafdev <trafdev(at)mail(dot)ru>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: less than 2 sec for response - possible? |
| Date: | 2016-07-19 14:10:57 |
| Message-ID: | d4f43413-7df2-c330-7445-2760eb0b9152@BlueTreble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 7/9/16 12:26 PM, trafdev wrote:
> So does that mean Postgres is not capable to scan\aggregate less than 10
> mln rows and deliver result in less than 2 seconds?
That's going to depend entirely on your hardware, and how big the rows
are. At some point you're simply going to run out of memory bandwidth,
especially since your access pattern is very scattered.
> On 07/06/16 09:46, trafdev wrote:
>> Well, our CPU\RAM configs are almost same...
>>
>> The difference is - you're fetching\grouping 8 times less rows than I:
Huh? The explain output certainly doesn't show that.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2016-07-19 14:28:20 | Re: DELETE takes too much memory |
| Previous Message | Jan Wieck | 2016-07-17 01:14:50 | Re: slony rpm help slony1-95-2.2.2-1.rhel6.x86_64 |