Re: [GENERAL] WAL Replication Server + repmgr + Slony

2014-04-12 Thread Jan Wieck
On 03/20/14 10:37, basti wrote: Hello, at the moment we use a Postgres (9.1) Master and a Hot-Standby with WAL Replication. We also use Slony to copy some (not all) Tables to fronted server. Is it possible to use repmgr to switch between Master and Hot-standby without lose the slony functionali

Re: [GENERAL] Cancelling of autovacuums considered harmful

2014-04-12 Thread Jan Wieck
On 02/27/14 10:43, Scott Marlowe wrote: On Wed, Feb 26, 2014 at 5:40 PM, Steve Crawford wrote: On 02/26/2014 08:56 AM, Alvaro Herrera wrote: ... No matter how heavily updated, regular activity should not cause autovacuum kills. Only heavier operations would do that (say ALTER TABLE, etc).

Re: [GENERAL] efficient way to do "fuzzy" join

2014-04-12 Thread Andy Colson
On 04/12/2014 06:29 AM, Rémi Cura wrote: (please note that this random string function is NOT the good way to do it, i should random int then use it as index to an array containing all the letter) Thanks a lot for this new version! It seems to be slower than your first solution (no index use I g

Re: [GENERAL] efficient way to do "fuzzy" join

2014-04-12 Thread Rémi Cura
(please note that this random string function is NOT the good way to do it, i should random int then use it as index to an array containing all the letter) Thanks a lot for this new version! It seems to be slower than your first solution (no index use I guess, I gave up after 5 minutes vs 5 sec fo