Search Postgresql Archives

HW and performances

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I'm using apache and postgres to make an ecommerce website work on
an old xeon box 

processor       : 0           
vendor_id       : GenuineIntel
cpu family      : 15          
model           : 4           
model name      :                   Intel(R) Xeon(TM) CPU 3.20GHz

It looks it has 4 cores but I think they are 2 cores + HT

4Gb RAM
3 disks RAID5 [sic]

free
         total       used       free     shared    buffers     cached
Mem:   4048024    3984896      63128          0     208304    2645748
-/+ buffers/cache:    1130844    2917180
Swap:  7813112        492    7812620

Swap get slightly hit after long period of uptime.

Most of the work happens in the items table ~1M rows.

The queries that actually impact on usability are:
- full text searches on a gin index on a tsvector
- updates of the catalogue (and related gin index) in batches of 20K
  items updated/inserted.

It *seems* (not really sure) that the bottleneck for full text
searches are the CPU.

I'll have the chance to split the load over a newer box:
2 socket 5120 Xeon box
4GB RAM
2 disks RAID0 (single disk io seems faster than the box above)

I'm planning to move the DB on the newer box and leave apache on the
old one. This should free enough ram on the DB box so that the swap
will be untouched.

I'm hoping to halve the average page generation time.

I could add ram or disks to the newer box. Changing CPU doesn't look
a good investment.

Did I assign the task to the various boxes correctly?
Do I have any chance of getting near to my target even adding some
more HW to the newer box?
If not I'd think to buy a brand new box. Any suggestion?

By comparison I've a 2 socket x 4 cores Xeon E5310 @ 1.60GHz
8 Gb RAM
4 disks SATA RAID10
with apache and pg running inside a vserver (2.6.26-2-vserver-amd64)
that looks it can handle both jobs (apache and pg) at a reasonable
speed (roughly twice faster than needed) but that is still a bit
slower than what I'd like on catalogue updates.

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux