Re: Postgresql error : PANIC: could not locate a valid checkpoint record

2022-06-26 Thread Michael Paquier
On Fri, Jun 24, 2022 at 01:03:57PM +, Mahendrakar, Prabhakar - Dell Team wrote: > Is it possible to explicitly issue a checkpoint before we move on to > the pg_upgrade command? > so that in the circumstances of the Upgrade issues (like PANIC: > could not locate a valid checkpoint record), we

Re: How can I set up Postgres to use given amount of RAM?

2022-06-26 Thread Mladen Gogala
On 6/26/22 14:40, W.P. wrote: Question in topic: "How can I set up Postgres to use given amount of RAM?" I have now laptop with 8GB of RAM, i can see Linux uses no more than 2-3GB. So my question is how to FORCE PostgreSQL use let's say 2-4Ghow to B of RAM for caching tablesĀ  I run queries

Re: How can I set up Postgres to use given amount of RAM?

2022-06-26 Thread Zahid Rahman
https://severalnines.com/database-blog/architecture-and-tuning-memory-postgresql-databases On Sun, 26 Jun 2022, 11:40 pm W.P., wrote: > Question in topic: > > "How can I set up Postgres to use given amount of RAM?" > > I have now laptop with 8GB of RAM, i can see Linux uses no more than 2-3GB.

How can I set up Postgres to use given amount of RAM?

2022-06-26 Thread W.P.
Question in topic: "How can I set up Postgres to use given amount of RAM?" I have now laptop with 8GB of RAM, i can see Linux uses no more than 2-3GB. So my question is how to FORCE PostgreSQL use let's say 2-4Ghow to B of RAM for caching tablesĀ  I run queries on? As I can see disk actity

Re: Question about attention to pgsql-hack...@lists.postgresql.org

2022-06-26 Thread Mladen Gogala
On 6/26/22 09:15, Julien Rouhaud wrote: On top of that OP has already received a lot of answers in the past, it's just that since no one wants to take care of a whole non trivial project for free the answer is never what OP wants. On top of that, most of the functionality can be obtained by

Re: Question about attention to pgsql-hack...@lists.postgresql.org

2022-06-26 Thread Julien Rouhaud
On Sun, Jun 26, 2022 at 01:22:49PM +0200, Laurenz Albe wrote: > On Sun, 2022-06-26 at 10:37 +, A Z wrote: > > I have successfully sent an (updated) email list message to > > > > pgsql-hack...@lists.postgresql.org > > > > which can be viewed in the archive here: > > > >

Re: Question about attention to pgsql-hack...@lists.postgresql.org

2022-06-26 Thread Laurenz Albe
On Sun, 2022-06-26 at 10:37 +, A Z wrote: > I have successfully sent an (updated) email list message to > > pgsql-hack...@lists.postgresql.org > > which can be viewed in the archive here: > >

Question about attention to pgsql-hack...@lists.postgresql.org

2022-06-26 Thread A Z
Dear pgsql-general, I have successfully sent an (updated) email list message to pgsql-hack...@lists.postgresql.org which can be viewed in the archive here: