Re: [PERFORM] Hi

2017-08-25 Thread David G. Johnston
On Thu, Aug 24, 2017 at 11:49 PM, Daulat Ram wrote: > Hello, > > > > Would I request to help me on this query. > > > > SELECT 'Inspection Completed' as "ALL Status" ,COUNT(*) as "Number of > Count" FROM ud_document WHERE status = 'Inspection Completed' union SELECT > 'Pending', COUNT(*) FROM ud_d

Re: [PERFORM] Hi

2017-08-24 Thread Daulat Ram
Hello, Would I request to help me on this query. SELECT 'Inspection Completed' as "ALL Status" ,COUNT(*) as "Number of Count" FROM ud_document WHERE status = 'Inspection Completed' union SELECT 'Pending', COUNT(*) FROM ud_document WHERE status = 'Pending' union SELECT 'Approved', COUNT(*) FROM

Re: [PERFORM] Hi

2017-04-13 Thread Glyn Astill
> From: Daulat Ram > To: "pgsql-performance@postgresql.org" > Sent: Thursday, 13 April 2017, 7:25 > Subject: [PERFORM] Hi > > Hello, > > I need to know the criteria behind for settings the work_mem in PostgreSQL, > please give the example also if possible. > > Regards, > Daulat Is there

Re: [PERFORM] Hi- Sleeptime reduction

2010-11-28 Thread Kevin Grittner
aaliya zarrin wrote: > I am new to Postgres. I just wanted to know how to change the sleep > time. > > I want to reduce the sleep time, How much will it affect other > performance issues if sleep time is reduced. I don't know what sleep time you mean. It would probably be best if you started

Re: [PERFORM] Hi!

2004-06-22 Thread Josh Berkus
Janio, > I am trying install the postgresql-7.4.3 simple installation. I did > ./configure command at the postgresql directory source. While the > configuring proccess I receiving the follow message: This is the wrong list for this question. Please try PGSQL-ADMIN. You're much more likely to g