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

From Torsten Zuehlsdorff
Subject Re: less than 2 sec for response - possible?
Date
Msg-id 1dcc1237-6134-e8e7-124e-ce5fffcff30b@toco-domains.de
Whole thread Raw
In response to Re: less than 2 sec for response - possible?  (trafdev <trafdev@mail.ru>)
Responses Re: less than 2 sec for response - possible?
List pgsql-performance
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


pgsql-performance by date:

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