Re: DB size

2021-04-26 Thread Laurenz Albe
On Mon, 2021-04-26 at 16:45 -0400, Alvaro Herrera wrote: > I would guess that there are leftover files because of those crashes you > mentioned. You can probably look for files in the database subdir in > the data directory that do not appear in the pg_class.relfilenode > listing for the database.

Re: DB size

2021-04-26 Thread Guillaume Lelarge
Hi, Le lun. 26 avr. 2021 à 22:59, a écrit : > > - Mensagem original - > > De: "Alvaro Herrera" > > Para: "luis.roberto" > > Cc: "pgsql-general" > > Enviadas: Segunda-feira, 26 de abril de 2021 17:45:34 > > Assunto: Re: DB size > > > I would guess that there are leftover files because

Re: -1/0 virtualtransaction

2021-04-26 Thread Laurenz Albe
On Mon, 2021-04-26 at 17:45 -0400, Mike Beachy wrote: > Does anyone have any pointers on what a virtualtransaction of '-1/0' means? > > I'm using SSI and an example is > > locktype | database | relation | page | tuple | virtualxid | > transactionid | classid | objid | objsubid | virtualtran

About to find all foreign tables are being used by sproc and view and function

2021-04-26 Thread Durgamahesh Manne
Hi Respected Team I need to find foreign tables used in function and sproc and view How to find all foreign tables being used by sproc,view,function Thanks & Regards Durgamahesh Manne

Re: -1/0 virtualtransaction

2021-04-26 Thread Mike Beachy
On Mon, Apr 26, 2021 at 6:16 PM Tom Lane wrote: > Hmm, that's an invalid VXID, which would ordinarily mean that nothing > is holding the lock. There is a passing mention in mvcc.sgml that > SIRead locks sometimes need to be held past transaction end, so maybe > what you're looking at is such a l

Re: -1/0 virtualtransaction

2021-04-26 Thread Tom Lane
Mike Beachy writes: > Does anyone have any pointers on what a virtualtransaction of '-1/0' means? > I'm using SSI and an example is > locktype | database | relation | page | tuple | virtualxid | > transactionid | classid | objid | objsubid | virtualtransaction | pid | > mode| granted | f

-1/0 virtualtransaction

2021-04-26 Thread Mike Beachy
Hi - Does anyone have any pointers on what a virtualtransaction of '-1/0' means? I'm using SSI and an example is locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode| granted | fastpath --+-

Re: DB size

2021-04-26 Thread luis . roberto
- Mensagem original - > De: "Alvaro Herrera" > Para: "luis.roberto" > Cc: "pgsql-general" > Enviadas: Segunda-feira, 26 de abril de 2021 17:45:34 > Assunto: Re: DB size > I would guess that there are leftover files because of those crashes you > mentioned. You can probably look for fi

Re: DB size

2021-04-26 Thread luis . roberto
- Mensagem original - > De: "Josef Šimánek" > Para: "luis.roberto" > Cc: "pgsql-general" > Enviadas: Segunda-feira, 26 de abril de 2021 17:40:05 > Assunto: Re: DB size > Do you have any indexes in mydb database? Yes, I do. I believe pg_total_relation_size accounts for these. These

Re: DB size

2021-04-26 Thread Alvaro Herrera
On 2021-Apr-26, luis.robe...@siscobra.com.br wrote: > SELECT sum(pg_total_relation_size(relid)), > pg_size_pretty(sum(pg_total_relation_size(relid))) > FROM pg_catalog.pg_stat_all_tables > > > sum |pg_size_pretty| > +--+ > 518549716992|483 GB

Re: DB size

2021-04-26 Thread Josef Šimánek
po 26. 4. 2021 v 22:25 odesílatel napsal: > > Hi! > > I've looked around, but could only find very old answers to this question, > and maybe it changed since then... > > I'm struggling to identify the cause of the difference in size between the > sum of all relations (via pg_total_relation_size

DB size

2021-04-26 Thread luis . roberto
Hi! I've looked around, but could only find very old answers to this question, and maybe it changed since then... I'm struggling to identify the cause of the difference in size between the sum of all relations (via pg_total_relation_size) and pg_database_size: SELECT sum(pg_total_relation_s

Re: Invalid byte sequence when importing Oracle BLOB

2021-04-26 Thread Laurenz Albe
On Mon, 2021-04-26 at 06:49 -0500, Ron wrote: > The source is an Oracle 12 db with this encoding: > NLS_LANG = AMERICAN_AMERICA.AL32UTF8 > NLS_NCHAR = AL32UTF8 > > The destination is an (RDS) Postgresql 12.5 with encoding UTF8, and is being > loaded through COPY commands generated by ora2pg. > >

Re: Invalid byte sequence when importing Oracle BLOB

2021-04-26 Thread Ron
On 4/26/21 7:58 AM, Peter J. Holzer wrote: On 2021-04-26 07:45:26 -0500, Ron wrote: On 4/26/21 7:32 AM, Peter J. Holzer wrote: On 2021-04-26 06:49:18 -0500, Ron wrote: The destination is an (RDS) Postgresql 12.5 with encoding UTF8, and is being loaded through COPY commands generated by ora2pg.

Re: impact of version upgrade on fts

2021-04-26 Thread Malik Rumi
Thanks, I'll check it out. *“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”* On Sun, Apr 25, 2021 at 2:32 PM Robert Treat wrote: > On Sun, Apr 25, 2021 at 11:27 AM Adrian Klaver > wrote: > > > > On 4/25/21 5:28 AM, Malik Rumi wrote: > > > Greet

Re: Invalid byte sequence when importing Oracle BLOB

2021-04-26 Thread Matthias Apitz
El día lunes, abril 26, 2021 a las 06:49:18a. m. -0500, Ron escribió: > Hi, > > The source is an Oracle 12 db with this encoding: > NLS_LANG = AMERICAN_AMERICA.AL32UTF8 > NLS_NCHAR = AL32UTF8 > > The destination is an (RDS) Postgresql 12.5 with encoding UTF8, and is being > loaded through COPY c

Re: Invalid byte sequence when importing Oracle BLOB

2021-04-26 Thread Peter J. Holzer
On 2021-04-26 07:45:26 -0500, Ron wrote: > On 4/26/21 7:32 AM, Peter J. Holzer wrote: > > On 2021-04-26 06:49:18 -0500, Ron wrote: > > > The destination is an (RDS) Postgresql 12.5 with encoding UTF8, and is > > > being > > > loaded through COPY commands generated by ora2pg. > > > > > > The sourc

Re: Invalid byte sequence when importing Oracle BLOB

2021-04-26 Thread Ron
On 4/26/21 7:32 AM, Peter J. Holzer wrote: On 2021-04-26 06:49:18 -0500, Ron wrote: The destination is an (RDS) Postgresql 12.5 with encoding UTF8, and is being loaded through COPY commands generated by ora2pg. The source table has a BLOB column (I think they are scanned images) which I'm loadi

Re: Invalid byte sequence when importing Oracle BLOB

2021-04-26 Thread Peter J. Holzer
On 2021-04-26 06:49:18 -0500, Ron wrote: > The destination is an (RDS) Postgresql 12.5 with encoding UTF8, and is being > loaded through COPY commands generated by ora2pg. > > The source table has a BLOB column (I think they are scanned images) which > I'm loading into a Postgresql bytea column. >

Re: BRIN index on timestamptz

2021-04-26 Thread Peter J. Holzer
On 2021-04-26 17:23:49 +0530, Mohan Radhakrishnan wrote: > Isn't a btree subject to these effects ? So when I update ENUMS for each > timestamptz, btree indexes are less susceptible > to the effects than BRIN indexes  ? A btree index contains one entry for each record which points to that records.

Re: BRIN index on timestamptz

2021-04-26 Thread Mohan Radhakrishnan
Isn't a btree subject to these effects ? So when I update ENUMS for each timestamptz, btree indexes are less susceptible to the effects than BRIN indexes ? Thanks. On Sat, Apr 24, 2021 at 9:05 PM Mohan Radhakrishnan < radhakrishnan.mo...@gmail.com> wrote: > > Why not use a btree index for the >

Invalid byte sequence when importing Oracle BLOB

2021-04-26 Thread Ron
Hi, The source is an Oracle 12 db with this encoding: NLS_LANG = AMERICAN_AMERICA.AL32UTF8 NLS_NCHAR = AL32UTF8 The destination is an (RDS) Postgresql 12.5 with encoding UTF8, and is being loaded through COPY commands generated by ora2pg. The source table has a BLOB column (I think they are s