-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
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 (
o:rt-users-boun...@lists.bestpractical.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,
> >
> >
Ä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
> takes significant longer time to produce a result, on average on my
> system, running Ubu
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
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