Database Administrators Questions, Problems & Solutions : TransWikia.com ~ Page 26

How to get data from tables selected by reference from information_schema with some criteria in table name

I am trying to get data like count or distinct from tables matching criteria in information_schemaSELECT count(A.searchstring) FROM (SELECT ...

Asked on 10/28/2021 by Rajnikant Sharma

2 answer

In a Postgres function, how to skip expressions if input value is null?

I have a working function. But it only works if I literally supply both the city and country variables.CREATE OR REPLACE FUNCTION gridref_by_address(city text, country text)RETURNS SETOF research_db_gridreference AS...

Asked on 10/28/2021 by Dean Kayton

1 answer

Relational DB which can do inserts at billions of rows with multiple indexed columns?

I am looking for advice on a database to potentially replace SQLite for my application. To briefly describe my DB requirements:needs to support billions of rows and the most queried...

Asked on 10/28/2021 by 2alltra8034

0 answer

MariaDB Galera + Remote Backup

I'm using CentOS 8 and I have a MariaDB 10.5.4 Galera set up with three nodes. Now, I want it to create a backup to my central server from time...

Asked on 10/28/2021

1 answer

Poor performance in a SELECT using Inheritance

I will detail my problem in good detail. I have a marketplace application so I make a decision to make a multitenant per schema approach. I like this approach because...

Asked on 10/28/2021 by wavrik

0 answer

How to figure out the latest version of a table in the 'recyclebin' section of PL-SQL developer

There are three tables with the same name Pantea in my recyclebin section of pl-sql developer and I don't know how to find the one that had been dropped...

Asked on 10/28/2021 by Pantea

1 answer

Query is failing

I am running a query from SQL Server 2019(64bit) SSMS to PostgreSQL on AWS through Linked Server. Other queries are working fine but this particular query is failing due to...

Asked on 10/27/2021

2 answer

PostgreSQL resources requirements

We need to have db server (shared hosting, vps ..etc) mainly as storage (saving data) The database (PostgreSQL) is going to have <= 10 tables with data types:1 small...

Asked on 10/27/2021 by MIYUKI NARAHARA

0 answer

Optimizing my query

Here's my query:DECLARE @monthStartDate date;DECLARE @monthEndDate date; SET @monthStartDate = DATEFROMPARTS(2020,6,1);SET @monthEndDate = EOMONTH(@monthStartDate); SELECT @monthStartDate, MIN([Date]), @monthEndDate, GroupId, TypeId, ...

Asked on 10/27/2021 by Kilazur

2 answer

When (or why even) use PLPython(3)u

As I gain more experience with PostgreSQL I start to question the existence of PLPython. It's considered an "untrusted" language https://www.postgresql.org/docs/10/plpython.html What I am wondering is, when...

Asked on 10/27/2021 by Chessbrain

2 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 26)

Ask a Question