Thanks for the hin. My bad. The backup db and 9.5 had a different type on
one of the foreign-key constrains char(36) vs varchar(36).
The schema was screwed couple of days ago, byt performance numbers I checked
only
after migration to 9.5.
Sorry for the noise.
Tigran.
- Original Message --
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Guys can anyone please explain or point me to a link where i
> can understand this output for pgbouncer. What does each column of this table
> mean?
>
> pgbouncer=# show mem;
(Please do not post to more than one mailing list at a time). It
Andres Freund writes:
> On 2015-07-05 13:10:51 +0200, Mkrtchyan, Tigran wrote:
>> today I have update my test system to 9.5alpha1.
>> Most of the operations are ok, except delete.
>> I get ~1000 times slower!
>> 255.88 | 566.11 | 452 | DELETE FROM t_inodes WHERE ipnfsid=$1 AND
>> inli
Hi,
On 2015-07-05 13:10:51 +0200, Mkrtchyan, Tigran wrote:
> today I have update my test system to 9.5alpha1.
> Most of the operations are ok, except delete.
> I get ~1000 times slower!
> 255.88 | 566.11 | 452 | DELETE FROM t_inodes WHERE ipnfsid=$1
> AND inlink = ?
That certain
And this is with 9.4 in the same hardware ( restored from backup)
0.35 |0.35 | 1002 | DELETE FROM t_inodes WHERE ipnfsid=$1
AND inlink = ?
0.16 |0.16 | 1006 | insert into t_dirs (iparent, iname,
ipnfsid) (select $1 as iparent, $2 as iname, $3 as ipnfsid
Hi,
today I have update my test system to 9.5alpha1.
Most of the operations are ok, except delete.
I get ~1000 times slower!
chimera=# SELECT
(total_time / 1000 )::numeric(10,2) as total_secs,
(total_time/calls)::numeric(10,2) as average_time_ms, calls,
query
FROM pg_stat_statements where