Answer / Om Prakash Bharti

In PostgreSQL, you can allocate memory by adjusting shared_buffers and effective_cache_size parameters in postgresql.conf file.n"shared_buffers = <value>
effective_cache_size = <value>"nYou can also use the RELOAD or SIGHUP command to make changes take effect.

What is connection pooling in postgresql?

1 Answers  

---

What is join and how many types of joins?

1 Answers  

---

Which version of postgresql should I use?

1 Answers  

---

How do I view blob data?

1 Answers  

---

What is postgres xc?

1 Answers  

---

How do I enable remote access to postgresql database?

1 Answers  

---

What is the command that can be used to allocate memory in postgreSQL?

1 Answers  

---

What is postgres vacuum?

1 Answers  

---

How do I connect to postgresql remotely?

1 Answers  

---

what is software?

1 Answers  

---

How to start the database server?

1 Answers  

---

Is postgres a database?

1 Answers  

---