Re: [rt-users] Postgresql 4.4.1 slow queries?

2016-10-05 Thread Joel Bergmark
-users [mailto:rt-users-boun...@lists.bestpractical.com] För Joel Bergmark Skickat: den 28 september 2016 16:58 Till: rt-users@lists.bestpractical.com Ämne: Re: [rt-users] Postgresql 4.4.1 slow queries? Hahaha, i used mysql syntax first "use rt4;" of course that messed it up :) Below is the

Re: [rt-users] Postgresql 4.4.1 slow queries?

2016-09-28 Thread Joel Bergmark
s: 1615 Total runtime: 371.982 ms (27 rows) Regards, Joel Från: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] För Joel Bergmark Skickat: den 27 september 2016 09:53 Till: rt-users@lists.bestpractical.com Ämne: [rt-users] Postgresql 4.4.1 slow queries? Hi, After upgrading to version 4.4.1 i have n

Re: [rt-users] Postgresql 4.4.1 slow queries?

2016-09-28 Thread Emmanuel Lacour
Le 28/09/2016 à 11:12, Joel Bergmark a écrit : > Hi! > > This is the output from explain: > > postgres=# EXPLAIN SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL > ACL_3 JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN > CachedGroupMembers CachedGroupMembers_2 ON ( Cached

Re: [rt-users] Postgresql 4.4.1 slow queries?

2016-09-28 Thread Nilesh
FROM Users main CROSS JOIN AC... > > I have looked for more queries that takes time and its always this query > that generates the slow behavior, but seemingly the query itself seems fine > "users" exists in db, but then again obviously postgres has issues with > something here

Re: [rt-users] Postgresql 4.4.1 slow queries?

2016-09-28 Thread Joel Bergmark
ractical.com] För Nilesh Skickat: den 27 september 2016 17:36 Till: rt-users@lists.bestpractical.com Ämne: Re: [rt-users] Postgresql 4.4.1 slow queries? On Tue, 2016-09-27 at 07:52 +, Joel Bergmark wrote: > Hi, >   > After upgrading to version 4.4.1 i have noticed that the SQL-queries >

Re: [rt-users] Postgresql 4.4.1 slow queries?

2016-09-27 Thread Nilesh
On Tue, 2016-09-27 at 07:52 +, Joel Bergmark wrote: > Hi, >   > After upgrading to version 4.4.1 i have noticed that the SQL-queries takes > significant longer time to produce a result, on average on my system, running > Ubuntu 14.04 LTS, Postgres 9.3, Apache with perlmod. 8 gigram and plenty o

[rt-users] Postgresql 4.4.1 slow queries?

2016-09-27 Thread Joel Bergmark
Hi, After upgrading to version 4.4.1 i have noticed that the SQL-queries takes significant longer time to produce a result, on average on my system, running Ubuntu 14.04 LTS, Postgres 9.3, Apache with perlmod. 8 gigram and plenty of CPU in a vmware cluster on SSD:s (likely not a hardware issue)