shared memory.
My DB size is not very big 169GB.
Anyone know how can I get rid of DB crash ?
Thanks,
Dzmitry
I don't think it's the case. I am using newrelic for monitoring my DB
servers(I have one master and 2 slaves - all use the same configuration) -
memory is not going above 12.5GB, so I have a good reserve, also I don't
see any swapping there :(
Thanks,
Dzmitry
On 8/19/13 11:3
Do you mean postgres log file(in postgres.conf)
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_min_messages = warning
Or /var/log/messages ? Because I haven't this file :(
Thanks,
Dzmitry
On 8/19/13 12:26 PM, "Albe Laurenz" wrote:
>Dzmitry wrote:
>&
Shhmax - 13223870464
Shmall - 4194304
Thanks,
Dzmitry
On 8/19/13 1:05 PM, "Albe Laurenz" wrote:
>>> Dzmitry wrote:
>>>> On 8/19/13 11:36 AM, "Stéphane Schildknecht"
>>>> wrote:
>>>>> Le 19/08/2013 10:07, Dzmitry a écrit :
&
I am already using pgpool, is it bad have 550 connections, is it much ?
Thank you guys for all your help.
Thanks,
Dzmitry
On 8/19/13 4:43 PM, "Scott Ribe" wrote:
>On Aug 19, 2013, at 7:23 AM, Stéphane Schildknecht
> wrote:
>
>> As Laurenz said, you should hav
Yes- I need so many threads, every night I need load jobs from xml to DB.
I need do it as fast as I can, currently it take 4h to load all of
them(around 100 jobs).
CPU/IO wait/percent is about 25%. Do you know how can I check other params
related to IO wait ?
Thanks,
Dzmitry
On 8/19/13
when killed. But
threads performing background jobs - it means they running always, so I
keep connection always open.
Thanks,
Dzmitry
On 8/19/13 6:17 PM, "Scott Ribe" wrote:
>On Aug 19, 2013, at 9:07 AM, Dzmitry wrote:
>
>> Yes- I need so many threads...
>
>T
keep connections too).
Part that do a lot of writes(that update jobs from xml feed every night) -
have 40 threads and keep 40 connections.
Thanks,
Dzmitry
On 8/19/13 6:26 PM, "Scott Ribe" wrote:
>On Aug 19, 2013, at 9:22 AM, Dzmitry wrote:
>
>> I am using pgpool to
Ok,thank you, it's a good point. Need to review & make fixes with what I
have.
Thanks,
Dzmitry
On 8/24/13 6:14 PM, "Scott Ribe" wrote:
>On Aug 19, 2013, at 9:55 AM, Dzmitry wrote:
>
>> No, I am not using pgbouncer, I am using pgpool.
>>
>> T
ver my data from the
"data" directory?
-
Best regards,
Dzmitry Lazerka
Phone: +375 (29) 502-9579
GTalk: dlaze...@gmail.com
Skype: dzmitry.lazerka
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
10 matches
Mail list logo
