Well, our CPU\RAM configs are almost same...
The difference is - you're fetching\grouping 8 times less rows than I:
You scan 16.5 mln rows and fetch ~200k rows in 2 seconds and than spend
1.4 sec for aggregation
I'm scanning 3.5 mln rows and fetching 1.5 mln rows (8 times more than
you) in 1.8 seconds and then spending rest (2.3 seconds) for aggregation...
So please try to extend dates range 8 times and repeat your test.
On 07/06/16 08:27, Torsten Zuehlsdorff wrote:
On 06.07.2016 17:06, trafdev wrote:
Wondering what are your CPU\RAM characteristics?
Intel Core i7-2600 Quad Core
32 GB DDR3 RAM
2x 3 TB SATA III HDD
HDD is:
Model Family: Seagate Barracuda XT
Device Model: ST33000651AS
Firmware Version: CC45
User Capacity: 3,000,592,982,016 bytes [3.00 TB]
Sector Size: 512 bytes logical/physical
Rotation Rate: 7200 rpm
Form Factor: 3.5 inches
Device is: In smartctl database [for details use: -P show]
ATA Version is: ATA8-ACS T13/1699-D revision 4
SATA Version is: SATA 3.0, 6.0 Gb/s (current: 6.0 Gb/s)
RAM is for example:
Handle 0x002D, DMI type 17, 28 bytes
Memory Device
Array Handle: 0x002A
Error Information Handle: No Error
Total Width: 64 bits
Data Width: 64 bits
Size: 8192 MB
Form Factor: DIMM
Set: None
Locator: DIMM0
Bank Locator: BANK0
Type: DDR3
Type Detail: Synchronous
Speed: 1333 MHz
Manufacturer: Undefined
Serial Number: 4430793
Asset Tag: AssetTagNum0
Part Number: CT102464BA160B.C16
Rank: 2
OS is FreeBSD 10.3. Do you need more information?
Greetings,
Torsten
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
