Re: [PERFORM] query performance issue

please find the EXPLAIN ANALYZE output. On Wed, Nov 15, 2017 at 3:13 PM, Pavel Stehule wrote: > Hi > > please send EXPLAIN ANALYZE output. > > Regards > > Pavel > > 2017-11-15 10:33 GMT+01:00 Samir Magar : > >> Hello, >> I am having performance iss

[PERFORM] query performance issue

effective_cache_size = 12 GB we are doing the vacuum/analyze regularly on the database. attached is the query with its explain plan. Thanks, Samir Magar query: SELECT DISTINCT DLR_QLFY.DLR_QLFY_ID as DLR_QLFY_ID, NMQ_REQ.GRACE_PRD as GRACE_PRD, NMQ_REQ.HIDE_PRG_FLG as HIDE_PRG_FLG

[PERFORM] out of range error while restore using pgdump

is out of range for type double precision CONTEXT: COPY tcb_test, line 3932596, column va_odometro: "5.40593839802118076e-315" Could you please help us how can we avoid solve this error? postgres version 9.5 OS: Red hat 7.1 Thanks, Samir Magar

Re: [PERFORM] pg_basebackup running slow

What is the settings for max_wal_sender? you can try increasing this parameter to improve backup performance. Thanks, Samir Magar On Fri, Oct 14, 2016 at 6:05 PM, Swapnil Vaze wrote: > Hello, > > > > We are using postgresql 9.2 on redhat linux instance over openstack cloud. &

Fwd: [PERFORM] Delay in converting logs from ready state to done state

*Hello Julien,* *Thank you for your prompt response!* *we have changed the checkpoint_segment to 170 and use pigz for the pg_xlog compress.* *It is working very well now.* *Thanks again!!* *Regards,* *Samir Magar* On Wed, Oct 12, 2016 at 11:33 AM, Julien Rouhaud wrote: > On 12/10/2016 07

[PERFORM] Delay in converting logs from ready state to done state

int_segments = 3 checkpoint_timeout = 5min log_checkpoints = on archive_timeout = 60 Thanks, Samir Magar

Re: [PERFORM] How to reduce IOWAIT and CPU idle time?

performance. Thanks, Samir Magar On Sun, Sep 11, 2016 at 7:16 AM, Jeff Janes wrote: > On Sat, Sep 10, 2016 at 3:49 AM, Samir Magar > wrote: > >> Hello, >> >> >> My Application has normally 25 to 30 connections and it is doing lot of >> insert/update/delete o

Re: [PERFORM] How to reduce IOWAIT and CPU idle time?

. Still it is not helping. Can you think of any other setting which i should enable? Thanks, Samir Magar On Sun, Sep 11, 2016 at 6:04 AM, Venkata B Nagothi wrote: > > On Sat, Sep 10, 2016 at 8:49 PM, Samir Magar > wrote: > >> Hello, >> >> >> My Application has nor

[PERFORM] How to reduce IOWAIT and CPU idle time?

.el7.x86_64 #1 SMP Fri May 15 21:38:46 EDT 2015 x86_64 x86_64 x86_64 GNU/Linux database version: postgrsql 9.2.13 community. Thanks, Samir Magar