Re: accessing postgres from c++

On Tue, 2022-06-21 at 10:56 +0800, Rino Mardo wrote: > hi. i found odbc.postgresql.org when i was looking for a way to hook up my > c++ project to postgresql server. > installed it and tested to be successful in connection. this was when i had > postgresql > running from a virtualbox vm in

Re: Index creation

Yes, you are right. The presented index usage data is caused by recursive queries, which check the integrity of hierarchical structures from the bottom up. Your explanation has clarified what is going on. Thank you. My experiments with indexes are caused by the appearance of significant variance

accessing postgres from c++

hi. i found odbc.postgresql.org when i was looking for a way to hook up my c++ project to postgresql server. installed it and tested to be successful in connection. this was when i had postgresql running from a virtualbox vm in Ubuntu. i installed a postgresql container using Docker for Windows

Re: A error happend when I am clone the git repository

On Mon, Jun 20, 2022 at 6:48 AM Tom Lane wrote: > Adrian Klaver writes: > > On 6/19/22 20:33, Wen Yi wrote: > >> |[beginnerc@fedora Research]$ git clone > >> ||https://git.postgresql.org/git/postgresql.git > >> | > >> |Cloning into 'postgresql'...|

Re: Index creation

On Mon, Jun 20, 2022 at 1:17 AM Дмитрий Иванов wrote: > Your statement seems obvious to me. But what I see doesn't seem like a > conscious choice. It turns out that it is better to have a lighter > general-purpose index than to strive to create a target covering index for > a certain kind of

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

Thanks for the response. Yes, we have taken care of proper shut down of Postgres before initiating the Upgrade. pg_resetwal - I have read that using pg_resetwal may cause the Database more inconsistent and should be used only as a last resort. Also this problem ( checkpoint related issue -could

AIX and EAGAIN on open()

Hello, a customer running PG on AIX [1] is occasionally seeing "Resource temporarily unavailable" (EAGAIN) returned by open() calls: [1] We have PostgreSQL 11.13 on powerpc-ibm-aix7.2.5.0, compiled by /opt/IBM/xlc/13.1.0/bin/xlc, 64-bit 2022-05-19 03:28:13 CEST:127.0.0.1(63265):x@x:[64029168]: