On Mon, May 8, 2017 at 5:06 PM, Scott Marlowe wrote:
> On Mon, May 8, 2017 at 4:24 PM, Vincent Veyron wrote:
>> On Mon, 8 May 2017 12:48:29 -0600
>> Scott Marlowe wrote:
>>> > -Why are regular queries much faster on this same server?
>>>
>>> That's a whole nother subject. Most likely the faster
On Mon, May 8, 2017 at 3:23 PM, Hans Braxmeier
wrote:
> Hello,
>
>
> on our old server (120 GB RAM) PostgreSQL 9.4.5 was using less than 10 GB of
> ram. On our new server (same system) Postgres 9.4.11 is using up to 40 GB
> Ram. Especially each idle process is consuming 2.4 GB: postgres 30764 8.
On Mon, May 8, 2017 at 4:24 PM, Vincent Veyron wrote:
> On Mon, 8 May 2017 12:48:29 -0600
> Scott Marlowe wrote:
>
> Hi Scott,
>
> Thank you for your input.
>
>>
>> The most likely cause of the difference would be that one server IS
>> honoring fsync requests from the db and the other one isn't.
On Mon, 8 May 2017 12:48:29 -0600
Scott Marlowe wrote:
Hi Scott,
Thank you for your input.
>
> The most likely cause of the difference would be that one server IS
> honoring fsync requests from the db and the other one isn't.
>
> If you run pgbench on both (something simple like pgbench -c 1
Hello,
on our old server (120 GB RAM) PostgreSQL 9.4.5 was using less than 10 GB of
ram. On our new server (same system) Postgres 9.4.11 is using up to 40 GB Ram.
Especially each idle process is consuming 2.4 GB: postgres 30764 8.3 2.4
3358400 3215920 ? Ss 21:58 0:24 postgres: testuser test
On Thu, May 4, 2017 at 8:10 AM, Junaid Malik wrote:
> Hello Guys,
>
> We are facing problem related to performance of Postgres. Indexes are not
> being utilized and Postgres is giving priority to seq scan. I read many
> articles of Postgres performance and found that we need to set the
> randome_p
On Mon, May 8, 2017 at 11:49 AM, Vincent Veyron wrote:
> Hello,
>
> I use two dedicated bare metal servers (Online and Kimsufi). The first one
> takes much longer to execute a procedure that recreates a database by
> truncating its tables, then copying the data from a set of text files; it is
>
Hello,
I use two dedicated bare metal servers (Online and Kimsufi). The first one
takes much longer to execute a procedure that recreates a database by
truncating its tables, then copying the data from a set of text files; it is
however much faster for more typical SELECT and INSERT queries don
