Re: No yum repo for CentOS 7 and postgres 16?

On 10/5/23 15:46, David G. Johnston wrote: On Thursday, October 5, 2023, Jeff Ross wrote: Hi all, CentOS 7 isn't quite dead yet but it appears that CentOS7 is not included in the new yum repo file including 16. Do those of us still on CentOS 7 wanting to upgrade to 16 now hav

No yum repo for CentOS 7 and postgres 16?

On Thursday, October 5, 2023, Jeff Ross wrote: > Hi all, > > CentOS 7 isn't quite dead yet but it appears that CentOS7 is not included > in the new yum repo file including 16. > > Do those of us still on CentOS 7 wanting to upgrade to 16 now have to > build from source? > > https://yum.postgresq

No yum repo for CentOS 7 and postgres 16?

Hi all, CentOS 7 isn't quite dead yet but it appears that CentOS7 is not included in the new yum repo file including 16. Here's a bit from the latest repo file: Name    : pgdg-redhat-repo Version : 42.0 Release : 35PGDG Architecture: noarch Install Date: (not installed) Group 

Re: Ask about Foreign Table Plug-in on Windows Server.

On Thu, 2023-10-05 at 10:39 +, Anuwat Sagulmontreechai wrote: > Our customer install PG on Windows Server 2022 and need to use Foreign Table > to connect > to SQL Server on WS2022 too, so we tried to find the plug-in but > unfortunately we found > only Linux version. Could you please advise u

Re: Multiple inserts with two levels of foreign keys

But honestly, the amount of text duplication hurts my "inner programmer".  And it would have to be generated dynamically, since you don't know how many crops were delivered.  #shudder On 10/5/23 09:33, Dow Drake wrote: Yes! Thanks, Alvaro! This is exactly the pattern I was trying to work out

Ask about Foreign Table Plug-in on Windows Server.

Hi PG Support Team, Our customer install PG on Windows Server 2022 and need to use Foreign Table to connect to SQL Server on WS2022 too, so we tried to find the plug-in but unfortunately we found only Linux version. Could you please advise us? Thank you in advance for your help. Best Regards,

How to make a map in pg kernel?

Hi, I’m writing some kernel codes in pg15, and now I need to make a map struct, I know c-lang doesn’t support this, so does pg support an internal struct? Hopefully your replies.

Re: Multiple inserts with two levels of foreign keys

Yes! Thanks, Alvaro! This is exactly the pattern I was trying to work out! This community is awesome! > On Oct 5, 2023, at 2:39 AM, Alvaro Herrera wrote: > > On 2023-Oct-04, Dow Drake wrote: > >> I want to insert a farm record, then insert two crops associated with that >> farm, then inser

Re: Index scan is not pushed down to union all subquery

On Thu, Oct 5, 2023 at 12:30 PM Marian Wendt wrote: > > With an INNER JOIN, both tables must be fully checked/matched (check using EXPLAIN ANALYSIS -> HashJoin), so the index cannot be used here. > Sorry, didn't consider the WITH part. Please share the detailed query plan for more info. Now, it r

Re: pgBackRest for a 50 TB database

Greetings, On Thu, Oct 5, 2023 at 03:10 Abhishek Bhola wrote: > Here is the update with compress-type=zst in the config file > Process-max is still 30. *But it longer than before, around 27 hours 50 > mins* > > full backup: 20231004-130621F > timestamp start/stop: 2023-10-04 13:06:21

Re: Gradual migration from integer to bigint?

On Sat, 30 Sept 2023, 23:37 Tom Lane, wrote: > > I think what you're asking for is a scheme whereby some rows in a > table have datatype X in a particular column while other rows in > the very same physical table have datatype Y in the same column. > An alternative for NOT NULL columns would be

Re: Index scan is not pushed down to union all subquery

On Thu, Oct 5, 2023 at 11:35 AM Marian Wendt wrote: > With an INNER JOIN, both tables must be fully checked/matched (check using > EXPLAIN ANALYSIS -> HashJoin), so the index cannot be used here. > Sorry, didn't consider the WITH part. Please share the detailed query > plan for more info. > > The

Re: Multiple inserts with two levels of foreign keys

On 2023-Oct-04, Dow Drake wrote: > I want to insert a farm record, then insert two crops associated with that > farm, then insert two deliveries for each of the the two crops so that in > the end, my tables look like this: If I understand you correctly, for each table you want one CTE with the da

Re: Index scan is not pushed down to union all subquery

Hi, Is it intended that indexes are not pushed down to union all subqueries if even a single select contains a where clause? Is this just not implemented, is it impossible to implement or am I doing something wrong? The following query does a SeqScan for "bikes" and "cars" tables even though Ind

Re: Index scan is not pushed down to union all subquery

Hi, Is it intended that indexes are not pushed down to union all subqueries if even a single select contains a where clause? Is this just not implemented, is it impossible to implement or am I doing something wrong? The following query does a SeqScan for "bikes" and "cars" tables even though Ind

Re: Index scan is not pushed down to union all subquery

Hi, Is it intended that indexes are not pushed down to union all subqueries if even a single select contains a where clause? Is this just not implemented, is it impossible to implement or am I doing something wrong? The following query does a SeqScan for "bikes" and "cars" tables even though Ind

Re: pgBackRest for a 50 TB database

Hi Stephen Here is the update with compress-type=zst in the config file Process-max is still 30. *But it longer than before, around 27 hours 50 mins* full backup: 20231004-130621F timestamp start/stop: 2023-10-04 13:06:21+09 / 2023-10-05 15:56:03+09 wal start/stop: 000