-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
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
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
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
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
>
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
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)