Re: less than 2 sec for response - possible?

From: Torsten Zuehlsdorff <mailinglists(at)toco-domains(dot)de>
To: trafdev <trafdev(at)mail(dot)ru>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: less than 2 sec for response - possible?
Date: 2016-07-06 15:27:29
Message-ID: 1dcc1237-6134-e8e7-124e-ce5fffcff30b@toco-domains.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2016-07-06 16:12:02 Re: DELETE takes too much memory
Previous Message trafdev 2016-07-06 15:06:03 Re: less than 2 sec for response - possible?