time server - Search results in mailing lists
Mailing lists >> pgsql-sql >> Thread >> Search in thread (2)
2024-08-19 19:27:01 | Re: Powerfailure caused a reduction in INSERT performance of version 12 database. (Frank Komsic)
time is an issue. Here it says 2425 ms but I can say it is more like 4500ms actually. Also I do not understand the width=217 if there are only 19 columns? Thanks Frank
Mailing lists >> pgsql-sql >> Thread
2024-04-02 09:19:36 | [MASSMAIL]postgres is slow on windows (Nazneen Mulani)
time it takes. While Same replica db is present on server where Postgres 15 is being
Mailing lists >> pgsql-sql >> Thread
2024-02-07 23:30:17 | Re: POSTGRES 15 - CONSTRAINT TRIGGER CREATION (Tom Lane)
time to move on from that. For reference, the NOTICEs I show above are coming out of some code that v11 had for converting pre-7.3 pg_dump scripts to modern FK constraints. That bore
Mailing lists >> pgsql-sql >> Thread >> Search in thread (2)
2023-09-25 09:58:56 | Sv: DDL in active production database (Andreas Joseph Krogh)
server generally lets you away with it. Should we expect problems if we decided to do this in the latest version of Postgres? Thanks for your time
Mailing lists >> pgsql-sql >> Thread
2023-09-10 18:32:50 | RE: How to handle application connectivity change when moving from Oracle to Postgres in GCP (Mike Sofen)
server), I recommend contacting your rep at Google Cloud on this topic. They just went GA on their DMS product (Data Migration Service) for Oracle to CloudSQL-Postgres migrations (and AlloyDB shortly) – pretty good timing
Mailing lists >> pgsql-sql >> Thread
2023-08-08 22:13:54 | Very odd message (Shaozhong SHI)
server was lost. Attempting reset: Failed. This occurs every time when a particular record to be inserted
Mailing lists >> pgsql-sql >> Thread
2022-12-12 18:19:00 | Re: PARALLEL CTAS (Steve Midgley)
time (and coordinate each thread to access different rows of the source file). However, my experience was that if you want the absolutely fastest import, you should copy the source file to a fast disk/array
Mailing lists >> pgsql-sql >> Thread
2022-10-15 20:04:41 | Re: How to do things like \timing on in a do loop? (Erik Brandsberg)
timing is not a postgres command. It is a psql command, so is not interpreted by the server
Mailing lists >> pgsql-sql >> Thread >> Search in thread (4)
2022-03-04 14:43:22 | Re: Bug in tables column data in postgres database (Tom Lane)
time of all the readers of this mailing list. There are some hints about formulating a well-documented problem report here: https:///wiki/Guide_to_reporting_problems as well as in the fine manual: https:///docs/current/bug-reporting.html I will just
Mailing lists >> pgsql-sql >> Thread
2021-12-17 16:27:30 | Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links (Tom Lane)
server's FDW credentials" could be associated with a grantable role? That's still an awfully coarse-grained approach though. I thought for a moment about putting an SSL cert right into the connection string
Mailing lists >> pgsql-sql >> Thread
2021-12-12 18:25:49 | Memory exhaustion on large query (Brice André)
server. I use libpq to interface my DB. On some queries, my program is using so much memory that the application crashes. I use libpq in asynchronous mode to avoid this problem, but the memory
Mailing lists >> pgsql-sql >> Thread
2021-10-04 23:34:27 | Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres (Steve Midgley)
server itself can access on the file system, but it's more flexible and still remarkably fast. It can be even (a bit) faster if you don't feed STDIN line by line
Mailing lists >> pgsql-sql >> Thread
2020-12-03 09:52:56 | Re: Join push down on FDW partitions (Anders Svensson)
servers which is great. However, it is very hard to get the Postgres planner to take the "right" decisions 🙁. If I add a group by it will not push down the group by which
Mailing lists >> pgsql-sql >> Thread
2020-10-08 19:46:24 | libpq CREATE DATABASE operation from multiple treads (p.sun.fun@gmail.com)
server. In our code, the process to create a new database consist of the following steps: 1) Connect to "template1" database 2) Execute "CREATE DATABASE " 3) Close connection 4) Open a connection
Mailing lists >> pgsql-sql >> Thread
2020-10-04 14:40:54 | parallelisation of queries (Francesco De Angelis)
time grows linearly over the number of subqueries. This happens also with a total number of queries that is less than the number of CPUs on my server