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
0.01 |0.01 | 1006 | DELETE FROM t_dirs WHERE iname=$1 AND
iparent=$2
0.00 |0.00 | 2004 | COMMI
Tigran.
- Original Message -
> From: "Mkrtchyan, Tigran"
> To: "pgsql-performance"
> Sent: Sunday, July 5, 2015 1:10:51 PM
&
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