time dates - Search results in mailing lists
Mailing lists >> pgsql-admin >> Thread >> Search in thread (2)
2025-05-30 15:54:24 | Re: pg_dump verbose start and stop times? (Ron Johnson)
date +"%n%F %T TIMEIT $ActionLabel finished. Elapsed time: ${ET} minutes." return $RC } time_it DUMP
Mailing lists >> pgsql-admin >> Thread
2025-03-09 23:37:20 | Re: Getting out ahead of OOM (Joe Conway)
date at this point: https:///blog/deep-postgresql-thoughts-the-linux-assassin Additionally Jeremy Schneider wrote a more recent one that you might find helpful: https:///2024/09/22/kubernetes-requests-and-limits-for-postgres/ My quick and dirty recommendations: 1. Use cgroup v2 on the host
Mailing lists >> pgsql-admin >> Thread
2025-02-11 20:12:41 | FW: Adding Postgres Repository on Red Hat 9 causes SELinux Warnings "SELinux is preventing /usr/bin/gpg (Janet Einhorn)
time. All the gpgkey file entries in are the same: [local_jeinhorn@useengatldevdb ~]$ sudo grep gpgkey /etc/yum.repos.d/pgdg-redhat-all.repo gpgkey=file:///etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL gpgkey=file:///etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL . . . . . . gpgkey=file:///etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL gpgkey=file:///etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL The Postgres repository GPG key stored
Mailing lists >> pgsql-admin >> Thread
2025-01-30 11:47:56 | Partition management - best practices and avoid long access exclusive lock during partition creation (srinivasan s)
time and blocking other sessions causing a resource crunch on the system. this is very busy system 24/7 very difficult to find a maintenance window CREATE TABLE IF NOT EXISTS %I PARTITION
Mailing lists >> pgsql-admin >> Thread
2024-12-17 18:07:30 | Re: Postgres upgradation (Ron Johnson)
times. export PGHOST=oldserver pg_dumpall -gvf globals.sql 2> /dev/null DbList=`psql -AXtc "select datname from pg_database where datistemplate=false and datname <> 'postgres' order by datname ;"` cd $BackupDir for DB in $DbList
Mailing lists >> pgsql-admin >> Thread
2024-11-10 00:25:42 | How to check if session is a hung thread/session (Edwin UY)
time zone 'Pacific/Auckland' as "Pacific/Auckland TIMEZONE", -> date_trunc( 'second', current_timestamp - pg_postmaster_start_time
Mailing lists >> pgsql-admin >> Thread >> Search in thread (2)
2024-09-13 01:51:50 | Query plan getting less efficient over time with frequent updates and deletes.. (Wells Oliver)
time=218.563..219.431 rows=7892 loops=1) Output: p.season, p.game_date, ... p.pitch
Mailing lists >> pgsql-admin >> Thread
2024-08-23 19:08:49 | Re: checking for a NULL date in a partitioned table kills performance (Scott Ribe)
Ah yes, that's a good point to take into consideration in such a case
Mailing lists >> pgsql-admin >> Thread
2024-07-14 19:06:02 | Re: help required for Datacenter Migration on Kubernetes Cluster (Scott Ribe)
time, set up a standby streaming replica, then when they're all populated and up-to-date
Mailing lists >> pgsql-admin >> Thread
2024-06-21 03:13:16 | Re: password_rollover_time like Oracle (Rui DeSousa)
I don’t think it’s too much of an issue for auditing as it
Mailing lists >> pgsql-admin >> Thread
2024-06-12 19:46:14 | Re: Logical replication from PostgreSQL 10.23 to 16.3, last two big tables (getting synced) just (Achilleas Mantzios)
dating back to 12:30 (maybe created via archive_timeout, rather than actual traffic) postgres@[local]/dynacom=# select * from pg_stat_replication where application_name = 'data_for_nu_pgsql_dynacom' or application_name ~* '_sync
Mailing lists >> pgsql-admin >> Thread
2024-06-11 21:15:17 | Index - Concurrently Method (SOzcn)
time, we gonna create on the main table anyway. So it's kinda confusing me. By Example; CREATE INDEX CONCURRENTLY idx_sales_2020_order_date
Mailing lists >> pgsql-admin >> Thread >> Search in thread (23)
2024-06-06 21:11:48 | RE: How to find the view modified date and time and user name (M Sarwar)
date and time and user name Hello, Today in our environment, we noticed that view
Mailing lists >> pgsql-admin >> Thread
2024-05-31 14:28:58 | Re: Postgresql 9.5: Streaming Replication: Secondaries Fail To Start Post WAL Error (Mohan NBSPS)
time (2-3 hours). The errors started around that date. Guess, the primaries (several of them
Mailing lists >> pgsql-admin >> Thread
2024-05-10 14:12:26 | Adding future partition causes deadlock??? (Chris Hoover)
time data. It does not get future data, so no activity would be happening in the partitions for future dates