time dates - Search results in mailing lists
Mailing lists >> pgsql-general >> Thread
2025-05-28 12:53:51 | Re: Changing a varchar(7) domain into text directly in pg_type (Richard Zetterberg)
date timestamptz NOT NULL ); ``` Each year, birdtaxonomies.com release a new edition of the bird species taxonomy, that you update your species table with. But this year, birdtaxonomies.com comes decides they want a more
Mailing lists >> pgsql-general >> Thread >> Search in thread (2)
2025-05-09 03:52:35 | Re: Is anyone up for hosting the online PG game "Schemaverse"? (Joshua McDougall)
dated and need some fiddling to get operational. This tends to be the most complicated part to get running lately. I would happily help either by answering questions, or by directly working on the system
Mailing lists >> pgsql-general >> Thread
2025-04-28 11:25:51 | Fwd: SQL transactions executing from VMSS (chandan Kumar)
Date: Tue, Apr 22, 2025 at 4:59 PM
Subject: SQL transactions executing from VMSS
To:
Mailing lists >> pgsql-general >> Thread >> Search in thread (3)
2025-04-18 23:27:27 | Re: [EXTERNAL] Re: Why is an error not thrown when the time exceeds the lock (Mansky, Edmund J. (GSFC-671.0)[ADNET Affiliate]" )
Date: Friday, April 18, 2025 at 11:51 AM
To: "Mansky, Edmund J. (GSFC-671.0)[ADNET Affiliate]"
Mailing lists >> pgsql-general >> Thread
2025-04-15 19:21:15 | Fwd: Identify system databases (Igor Korot)
Date: Tue, Apr 15, 2025 at 11:15 AM
Subject: Re: Identify system databases
To: David G. Johnston
Mailing lists >> pgsql-general >> Thread >> Search in thread (2)
2025-04-07 15:44:58 | Performance regression when adding LIMIT 1 to a query (Costa Alexoglou)
time zone))"}, Filter: ((metrics -> 'perf_average_query_runtime'::text) IS NOT NULL) Rows Removed by Filter: 68 Heap Blocks: exact=4272 -> Bitmap Index Scan on idx_databases_metrics_instance_date
Mailing lists >> pgsql-general >> Thread
2025-03-31 22:36:43 | Re: [EXTERNAL] RDS IO Read time (Eden Aharoni)
Date: Monday, 31 March 2025 at 21:44
To: Eden Aharoni
Mailing lists >> pgsql-general >> Thread
2025-03-18 22:28:39 | How to convert wal log to sql commands starting from specified time (Andrus)
time and number of commands to decode as pg_recvlogical parameters? Output is too verbose, contains data types. How show next 100 sql commands starting from from some date
Mailing lists >> pgsql-general >> Thread
2025-03-14 05:39:46 | Re: Query optimization (Durgamahesh Manne)
Stats up to date insert .....on conflict do nothing runs some times Regards Durga Mahesh
Mailing lists >> pgsql-general >> Thread
2025-03-13 13:10:40 | Re: Moving from Linux to Linux? (Paul Foerster)
date as far as dependency packages are concerned. So we have to build them too from source (cgal, SFCGAL, gdal, proj, … you name it). The idea is that Red Hat makes those things easier
Mailing lists >> pgsql-general >> Thread
2025-03-06 11:45:55 | Re: Quesion about querying distributed databases (me nefcanto)
date-times as UTC, using bigint everywhere even for small tables for consistency, denormalizing enum
Mailing lists >> pgsql-general >> Thread
2025-03-03 19:05:10 | Infinite loop for generate_series with timestamp arguments (Jakob Teuber)
date in the future; the same result would happen with e. g. the interval '1 month -40 days' or generate_series(10, 5, +1). This would fit with the above, where Postgres assumes that
Mailing lists >> pgsql-general >> Thread
2025-02-26 17:06:08 | Re: Corruption of few tables (Greg Sabino Mullane)
time passes from starting the query until you see the error? Make sure all your related programs are up to date
Mailing lists >> pgsql-general >> Thread
2025-02-25 16:51:25 | Postgres 16 unexpected shutdown (postgres@arcict.com)
time 2025-02-22 08:05:49.427 CET [30566] LOG: could not write file "pg_stat_tmp/pgss_query_texts.stat": Operation not permitted 2025-02-22 08:05:49.427 CET [30566] STATEMENT: SET application_name = 'JSN4101
Mailing lists >> pgsql-general >> Thread
2025-02-13 21:44:26 | Re: Ideas about presenting data coming from sensors (Thiemo Kellner)
time to put them into columns one by one, on the other end you have the hassle of dissecting the JSON, XML you name it when you retrieve/select the data, every query. While the query