[GENERAL] PLV8 and JS exports / referencing

2014-11-05 Thread Jon Erdman
So, I was trying to use mustache.js in PG by defining a V8 function that imports it. Older versions worked fine, but in newer versions they use a class factory and I can't figure out how to reference the mustache stuff that it creates. Apparently I need to know how our V8 implementation does ex

Re: [GENERAL] Performance problem on 2 PG versions on same query

2014-11-05 Thread Tom Lane
"Tomas Vondra" writes: > Dne 5 Listopad 2014, 18:10, Tom Lane napsal(a): >> For some reason there's over 1000 times more rows in andalertsmatch in >> the 9.1.14 installation. I'm betting on a foulup somewhere in the data >> dump/restore process. > I'd bet that's mostly due to rescans in the merg

Re: [GENERAL] Performance problem on 2 PG versions on same query

2014-11-05 Thread Tomas Vondra
Dne 5 Listopad 2014, 18:10, Tom Lane napsal(a): > "Tomas Vondra" writes: >> Dne 5 Listopad 2014, 17:31, R??my-Christophe Schermesser napsal(a): >>> We have 2 instances of PG, one in 9.1.1 and 9.1.14. They have the same >>> data, schema, PG configuration, and are almost identical machines, same >>>

Re: [GENERAL] Performance problem on 2 PG versions on same query

2014-11-05 Thread Tom Lane
"Tomas Vondra" writes: > Dne 5 Listopad 2014, 17:31, Rémy-Christophe Schermesser napsal(a): >> We have 2 instances of PG, one in 9.1.1 and 9.1.14. They have the same >> data, schema, PG configuration, and are almost identical machines, same >> number of cores and memory, but different cloud provi

Re: [GENERAL] Performance problem on 2 PG versions on same query

2014-11-05 Thread Tomas Vondra
Hi, Dne 5 Listopad 2014, 17:31, Rémy-Christophe Schermesser napsal(a): > Hi, > > We have 2 instances of PG, one in 9.1.1 and 9.1.14. They have the same > data, schema, PG configuration, and are almost identical machines, same > number of cores and memory, but different cloud provider. The data was

[GENERAL] Performance problem on 2 PG versions on same query

2014-11-05 Thread Rémy-Christophe Schermesser
Hi, We have 2 instances of PG, one in 9.1.1 and 9.1.14. They have the same data, schema, PG configuration, and are almost identical machines, same number of cores and memory, but different cloud provider. The data was transferred with a pg_dump/pg_restore. We ran VACUUM ANALYSE, ANALYSE, and REIND