[GENERAL] Testing on Power 8 systems

2014-11-03 Thread Georges Racinet
Hi, I have an opportunity to test PostgreSQL and the applications I care about on a IBM Power 8 system tomorrow afternoon (Nov 4th, CET time). While my primary interest lies in the applications, I was wondering if people here would have advice or interest about useful tests or benchmarks to perfo

Re: [GENERAL] Testing on Power 8 systems

2014-11-03 Thread Georges Racinet
On 11/03/2014 07:27 PM, Devrim Gündüz wrote: > On Mon, 2014-11-03 at 18:45 +0100, Georges Racinet wrote: >> > Didn't find many ppc64 ou ppc64el binary packages online, though: >> > yum.postgresql.org > For the archives: We will support Power 7 and Power 8 systems

[GENERAL] Problem with 9.1 streaming replication

2012-07-23 Thread Georges Racinet
1:27:59 UTC LOG: le syst?me de bases de donn?es est pr?t pour accepter les connexions 2012-07-22 21:27:59 UTC LOG: lancement du processus autovacuum 2012-07-22 21:30:19 UTC ERREUR: n'a pas pu lire le bloc 0 du fichier « base/142824/151268 » : a lu seulement 0 octets sur 8192 --

Re: [GENERAL] Odd query result

2012-08-27 Thread Georges Racinet
interesting, I didn't know it were possible to set an index on a function result. I guess one must also reindex in case some record changes as well, right ? Through a trigger maybe ? Thanx for the informative posts, -- Georges Racinet Anybox SAS, http://anybox.fr Bureau: 09 53 53 72 97 Por

Re: [GENERAL] Odd query result

2012-08-27 Thread Georges Racinet
On 08/27/2012 12:47 PM, Sergey Konoplev wrote: On Mon, Aug 27, 2012 at 2:37 PM, Georges Racinet wrote: I guess one must also reindex in case some record changes as well, right ? Through a trigger maybe ? You do not need to reindex it in case of record changes. The index values will be

Re: [GENERAL] pgbench help

2012-12-24 Thread Georges Racinet
On 12/24/2012 08:50 AM, Atri Sharma wrote: > I have two 9.2 servers running in different data directories and > installation directories. One of them(the main one) has its bin in the > path of my system.The other one does not, hence, I need to use the > complete path(/usr/local/pgsql/...). > > I wa

Re: [GENERAL] pgbench help

2012-12-24 Thread Georges Racinet
On 12/24/2012 12:32 PM, John R Pierce wrote: > On 12/24/2012 2:43 AM, Georges Racinet wrote: >> Make sure both servers aren't running at the same time > > why? its perfectly OK to ahve severla postgres servers running at > once, as long as they are on different port num