Re: [PERFORM] New server setup

2013-03-01 Thread Wales Wang
pls choice PCI-E Flash for written heavy app Wales 在 2013-3-1,下午8:43,Niels Kristian Schjødt 写道: > Hi, I'm going to setup a new server for my postgresql database, and I am > considering one of these: > http://www.hetzner.de/hosting/produkte_rootserver/poweredge-r720 with four > SAS drives in

[PERFORM] 回复: [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?

2012-02-27 Thread Wales Wang
lete --recursive --force /mnt/ramdisk/ /data/ramdisk-backup/     ;;   *)     echo "Usage: /etc/init.d/ramdisk {start|stop|sync}"     exit 1     ;; esac exit 0   you can run it when startup and shutdown and crontabe hoursly.   Wales Wang 发件人: Jeff Janes 收件

[PERFORM] Re: [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?

2012-02-26 Thread Wales Wang
You can try PostgreSQL 9.x master/slave replication, then try run slave on persistent RAM Fileystem(tmpfs) So, access your all data from slave PostgreSQL that run on tmpfs.. 发件人: Jeff Janes 收件人: Stefan Keller 抄送: pgsql-performance@postgresql.org; Stephen Fro

Re: [PERFORM] File system choice for Red Hat systems

2010-06-02 Thread Wales Wang
you can try Scientific Linux 5.x,it plus XFS and some other soft for HPC based on CentOS. It had XFS for years --- On Wed, 6/2/10, Alan Hodgson wrote: > From: Alan Hodgson > Subject: Re: [PERFORM] File system choice for Red Hat systems > To: pgsql-performance@postgresql.org > Date: Wednesday