Re: pb with big volumes

On 8/10/23 16:36, Marc Millas wrote: Hi, I have a 15 TB db on postgres 14 (soon 15). shared buffers is 32 GB. Does the system have 128GB AM? It's a db with max 15 users and often less, and currently 1 or 2. the biggest table have 133 partitions of 150M to 200M+ rows each. lots of request ac

Re: pb with big volumes

Wouldn't IO contention make for additive timings instead of exponential? On 8/10/23 20:41, Adam Scott wrote: I think your concern is that 20 min + 30 min does not equal 3 hours. It might be natural to think the contention would, at max, be 50 min x 2 (1 hr 40 min). So what's going on? It se

Re: pb with big volumes

On 8/10/23 23:40, David Rowley wrote: On Fri, 11 Aug 2023 at 13:54, Ron wrote: Wouldn't IO contention make for additive timings instead of exponential? No, not necessarily. Imagine one query running that's doing a parameterised nested loop join resulting in the index on the inner

Re: Query plan regression between CTE and views

On 8/14/23 09:54, David Gilman wrote: I have a query that was originally written as a handful of CTEs out of convenience. It is producing a reasonable query plan because the CTE materialization was kicking in at an appropriate place. The CTEs aren't totally linear. The graph looks like this, wher

Re: Fatal Error : Invalid Memory alloc request size 1236252631

Did you /try/ changing bytea_output to hex? On 8/14/23 12:31, Sai Teja wrote: I am just running select query to fetch the result Query : select id, content_data, name from table_name So here content_data is bytea content which is having more than 700 MB. Even if I run this query in any DB clien

Re: PostgreSQL and local HDD

On 8/15/23 04:24, Olivier Gautherot wrote: [snip] Does the database have to be on a storage like EMC or QNAP? Faster storage can only help but I would start by discarding functional overhead. Functional overhead? -- Born in Arizona, moved to Babylonia.

Re: PostgreSQL and local HDD

On 8/15/23 02:23, Jason Long wrote: [snip] Does PostgreSQL have an option to increase speed? Like a Turbo button? -- Born in Arizona, moved to Babylonia.

Re: PostgreSQL and local HDD

On 8/15/23 23:48, Olivier Gautherot wrote: El mié, 16 ago 2023 5:39, Ron escribió: On 8/15/23 04:24, Olivier Gautherot wrote: [snip] Does the database have to be on a storage like EMC or QNAP? Faster storage can only help but I would start by discarding functional

Re: PostgreSQL and local HDD

On 8/16/23 03:40, Andreas Joseph Krogh wrote: På onsdag 16. august 2023 kl. 05:40:40, skrev Ron : On 8/15/23 02:23, Jason Long wrote: [snip] > Does PostgreSQL have an option to increase speed? Like a Turbo button? It actually has that, but you'll have to sacrifice som

Re: Creating a TABLESPACE

Friendly tip: whatever else you do, don't write "Hello children!" in English to adults.  It's *highly insulting*. On 8/16/23 05:10, Amn Ojee Uw wrote: Hello children! -- Born in Arizona, moved to Babylonia.

Re: Creating a TABLESPACE

Speakers of English as a second language are to be tolerated and assisted, not mocked and insulted. On 8/16/23 12:27, Amn Ojee Uw wrote: Sorry, did not mean it that way. Thanks for the advice. On 8/16/23 11:37 a.m., Ron wrote: Friendly tip: whatever else you do, don't write "Hell

Re: Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset?

On 8/20/23 14:10, Rihad wrote: On 8/20/23 20:22, Adrian Klaver wrote: On 8/18/23 22:35, Rihad wrote: On 8/17/23 13:01, rihad wrote: Hi, all. After calling pg_stat_reset all statistics used by autovacuum got zeroed, and started accumulating from scratch. Some tables get acted upon properly,

Re: Loops and Case Statements Involving Dates

Since this code is in a loop, consider using clock_timestamp() instead of now(). It might not matter in this situation, though. On 8/21/23 02:07, Anthony Apollis wrote: *Please review my code and make recommendations where needed. I have this code: *``` NUMBER OF LOOPS FOR POSTGRESQL ETL: SELE

Re: The same prepared query yield "-1" the first six times and then "-1.0"

On 8/21/23 14:32, Dave Cramer wrote: [snip] It has to do with the way the data is being transferred. When the driver switches to a named statement it also switches to binary mode which means data will be transferred in binary. In text we get -1, in binary we get -1.0 That seems odd.  Why doe

Re: Will PostgreSQL 16 supports native transparent data encryption ?

On 8/21/23 18:49, Bruce Momjian wrote: On Mon, Aug 21, 2023 at 07:02:46PM +0300, Mostafa Fathy wrote: Hi there, It is mentioned here https://www.postgresql.org/about/press/faq/#:~:text= Q%3A%20What%20features%20will%20PostgreSQL%2016%20have%3F that native transparent data encryption is being wo

Re: Will PostgreSQL 16 supports native transparent data encryption ?

On 8/24/23 14:08, Stephen Frost wrote: Greetings, * Ron (ronljohnso...@gmail.com) wrote: On 8/21/23 18:49, Bruce Momjian wrote: On Mon, Aug 21, 2023 at 07:02:46PM +0300, Mostafa Fathy wrote: It is mentioned here https://www.postgresql.org/about/press/faq/#:~:text= Q%3A%20What%20features

Ad hoc SETOF type definition?

Pg 9.6.24 (Yes, I know it's EOL.) This simple "programming example" function works perfectly. However, it requires me to create the TYPE "foo". CREATE TYPE foo AS (tab_name TEXT, num_pages INT); CREATE FUNCTION dba.blarge()     RETURNS SETOF foo     LANGUAGE plpgsql     AS $$     DECLARE  

Re: Ad hoc SETOF type definition?

On 9/26/23 12:46, Tom Lane wrote: Ron writes: Is there a way to define the SETOF record on the fly, like you do with RETURNS TABLE (f1 type1, f2 type2)? Doesn't RETURNS TABLE meet the need already? That rationale means that RETURN SETOF is not needed, and can be removed from Pg,

Re: Ad hoc SETOF type definition?

On 9/26/23 13:15, Tom Lane wrote: Ron writes: On 9/26/23 12:46, Tom Lane wrote: Ron writes: Is there a way to define the SETOF record on the fly, like you do with RETURNS TABLE (f1 type1, f2 type2)? Doesn't RETURNS TABLE meet the need already? That rationale means that RETURN SETOF i

Re: Ad hoc SETOF type definition?

On 9/26/23 16:29, Adrian Klaver wrote: [snip] As a very simple example: This is EXACTLY what I was looking for.  Thank you. create table source(id integer, fld_1 varchar); insert into source values (1, 'cat'), (2, 'dog'), (3, 'fish'); CREATE OR REPLACE FUNCTION public.table_return(multipli

Re: Right version of jdbc

On 9/28/23 01:18, Raivo Rebane wrote: [snip] I made a new Java application Eclipse Dynamic WEB application and want to use Postgres - PostgreSQL 10.14 [snip] What's wrong. Or is better to use more newer postgres. And then which jdbc-I need to use ? https://www.postgresql.org/support/versionin

Re: Gradual migration from integer to bigint?

On 9/30/23 22:37, Tom Lane wrote: [snip] especially not a break that adds more per-row overhead. So really the only way forward for this would be to provide more automation for the existing conversion processes involving table rewrites. When altering an unindexed INT to BIGINT, do all of the i

Re: Gradual migration from integer to bigint?

On 10/1/23 12:04, Ireneusz Pluta wrote: W dniu 30.09.2023 o 07:55, James Healy pisze: ... We shouldn't have let them get so big, but that's a conversation for another day. Some are approaching overflow and we're slowly doing the work to migrate to bigint. Mostly via the well understood "add a n

Re: Operating of synchronous master when no standby is available

On 10/2/23 03:54, Sergey Cherukhin wrote: Hello! I use Postgresql+Pacemaker+Corosync cluster with 2 Postgresql instances in synchronous replication mode. When one of the nodes is down, clients hang on INSERT operations because the primary server waits until standby confirms that it got the da

Re: Problems starting slave

On 10/2/23 09:38, Douglas Reed wrote: Hi guys The servers are virtual running on Nutanix We are running Pg version 12 (12.10) On Linux km-data1.rs.fsbtech.com 5.4.191-1.el7.elrepo.x86_64 #1 SMP Tue Apr 26 12:14:16 EDT 2022 x86_64 x86_64 x86_64 GNU/Linux 48G/16 x CPU (Master and slave) Time

Re: specifying multiple options in URI psql behaviour?

On 10/2/23 10:21, Wim Bertels wrote: Tom Lane schreef op ma 02-10-2023 om 10:21 [-0400]: Wim Bertels writes: * but if you put more than 1 option, then it doesn't?: #psql postgresql://myuser@myserver/mydb?connect_timeout=10&target_session _attrs=any Maybe you forgot to quote that?  Ampersand i

Re: Problems starting slave

On 10/3/23 09:37, Douglas Reed wrote: Hi the full pg_basebackup command was;     pg_basebackup -h 172.110.6.5 -D /var/lib/pgsql/12/data -R -U postgres --wal-method=stream I get consistently successful results in v15 using this set of commands (where the service options reference the primary

Re: Multiple inserts with two levels of foreign keys

Frame challenge: why can't you just "\copy to" the dev database tables in the correct order, to satisfy foreign key requirements? On 10/4/23 18:59, Dow Drake wrote: Hi, I'm trying to write a postgresql script to replicate a hierarchical structure in a live database into my development databas

Re: Multiple inserts with two levels of foreign keys

Ah.  We'd truncate all of the dev tables, then load a "slice" (for example, accounts 1 to 1, and all associated records from downstream tables; lots and lots of views!!) from the prod database. On 10/4/23 20:50, Dow Drake wrote: Thanks for the reply, Ron! I'm n

Re: Multiple inserts with two levels of foreign keys

nderstanding of PostgreSQL's capabilities.  I'm going to keep working on a minimal solution that deletes no records from the dev database, and only inserts the required records. On Wed, Oct 4, 2023 at 6:58 PM Ron wrote: Ah.  We'd truncate all of the dev tables, then l

Re: Multiple inserts with two levels of foreign keys

But honestly, the amount of text duplication hurts my "inner programmer".  And it would have to be generated dynamically, since you don't know how many crops were delivered.  #shudder On 10/5/23 09:33, Dow Drake wrote: Yes! Thanks, Alvaro! This is exactly the pattern I was trying to work out

Re: why generated columsn cannot be used in COPY TO?

On 10/6/23 07:20, Andreas Kretschmer wrote: Am 06.10.23 um 13:53 schrieb Luca Ferrari: Hi all, I'm wondering why in COPY TO (file or program) I cannot use generated columns: since I'm pushing data out of the table, why they are not allowed? Example: testdb=# CREATE TABLE test( pk int generat

Re: why generated columsn cannot be used in COPY TO?

On 10/6/23 09:04, Andreas Kretschmer wrote: Am 06.10.23 um 15:47 schrieb Tom Lane: Luca Ferrari writes: I'm wondering why in COPY TO (file or program) I cannot use generated columns: since I'm pushing data out of the table, why they are not allowed? There's a comment about that in copy.c:

Re: why generated columsn cannot be used in COPY TO?

On 10/6/23 11:08, David G. Johnston wrote: On Fri, Oct 6, 2023 at 8:54 AM Adrian Klaver wrote: On 10/6/23 08:45, Ron wrote: > On 10/6/23 09:04, Andreas Kretschmer wrote: >> >>> Not sure how convincing that reasoning is, but it was at least >>>

Re: psql trying twice to connect to local DB

On 10/7/23 17:44, Steve Baldwin wrote: I have a local DB (15.2) running in a docker container. If I make a connection to that DB from most clients I see log entries like this: 2023-10-07 22:32:26.518 UTC,,,16278,"172.21.0.1:33192 ",6521dc7a.3f96,1,"",2023-10-07 22:32

Re: A question about possible recovery inconsistency

On 10/11/23 09:52, Eugen Konkov wrote: But why do you want to do that, if all that you have to do is specify "recovery_target = 'immediate'" to recover to the end of the backup? Because automation scripts do not know if transactions are available after some point in time or not. But automation

Re: log wal file transfer in error logs

Tables (on the primary) pg_stat_replication and (on the secondary) pg_stat_wal_receiver do that for you. On 10/11/23 12:50, Atul Kumar wrote: Yes, I meant streamed, I need to log those wal files that are getting streamed and replayed on standby servers in error logs of primary as well as sta

Re: Assitance needed for the resolution of memory leak

That's why you /attach/ files, not paste text. On 10/11/23 16:19, Sasmit Utkarsh wrote: Thanks Tom, It did work, and yeah I do have indentation in my editor, there was some formatting issue due to the copy and paste of the code. :) Regards, Sasmit Utkarsh +91-7674022625 On Thu, Oct 12, 2023

Re: A question about possible recovery inconsistency

On 10/11/23 12:07, Ron wrote: On 10/11/23 09:52, Eugen Konkov wrote: But why do you want to do that, if all that you have to do is specify "recovery_target = 'immediate'" to recover to the end of the backup? Because automation scripts do not know if transactions are availa

Re: right way of using case-expressions in plpgsql functions

On 10/15/23 11:19, Victor Dobrovolsky wrote: [snip] The documentation states that after some executions of such functions the plan should become generic. What is a generic plan for such a case and how would it work? It's highly dependent on the query When I see this happen (after we notice th

Re: Purely declarative FKs

On 10/16/23 09:06, Tom Lane wrote: Christophe Pettus writes: On Oct 16, 2023, at 00:51, Thiemo Kellner wrote: Question: Are there plans to provide a feature in PostgreSQL that one can have foreign keys for purely documentation purpose - I know, one could use a modelling tool and just not impl

Re: Understanding max_locks_per_transaction

On 10/16/23 14:31, Craig McIlwee wrote: That's what we've already done for the short term solution.  It is somewhat in conflict with your statement regarding the number of lockable objects not holding still for long, though.  As time goes on and our scheduled jobs automatically create new month

Re: PITR partial timing

Don't write your own PITR.  Use PgBackRest, barman, etc. On 10/16/23 12:08, Rama Krishnan wrote: Hi team, I  m testing PITR 1.if I am doing full recovery what ever the new tables were create will not be appear how to handle it 2. I have given my logs which time log I have to choose for PITR

Re: Inheritance in PostgreSQL

On 10/17/23 16:42, Luis Bruno wrote: Hello, I'm in the process of developing a basic database structure that utilizes inheritance as part of a test for my work. The database consists of two tables: ‘PERSON' and ‘CUSTOMER' with the ‘PERSON' table serving as the parent table for ‘CUSTOMER' .

Re: Need efficient way to remove (almost) duplicate rows from a table

https://dba.stackexchange.com/a/138327/63913 On 10/17/23 17:48, David Gauthier wrote: v11.5 on linux (I know, I know, IT is working on the upgrade to 15.2) I have a table with millions of records and there are a lot of "almost" duplicates that I want to get rid of in an efficient way.  Best to

Re: postgres keeps having blocks

On 10/18/23 07:40, David G. Johnston wrote: On Wednesday, October 18, 2023, Shaozhong SHI wrote: My postgres is playing up. I terminated session that is causing blocks many time. New block appears. Endless. What should I do? PostgreSQL is probably just doing what you t

Re: A few questions about foreign tables

And SELECT relnamespace::regnamespace::text, relname FROM pg_class WHERE relkind='f'; tells you all of the foreign tables. Thus, this (untested) query generate all of the DROP FOREIGN TABLE statements: SELECT format('DROP FOREIGN TABLE IF EXISTS %I.%I RESTRICT;'   , relnamespace::reg

Re: Driver Postgresql HP-Unix

On 10/18/23 13:45, Abelardo Erazo Lopez wrote: Hi, Everyone I have an Oracle database Oracle 19c and I need to access a PostgreSQL database 15.4  that resides on a different server. I see that one alternative is to use ODBC from Oracle. However, the server where the database resides is an HP

Re: Is postgres_fdw "safe"?

On 10/20/23 03:29, Marcin Borkowski wrote: Hello, I noticed that the docs for postgres_fdw lack the clause about it being "trusted". Does that mean that `create extension postgres_fdw` poses any known security risks? If so, what should I do to minimize them? I think a better question to ask

Re: Very newbie question

On 10/23/23 10:13, Олег Самойлов wrote: Back pardon, but I have a very newbie question. I have a partitioned table, partitioned by primary bigint key, size of partition 1000. I need to get the number of partition which need to archive, which has all rows are olden then 3 month. Here is que

Re: setting up streaming replication

On 10/23/23 18:16, Brad White wrote: I'm stumped. Using this command to set up the slave and replication on PG v 15: "C:\Program Files\PostgreSQL\15\bin\pg_basebackup" -h 192.168.1.126 -U pgrep_user -p 5433 -D "C:\Program Files\PostgreSQL\15\data" -Fp -Xs -R If I have PG running on the remote

Re: setting up streaming replication

On 10/24/23 08:14, b55white wrote: On Oct 23, 2023 at 8:30 PM, Ron wrote: On 10/23/23 18:16, Brad White wrote: > I'm stumped. > > Using this command to set up the slave and replication on PG v 15: > "C:\Program Files\PostgreSQL\15\bin\pg_basebackup" -h 192.168.1.126

Re: setting up streaming replication

On 10/24/23 13:31, Brad White wrote: On Tue, Oct 24, 2023 at 8:56 AM Ron wrote: On 10/24/23 08:14, b55white wrote: Is all that stuff with slots necessary since the backup will automatically create a temporary slot for replication? I want a permanent slot so that replication

Re: setting up streaming replication, part 2

On 10/24/23 19:29, Brad White wrote: I have the replication server set up and the streaming is working. The latest data show up, as desired. 3 minor issues. 1) I also have the WAL files being copied to a common location from the primary server with       archive_command = 'copy %p "DISKST

Re: setting up streaming replication, part 2

On 10/24/23 23:47, Brad White wrote: On Tue, Oct 24, 2023, 9:02 PM Ron wrote: On 10/24/23 19:29, Brad White wrote: > I have the replication server set up and the streaming is working. > The latest data show up, as desired. > > 3 minor issues. >

Re: Uninstalling Ora2pg

On 10/26/23 07:42, Yongye Serkfem wrote: Hello PostgreSQL Community, I am having difficulties uninstalling ora2pg which I manually installed on our Postgresql servers. I would appreciate any input on how to uninstall it. Thanks everyone for your time. Why do you have to uninstall it, when "ju

Re: need SQL logic to find out way's to Implement check sum to validate table data is migrated correctly

OP might be referring to migrating from, say, Oracle to Postgresql when oracle_fdw is not available. On 10/27/23 04:34, Thiemo Kellner wrote: Hi Why do you need checksums? Can you not employ a full outer join? My though behind this is that checksumming is quite costly cpuwise and you have

Re: need SQL logic to find out way's to Implement check sum to validate table data is migrated correctly

On 10/27/23 03:56, Y_esteembsv-forum wrote: Hi Need SQL logic/different approach method's  to find out way's a) to Implement check sum to validate table data is migrated correctly When migrating from Oracle to PostgreSQL, on both the Oracle side and the Postgresql side, I dumped each table (fo

Re: pg_checksums?

On 10/27/23 13:34, Paul Förster wrote: Hi, I have a few questions about pg_checksums. Long story short, checksums were disabled in our environment but are getting enabled now (again!) because of block corruptions which destroyed a few databases in a database cluster. And before you say "told

Re: pg_checksums?

On 10/29/23 04:11, Paul Förster wrote: Hi Peter On Oct 29, 2023, at 02:43, Peter J. Holzer wrote: I don't think so. AFAIK Replication keeps the data files in sync on a bit-for-bit level and turning on checksums changes the data layout. Running a cluster where one node has checksums and the oth

Re: [SOLVED?] Re: Disk wait problem... not hardware...

On 10/29/23 11:45, p...@pfortin.com wrote: On Sun, 29 Oct 2023 16:16:05 +0100 Peter J. Holzer wrote: On 2023-10-29 09:21:46 -0400, p...@pfortin.com wrote: These are all static tables. Does PG maintain a table row count so as to avoid having to count each time? No. To count the rows in a table

Re: pg_checksums?

On 10/29/23 12:57, Paul Förster wrote: Hi Ron, On Oct 29, 2023, at 16:37, Ron wrote: As for safety, what do you mean by "safe"? Safe in the sense that, if I enable checksums on a replica, switch over and the enable checksums on the other side, if this is ok, or whether future mut

Re: pg_checksums?

On 10/30/23 08:18, Paul Förster wrote: Hi Peter, On Oct 30, 2023, at 11:03, Peter J. Holzer wrote: On 2023-10-29 13:26:27 -0500, Ron wrote: Best to ask Percona. Why Percona? Probably a typo. Patroni is used. Erroneously thinking that Percona develops Patroni. :D -- Born in Arizona

pg_dump/pg_restore --jobs practical limit?

I will "soon" migrate some 1+ TB database from Pg 9.6.24 on RHEL 6 VMs to Pg 14.latest on RHEL 8 VMs.  The VMs have 10Gbps "NICs", SAN-based LUNs managed by LVM, and are all on ESX blades.  nproc count on some is 16 and on others is 32. Does anyone have experience as to the point of diminis

Re: pg_dump/pg_restore --jobs practical limit?

On 11/1/23 15:42, Laurenz Albe wrote: On Wed, 2023-11-01 at 13:09 -0500, Ron wrote: I will "soon" migrate some 1+ TB database from Pg 9.6.24 on RHEL 6 VMs to Pg 14.latest on RHEL 8 VMs.  The VMs have 10Gbps "NICs", SAN-based LUNs managed by LVM, and are all on ESX blades. 

Re: pg_dump/pg_restore --jobs practical limit?

On 11/1/23 20:05, Brad White wrote: *From:* Ron *Sent:* Thursday, November 2, 2023 3:01:47 AM *To:* pgsql-general@lists.postgresql.org *Subject:* Re: pg_dump/pg_restore --jobs practical limit? On 11/1/23 15:42

Re: pg_dump/pg_restore --jobs practical limit?

On 11/3/23 05:09, Marc Millas wrote: Marc MILLAS Senior Architect +33607850334 www.mokadb.com Testing pg_restore with different --jobs= values will be easier.   pg_dump is what's going to be reading from a constantly varying system. Hello, each time I do

Re: Postgres limitation in user management

How can you /practically/ support a database without being able to look at a table? On 11/3/23 01:26, Kar, Swapnil (TR Technology) wrote: Hello Team, I am facing a limitation with Postgres user management and require your assistance or input around it. Let me brief you the scenario here –

Re: Postgres limitation in user management

On 11/4/23 16:53, Peter J. Holzer wrote: On 2023-11-04 21:42:34 +, Brent Wood wrote: We have 2 sets of database user groups – 1. App – who owns the application schemas (and tables) 2. Support – who provides db support We want Support users to have no SELECT or DML privilege but only AL

Re: No longer available installer for greater version then PostgreSQL 10

On 11/8/23 11:04, Shashikanth Bhardwaj wrote: Hi Team, I am facing some problem because of unavailability of PostgreSQL installer greater then 10 version of PostgreSQL in my case I need postgreSQL-14.0 version installer but unfortunately now not available. Which OS? Where are you looking

Re: Conditional compilation

On 11/12/23 09:32, Thiemo Kellner wrote: Hi Does PostgreSQL have something like Oracle's conditional compilation? This is sort of an if then statement that gets evaluated on compilation/installation time of PL/SQL code. If the condition is met, the code until the $END gets compiled. It is eve

Re: Duplicate key error

On 3/4/21 12:14 AM, Andrus wrote: Hi! says something else is inserting/updating using that key value. So obviously your script is not catching all the conflicts. > At this point your best bet is to monitor the Postgres log and see what else is happening at the time of the error. I'm guessing

Re: Logical Replication, CPU load and Locking contention

On 3/10/21 2:10 AM, Radoslav Nedyalkov wrote: On Wed, Mar 10, 2021 at 3:56 AM Martín Fernández > wrote: Hello, I’m troubleshooting a problem at my company with a pg 12 cluster that we run. We are using Amazon DMS to replicate data from our database

Re: Logical Replication, CPU load and Locking contention

On 3/10/21 11:56 AM, Martín Fernández wrote: On 10 Mar 2021, at 11:25, Ron <mailto:ronljohnso...@gmail.com>> wrote: On 3/10/21 2:10 AM, Radoslav Nedyalkov wrote: On Wed, Mar 10, 2021 at 3:56 AM Martín Fernández <mailto:fmarti...@gmail.com>> wrote: Hello, I’m

Re: postgresql order lowercase before uppercase

Exactly.  "C" collation is the opposite of what he wants. OP needs something like "de_DE". On 3/18/21 10:36 AM, Marc Millas wrote: to me, collate 'C' ask for the raw ascii order which put caps before because the hexa coding is lower did you try any thing else (POSIX is same as 'C') Marc MILLA

Re: Row not immediately visible after commit

RDS is also a modified version of Postgresql, just not as modified as Aurora. On 3/29/21 7:06 PM, Steve Baldwin wrote: Thanks Adrian. This is 'vanilla' postgres as far as I know (unlike their postgres-flavoured Aurora product). b2bc_owner@b2bcreditonline=> select version();                    

Re: Upgrading from 11 to 13

On 3/30/21 9:53 AM, Daniel Westermann (DWE) wrote: On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote: Hi, Le mar. 30 mars 2021 à 16:10, Susan Joseph a écrit : I am currently using PostgreSQL 11.2 and would like to try and upgrade it to the latest version 13.  Can I

Re: Is replacing transactions with CTE a good idea?

On 4/1/21 10:04 AM, Rob Sargent wrote: On 4/1/21 8:58 AM, Brian Dunavant wrote: On Thu, Apr 1, 2021 at 10:49 AM Glen Huang > wrote: If I decide to replace all my transaction code with CTE, will I shoot myself in the foot down the road? I do this all the time a

Re: Slick way to update multiple tables.

On 4/1/21 11:16 AM, Theodore M Rolle, Jr. wrote: I SELECT items from three tables. It seems that the only way to put updated fields into their proper table is to query /each/ field, then UPDATE /each/ table. Am I missing something here? Is there a way to do this automatically? Did you join

Re: Check constraint failure messages

On 4/6/21 2:40 PM, Miles Elam wrote: I've got a domain that validates email addresses. When inserting a bunch of entries I simply get the error message ERROR: value for domain po.email violates check constraint "email_check" SQL state: 23514 When inserting 1000+ entries in a batch, fi

Re: Check constraint failure messages

On 4/6/21 3:50 PM, Miles Elam wrote: On Tue, Apr 6, 2021 at 1:03 PM Ron <mailto:ronljohnso...@gmail.com>> wrote: On 4/6/21 2:40 PM, Miles Elam wrote: I've got a domain that validates email addresses. When inserting a bunch of entries I simply get the error message

Re: Primary keys and composite unique keys(basic question)

On 4/5/21 9:37 PM, Rob Sargent wrote: It's a small thing, but UUIDs are absolutely not memorizable by humans; they have zero semantic value.  Sequential numeric identifiers are generally easier to transpose and the value gives some clues to its age (of course, in security contexts this can be a d

Re: Primary keys and composite unique keys(basic question)

On 4/7/21 11:35 AM, Rob Sargent wrote: On Apr 7, 2021, at 10:17 AM, Ron wrote:  On 4/5/21 9:37 PM, Rob Sargent wrote: It's a small thing, but UUIDs are absolutely not memorizable by humans; they have zero semantic value.  Sequential numeric identifiers are generally easier to transpos

Re: Primary keys and composite unique keys(basic question)

On 4/7/21 1:16 PM, Rob Sargent wrote: On 4/7/21 11:59 AM, Ron wrote: On 4/7/21 11:35 AM, Rob Sargent wrote: On Apr 7, 2021, at 10:17 AM, Ron wrote:  On 4/5/21 9:37 PM, Rob Sargent wrote: It's a small thing, but UUIDs are absolutely not memorizable by humans; they have zero semantic

Re: where clauses including timstamptz and intervals

On 4/9/21 5:24 AM, hubert depesz lubaczewski wrote: On Fri, Apr 09, 2021 at 07:24:54AM +, Niels Jespersen wrote: Hello all Are these two queries exactly eqivalent? The table is partitioned on r_time, which is a timestamptz. The explain plans are not exactly the same. The first wants to scan

Re: Who altered the database?

On 4/9/21 6:14 AM, Durumdara wrote: Dear Members! We have a server. Because of high usage we can't log DDL-s. There are too many temporary tables created by users, so it would slow down the server. A database owner changed. What can we do to get info about the change (who did it, from what IP

Re: The Amazon CloudFront distribution is configured to block access from your country.

On 4/10/21 2:00 PM, felix.quin...@yahoo.com wrote: I am trying to download the installer and I get this error. The same happens with binary files. --- 403 ERROR The request could not be satisfied. The Amazon CloudFront distribu

Re: The Amazon CloudFront distribution is configured to block access from your country.

Then you should ask EDB, or Amazon, or use a VPN. On 4/10/21 7:03 PM, felix.quin...@yahoo.com wrote: Because it is the Postgresql installer. https://www.enterprisedb.com/downloads/postgres-postgresql-downloads On Saturday, April 10, 2021, 07:30:29 PM GMT-4, Ron wrote: On 4/10/21 2:00

Re: The Amazon CloudFront distribution is configured to block access from your country.

On 4/11/21 9:12 AM, Israel Brewster wrote: On Apr 11, 2021, at 1:53 AM, Stephan Knauss > wrote: Hello Felix, On 11.04.2021 02:31, felix.quin...@yahoo.com wrote: I see no reason why ask elsewhere first, the link for the installer

Re: The Amazon CloudFront distribution is configured to block access from your country.

On 4/11/21 10:07 AM, Israel Brewster wrote: On Apr 11, 2021, at 6:52 AM, Ron <mailto:ronljohnso...@gmail.com>> wrote: On 4/11/21 9:12 AM, Israel Brewster wrote: On Apr 11, 2021, at 1:53 AM, Stephan Knauss <mailto:pg...@stephans-server.de>> wrote: Hello Felix, On 11.04.2021

Re: Reuse of REF Cursor

On 4/11/21 1:02 PM, Abraham, Danny wrote: 2021-04-09 08:00:08.692 IDTERROR: canceling statement due to statement timeout 2021-04-09 08:00:08.692 IDTCONTEXT: PL/pgSQL function orhpans_active_clean_table(character varying,integer) line 42 at FETCH PL/pgSQL function orhpans_active_remova

Re: How can I insert the image as a blob in the table

On 4/12/21 8:29 PM, Igor Korot wrote: Hi, guys, On Sun, Apr 11, 2021 at 7:08 PM Igor Korot wrote: Hi, David, On Sun, Apr 11, 2021 at 6:57 PM David G. Johnston wrote: On Sunday, April 11, 2021, Igor Korot wrote: Hi, David, On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston wrote: If yo

Re: enable_seqscan to off -> initial cost 10000000000

On 4/23/21 10:39 AM, Luca Ferrari wrote: Hi all, this could be trivial, but I would like an explaination: if I turn off sequential scans on a table without indexes, the same access plan is increased by a 100 factor. I suspect this is a warning for me to remind that something is misconfigu

Invalid byte sequence when importing Oracle BLOB

Hi, The source is an Oracle 12 db with this encoding: NLS_LANG = AMERICAN_AMERICA.AL32UTF8 NLS_NCHAR = AL32UTF8 The destination is an (RDS) Postgresql 12.5 with encoding UTF8, and is being loaded through COPY commands generated by ora2pg. The source table has a BLOB column (I think they are s

Re: Invalid byte sequence when importing Oracle BLOB

On 4/26/21 7:32 AM, Peter J. Holzer wrote: On 2021-04-26 06:49:18 -0500, Ron wrote: The destination is an (RDS) Postgresql 12.5 with encoding UTF8, and is being loaded through COPY commands generated by ora2pg. The source table has a BLOB column (I think they are scanned images) which I&#

Re: Invalid byte sequence when importing Oracle BLOB

On 4/26/21 7:58 AM, Peter J. Holzer wrote: On 2021-04-26 07:45:26 -0500, Ron wrote: On 4/26/21 7:32 AM, Peter J. Holzer wrote: On 2021-04-26 06:49:18 -0500, Ron wrote: The destination is an (RDS) Postgresql 12.5 with encoding UTF8, and is being loaded through COPY commands generated by ora2pg

Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL?

On 5/2/21 8:46 AM, Pól Ua Laoínecháin wrote: [snip] Now, I'm not quite sure that I completely comprehend matters: Is there a difference between Asynchronous I/O and Buffered I/O? * Asynchronous (a-syn-chron-ous) is an adjective which means "not together with time". * Buffered means "read more

Re: Issue in PG start

On 5/8/21 10:53 AM, Adrian Klaver wrote: On 5/7/21 10:14 PM, sivapostg...@yahoo.com wrote: Hello, PG 11.8 in Windows 10 and currently PG 11.11 Yesterday [07th May] morning when we switched on the computer and subsequently PGAdmin, we got the message following message FATAL: the database syst

Re: Issue in PG start

On 5/8/21 9:19 PM, sivapostg...@yahoo.com wrote: 1. First why switch the computer off for lunch?     It's a development machine and I'm a developer.   We used to shut down every computer for lunch.  We shut down the windows and not just hit the power switch.   We advice and follow every use

Re: Copyright vs Licence

On 5/10/21 4:34 AM, Vijaykumar Jain wrote: Hi All, I have been playing around with the pg_auto_failover extension by citus and have really enjoyed playing chaos with it. citusdata/pg_auto_failover: Postgres extension and service for automated failover and high-availability (github.com)

<    5   6   7   8   9   10   11   12   13   14   >