Re: [GENERAL] PostgreSQL Database performance

2016-09-07 Thread Naveed Shaikh
Hello Pradeep, After making the changes have you restarted the cluster? --- Warm Regards, -- Naveed Shaikh On Wed, Sep 7, 2016 at 9:42 AM, Pradeep wrote: > Dear Naveed, > > > > I am using PostgreSQL 9.3 version on Windows .After changing these > parameters, I

Re: [GENERAL] PostgreSQL Database performance

2016-09-06 Thread Naveed Shaikh
gards, -- Naveed Shaikh On Tue, Sep 6, 2016 at 11:22 PM, Ilya Kazakevich < ilya.kazakev...@jetbrains.com> wrote: > Hi. > > > > “shared_buffers” should be set to 30-40% of your system RAM. > > This param controls how much memory database may use. > > > > Please se

Re: [GENERAL] PostgreSQL Database performance

2016-09-06 Thread Naveed Shaikh
reporting user that only runs infrequent but large reports, a specific work_mem setting can be applied to that particular role. e.g. ALTER ROLE reporting SET work_mem = '64MB'; --- Warm Regards, ------ Naveed Shaikh On Sat, Sep 3, 2016 at 9:08 AM, Pradeep wrote: > Dear Team, >

Re: [GENERAL] Socket Connection Authentication

2015-07-08 Thread Naveed Shaikh
by same command: [edb_admin@localhost pg_log]$ /opt/PostgreSQL/9.3/bin/psql -U edb_admin -d edb -p 5444 psql.bin (9.3.1.3) Type "help" for help. edb=> \q [edb_admin@localhost pg_log]$ Hope this helps. Thanks & Regards, Naveed Shaikh On Thu, Jul 9, 2015 at 12:02 PM, basti wrote:

Re: [GENERAL] Memory Utilization Issue

2015-05-20 Thread Naveed Shaikh
/redhat_transparent_hugepage/enabled Here "always" is selected, showing THP are enabled, this needs to be disable with following command: echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled Thanks & Regards, Naveed Shaikh On Wed, May 20, 2015 at 12:55 PM, Sachin Srivastava wrote

Re: [GENERAL] [general] Encrypting/Decryption

2014-11-17 Thread Naveed Shaikh
can be revealed in pg_stat_activity and the system logs via log_statement or via crypto statements that fail with an error. You can follow the below link for more information regarding the encryption options: http://www.postgresql.org/docs/9.3/static/encryption-options.html Hope this helps. Thanks &

Re: [GENERAL] replanning Prepared Statements ?

2013-05-13 Thread Naveed Shaikh
Hi, Please follow the below link for the release notes: http://www.postgresql.org/docs/devel/static/release-9-3.html Hope this helps. -- Thanks & Regards, Naveed Shaikh On Mon, May 13, 2013 at 11:53 PM, Sahagian, David wrote: > I see in the Release Notes for 9