On 11/24/2016 09:59 AM, Moreno Andreo wrote:
Hi Adrian,
First of all: now I've seen that not all fields touched by WHERE
Aah, I get it now. You are refreshing forms every 60 seconds over 350
users each with their own database. Actually worse then that as there
is user overlap over
Hi Adrian,
First of all: now I've seen that not all fields touched by WHERE
clauses in queries are indexed. Time to try some indices and EXPLAIN a
bit
(I must be blind... I've checked it multiple times)
Scroll down for the rest of the thread.
Il 23/11/2016 16:59, Adrian Klaver
On 11/23/2016 05:24 AM, Moreno Andreo wrote:
Il 15/11/2016 18:19, Adrian Klaver ha scritto:
On 11/15/2016 07:39 AM, Moreno Andreo wrote:
Sorry for late reply... i'm in some quite rough days
Il 08/11/2016 21:28, Adrian Klaver ha scritto:
On 11/08/2016 12:13 PM, Moreno Andreo wrote:
[...]
Il 15/11/2016 18:19, Adrian Klaver ha scritto:
On 11/15/2016 07:39 AM, Moreno Andreo wrote:
Sorry for late reply... i'm in some quite rough days
Il 08/11/2016 21:28, Adrian Klaver ha scritto:
On 11/08/2016 12:13 PM, Moreno Andreo wrote:
[...]
In your experience, would this approach help
On 11/15/2016 07:39 AM, Moreno Andreo wrote:
Sorry for late reply... i'm in some quite rough days
Il 08/11/2016 21:28, Adrian Klaver ha scritto:
On 11/08/2016 12:13 PM, Moreno Andreo wrote:
[...]
In your experience, would this approach help me lower server load?
Are there any other
Sorry for late reply... i'm in some quite rough days
Il 08/11/2016 21:28, Adrian Klaver ha scritto:
On 11/08/2016 12:13 PM, Moreno Andreo wrote:
[...]
In your experience, would this approach help me lower server load?
Are there any other approach I can try?
Instead of pushing why not
On 11/08/2016 12:13 PM, Moreno Andreo wrote:
Hi,
I'm checking if there's a best way to obtain stastistics based on my
database tables
Here's the scenario.
First of all, technical details:
- Postgresql 9.1, Ubuntu 12 on a 4 core, 32 GB machine with 600 GB disk
migrating to Postgresql 9.5.3,
Hi,
I'm checking if there's a best way to obtain stastistics based on
my database tables
Here's the scenario.
First of all, technical details:
- Postgresql 9.1, Ubuntu 12 on a 4 core, 32 GB machine with 600 GB disk
migrating to Postgresql 9.5.3, Debian 8 on a 8-core, 52 GB machine with
2