Re: Improving pg_dump performance when handling large numbers of LOBs

On Mon, Feb 05, 2024 at 09:17:53PM +0100, Andreas Joseph Krogh wrote: > > På mandag 05. februar 2024 kl. 21:10:53, skrev Wyatt Tellis < > wyatt.tel...@gmail.com >: > > No, we don't have the ability to make schema changes and the schema in the > PG15 copy needs to m

Re: Disk wait problem...

> Hi, > > I have a 1.6TB database with over 330 tables on a 4TB NVMe SSD. All > tables are static (no updates); most in 8M and 33M row sizes. Queries have > been great, until recently. > Also attached is the relevant system journal entries for one query that > took 2 seconds and two more that too

Re: Migrating MySQL DB to PostgreSQL DB.

On Sun, Jul 30, 2023 at 07:31:02PM +0530, Kaushal Shriyan wrote: > Hi, > > I am running MySQL DB 8.0.34 on Red Hat Enterprise Linux release 8.7 > (Ootpa). Is there a way to import MySQL DB along with data to PostgreSQL 14 > database server? > > Please suggest. Thanks in advance. > > Best Regards

Re: Duplicate Primary keys in postgresql tables

> > *Our questions:* > > Any ideas on what might cause this behavior other than the collation? if it > is a well-known issue in the pgsql community or it really is the > coalition that's the root cause, do we have mitigation for this kind of > issue from happening in future? > > > > De, > > T