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-21 22:20:32 |
Message-ID: | 4fe2428d-1a6a-f637-65fd-78696a9eed7d@BlueTreble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On 7/19/16 9:56 AM, trafdev wrote:
> Will extending page to say 128K improve performance?
Well, you can't go to more than 32K, but yes, it might.
Even then, I think your biggest problem is that the data locality is too
low. You're only grabbing ~3 rows every time you read a buffer that
probably contains ~20 rows. So that's an area for improvement. The other
thing that would help a lot is to trim the table down so it's not as wide.
Actually, something else that could potentially help a lot is to store
arrays of many data points in each row, either by turning each column
into an array or storing an array of a composite type. [1] is exploring
those ideas right now.
You could also try cstore_fdw. It's not a magic bullet, but it's storage
will be much more efficient than what you're doing right now.
[1] https://github.com/ElephantStack/ElephantStack
--
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 | Johan Fredriksson | 2016-07-22 00:59:27 | Re: Performance problems with 9.2.15 |
Previous Message | Jim Nasby | 2016-07-21 22:14:55 | Re: Seeing execution plan of foreign key constraint check? |