[GENERAL] PostgreSQL Database performance

2016-09-06 Thread Pradeep
= 110100kB maintenance_work_mem = 2GB checkpoint_segments = 64 checkpoint_completion_target = 0.9 wal_buffers = 16MB default_statistics_target = 100 Thanks & Regards Pradeep Kanth

Re: [GENERAL] PostgreSQL Database performance

2016-09-07 Thread Pradeep
. So kindly let me ,whether it will impact the RAM utilization or not? Thanks & Regards Pradeep Kanth Ext : 3026 From: Naveed Shaikh [mailto:naveed.sha...@enterprisedb.com] Sent: 06 September, 2016 11:22 PM To: Pradeep Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Postgr

Re: [GENERAL] Curious why planner can't handle NOT IN

2013-05-03 Thread pradeep singh
On May 3, 2013 12:15 PM, "Yang Zhang" wrote: > I have an `account` table with 5.3M rows, with primary key `id` of > type `text` (and 600+ columns if that matters). > > I'm trying to create a `newaccount` table with the same schema but > 600k newly imported rows, then insert all the old rows for w

[GENERAL] after insert trigger hangs

2006-03-17 Thread pradeep singh
** table it should add the bitset of the that role from role_list table into user_list table. but this trigger hangs at the update command. anybody have any suggestion ? pradeep singh __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the bes

Re: [GENERAL] Aggregate functions not allowed in WHERE clause

2006-06-12 Thread pradeep singh
in the SELECT statement. pradeep --- Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Mon, Jun 12, 2006 at 09:00:33PM -0500, Ricardo > Naranjo Faccini wrote: > > SELECT claim_id > > FROM logs > > WHERE ( > > sum(logs.invoices) > 0 > > OR > &g