On Jul 6, 2015 18:45, Josh Berkus wrote:
>
> On 07/05/2015 10:16 AM, Mkrtchyan, Tigran wrote:
> > 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 per
On 07/05/2015 10:16 AM, Mkrtchyan, Tigran wrote:
> 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.
-
> From: "Tom Lane"
> To: "Andres Freund"
> Cc: "Mkrtchyan, Tigran" , "pgsql-performance"
>
> Sent: Sunday, July 5, 2015 4:33:25 PM
> Subject: Re: [PERFORM] 9.5alpha1 vs 9.4
> Andres Freund writes:
>> On 2015-07-05 13:10
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
