public inbox for [email protected]  

help / color / mirror / Atom feed

From: trafdev <[email protected]>
To: Torsten Zuehlsdorff <[email protected]>
Cc: [email protected]
Subject: Re: less than 2 sec for response - possible?
Date: Wed, 6 Jul 2016 09:46:39 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: less than 2 sec for response - possible?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox