Re: Issue in PG start

On Friday, May 7, 2021, sivapostg...@yahoo.com wrote: > Hello, > > PG 11.8 in Windows 10 and currently PG 11.11 > > Yesterday [07th May] morning when we switched on the computer and > subsequently PGAdmin, we got the message following message > FATAL: the database system is starting up > > I unin

Re: Issue in PG start

Hello, PG 11.8 in Windows 10 and currently PG 11.11 Yesterday [07th May] morning when we switched on the computer and subsequently PGAdmin, we got the message following messageFATAL: the database system is starting up I uninstalled PG and installed [v 11.11] PG with the same data directory.  Fo

Re: Postgres upgrade 12 - issues with OIDs

On Sat, 2021-05-08 at 13:37 +1000, Venkata B Nagothi wrote: > We are thinking to upgrade to PG 11 instead so that we can avoid doing ALTER > TABLE.. SET WITHOUT OIDs. > Does that makes sense ? Please advise if there are any gotchas ! It makes sense, but it means that you will have to face the sa

Re: Postgres upgrade 12 - issues with OIDs

Missed including pgsql-general group. On Sat, 8 May 2021 at 11:06 am, Venkata B Nagothi wrote: > > > On Wed, 5 May 2021 at 9:22 am, Bruce Momjian wrote: > >> On Wed, May 5, 2021 at 07:49:29AM +1000, Venkata B Nagothi wrote: >> > Hi There, >> > >> > We are attempting to upgrade our Postgres dat

Re: trigger impacting insertion of records

On 5/6/21 11:37 PM, Atul Kumar wrote: hi, The data is inserting using some json sript which is working fine in our stating server and inserting complete records. But in production data insertion is slow and after some insertion it just abort somehow. DB logs are given below: #PostGreSQL: idl

Re: Strange behavior of function date_trunc

David, On 06.05.2021 17:28, David G. Johnston wrote: On Thu, May 6, 2021 at 6:44 AM Tom Lane > wrote: This case is the reason we invented the "stable" attribute to begin with.  People have since misinterpreted it as authorizing caching of function results

Re: Strange behavior of function date_trunc

I will try to summarize what was said before. We have discussed the details of executing STABLE functions in queries of the form: SELECT * FROM t WHERE col oper stable_func(); * Checking STABLE does not guarantee that the function will be executed only once. If the table is scanned sequential

Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1

Hello, Le ven. 7 mai 2021 à 13:55, Devrim Gündüz a écrit : > > Hi, > > On Thu, 2021-05-06 at 16:29 +0200, Thomas Boussekey wrote: > > > > > This morning, a new RPM version has been sent to > > https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/ wit > > h > > version ID 42.0-17.1

Re: Optimizing search query with sorting by creation field

What is your baseline expectation? With what size of db table, what query should take how much time How much server resources can be used? If this seems to be a timeseries db, Are the rows append only and random insertion order ? You are create partitions based on time and sub partitions on som

Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1

Hi, On Thu, 2021-05-06 at 16:29 +0200, Thomas Boussekey wrote: > > > This morning, a new RPM version has been sent to > https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/ wit > h > version ID 42.0-17.1 > We had to adapt our tooling to comply with this new repository file. > > We

Re: idle_in_transaction_session_timeout

- Mensagem original - > De: "Atul Kumar" > Para: "pgsql-general" > Enviadas: Sexta-feira, 7 de maio de 2021 3:34:44 > Assunto: idle_in_transaction_session_timeout > Hi, > I have postgres 9.5 version running on my machine. > When I am trying to find out the parameter > idle_in_transac