Re: PostgreSQL 14.4 ERROR: out of memory issues

2022-07-14 Thread Aleš Zelený
Dne čt 14. 7. 2022 23:11 uživatel Tomas Vondra < tomas.von...@enterprisedb.com> napsal: > > > On 7/14/22 21:25, Aleš Zelený wrote: > > > > st 13. 7. 2022 v 2:20 odesílatel Michael Paquier > > napsal: > > > > On Mon, Jul 11, 2022 at 10:50:23AM +0200, Aleš Zelený

Re: PostgreSQL 14.4 ERROR: out of memory issues

2022-07-14 Thread Tomas Vondra
On 7/14/22 21:25, Aleš Zelený wrote: > > st 13. 7. 2022 v 2:20 odesílatel Michael Paquier > napsal: > > On Mon, Jul 11, 2022 at 10:50:23AM +0200, Aleš Zelený wrote: > > So far, it has happened three times (during a single week) from > the 14.3 -> >

Re: Oracle to Postgress Migration

2022-07-14 Thread DAVID ROTH
Looks good. Thanks > On 07/14/2022 3:10 PM Bruce Momjian wrote: > > > On Thu, Jul 14, 2022 at 03:06:58PM -0400, DAVID ROTH wrote: > > Has anything been published on Oracle to Postgress migration. > > > > I am finding plenty of information about schema migration but, > > I think this is the

Re: PostgreSQL 14.4 ERROR: out of memory issues

2022-07-14 Thread Pavel Stehule
čt 14. 7. 2022 v 21:26 odesílatel Aleš Zelený napsal: > > st 13. 7. 2022 v 2:20 odesílatel Michael Paquier > napsal: > >> On Mon, Jul 11, 2022 at 10:50:23AM +0200, Aleš Zelený wrote: >> > So far, it has happened three times (during a single week) from the >> 14.3 -> >> > 14.4 upgrade, before

Re: PostgreSQL 14.4 ERROR: out of memory issues

2022-07-14 Thread Aleš Zelený
st 13. 7. 2022 v 2:20 odesílatel Michael Paquier napsal: > On Mon, Jul 11, 2022 at 10:50:23AM +0200, Aleš Zelený wrote: > > So far, it has happened three times (during a single week) from the 14.3 > -> > > 14.4 upgrade, before 14.4 we haven't suffered from such an issue. > > > > Questions: > >

Re: Oracle to Postgress Migration

2022-07-14 Thread Bruce Momjian
On Thu, Jul 14, 2022 at 03:06:58PM -0400, DAVID ROTH wrote: > Has anything been published on Oracle to Postgress migration. > > I am finding plenty of information about schema migration but, > I think this is the easy part. > I have a a tremendous amount of SQL and PL/SQL code that needs to be >

Oracle to Postgress Migration

2022-07-14 Thread DAVID ROTH
Has anything been published on Oracle to Postgress migration. I am finding plenty of information about schema migration but, I think this is the easy part. I have a a tremendous amount of SQL and PL/SQL code that needs to be translated. I know Oracle "packages" will not translate. DECODE is

Re: first order by then partition by x < a fixed value.

2022-07-14 Thread Frank Streitzig
Am Thu, Jul 14, 2022 at 01:23:55PM +0530 schrieb jian he: > This question (https://stackoverflow.com/q/72975669/15603477) is fun. > DB fiddle link: > https://dbfiddle.uk/?rdbms=postgres_14=36d685ad463831877ae70361be2cfa3b > > account > size idname 1001 John 2002 Mary 3003

first order by then partition by x < a fixed value.

2022-07-14 Thread jian he
This question (https://stackoverflow.com/q/72975669/15603477) is fun. DB fiddle link: https://dbfiddle.uk/?rdbms=postgres_14=36d685ad463831877ae70361be2cfa3b account size idname 1001 John 2002 Mary 3003 Jane 4004 Anne1005 Mike 6006 Joanne Then