[ADMIN] RAID10 and chunk size

2009-08-29 Thread Sergey Smirnov
Greetings, I have a little question - which chunk size is more better in performance purpose? Please advise folks. system configuration is: Software RAID 1+0 (4 x SAS 15k HDD) CentOS 32bit PostgreSQL 8.3.3 Thanks in advance and have a nice holidays, cheers! -- Sergey Smirnov email/xmpp: serge

[ADMIN] pg_tblspc links question

2009-08-29 Thread Kevin Kempter
Hi all; I'm moving a db install from one server to another. the source box had 2 tablespaces and I see this in the pg_tblspc dir: lrwxrwxrwx 1 postgres postgres 20 2009-08-10 19:23 17261 -> /san_B/pwreport_3000 lrwxrwxrwx 1 postgres postgres 20 2009-08-11 17:20 17625 -> /san_A/pwreport_1000 lr