I have ARRAY_AGG( distinct CAST (asset_group_id AS text)) which returns array of hundreds of elements but I want only first 100 elements. I didn't find any such function available in postgres array documentation. How can I achieve it in the…
I want to know what will be impact enabling pg_prewarm extension on postgresql where DB have MV and while refreshing MV concurrently would this extention create extra overhead or any performance issue on DB ? PG Version - 11 Thanks…
I need to insert about 100 million rows of flat data into a Postgres database on a schedule with a frequency of 24 hours. I.e. every 24 hours, I have an ingestor that inserts data from CSV files in the…
I am trying to get some graph about different entries in a column in Grafana, but Grafana tries to recognize the antry as a column instead of a column value. I have the following setup: A PostgreSQL Database (v11). A…
I have created a webpage and using postgresql as database. It works simply :- register users name, email and password login using registered email and password and then a welcome messege appears Now, i added another button 'forgot password' button…
newbie here. There are station names in a column that have extra characters at the end. I'd like to trim them in PostgreSQL. For example, this works to remove ' (Temp)' at the end. SELECT station_name, RTRIM(station_name,' (Temp)') FROM station_data…
I am trying to build the query to remove duplicate records and retain the latest in postgres. Input : Object_Name,Id,name,insert_date,update_date a,NULL,NULL,2023-08-28, a,NULL,NULL,2023-08-29, b,test,test1,,2023-08-29 a,NULL,NULL,2023-08-30, Output :Need to delete duplicate rows where object name is same and Id and name is…
I have a table with millions of text documents in a Postgres 14.7 DB. When I try to generate a GIN index I get this error: create index idx__txt_document__doc_text__gin on txt_document using gin(to_tsvector('simple', doc_text)); ERROR: string is too long for…
I'm trying to group the rows of a table based on the time difference between them. If the records differ by less than 30 days (time interval), they must be grouped together; otherwise, they are considered separate events. The start…
I am having 2 servers, server (A,B). Can server A be publisher for table 1 and subscriber for table 2. And server B be publisher for table 2 and subscriber for table 1. What i reached so far, server A…