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

[PERFORM] Hi

2017-04-12 Thread Daulat Ram
Hello, I need to know the criteria behind for settings the work_mem in PostgreSQL, please give the example also if possible. Regards, Daulat

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

[PERFORM] Hi- Sleeptime reduction

2010-11-28 Thread aaliya zarrin
Hi all, 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. Plz help. I apologize if I am sending mail to wrong contact. Kindly suggest the correct contact details if

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

[PERFORM] Hi!

2004-06-20 Thread Janio Rosa da Silva
Hi,   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:   checking for tar... /bin/tarchecking for strip... stripchecking whether it is possible to strip li