Re: compiling postgres on windows - how to deal with unmatched file extension?

On 12/13/22 23:55, Yang, T. Andy wrote: src/backend/bootstrap/bootparse.c': No such file or directory 'src/backend/parser/gram.c': No such file or directory Have you tried using cygwin? -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: postgres large database backup

PostgreSQL behaves similarly to Veritas Cluster, when one Postgres cluster goes down, the other one is started. And you don't have to pay for it, unless you start using storage snapshots. That ACFS feature requires a commercial license. -- Mladen Gogala Database Consultant Tel: (347) 321-1217

Re: postgres large database backup

y the snapshot, for every snapshot. CoW is a very expensive animal, with horns. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: postgres large database backup

down the I/O considerably. I would definitely prefer snapshots done in hardware and not in software.  My favorite file systems, depending on the type of disk, are F2FS and XFS. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: postgres large database backup

an also do PITR. Your database is an enterprise sized database and needs an enterprise level tool. If you want a freebie, pgbackrest is the best thing no money can buy. Pgbackrest supports parallelism, full and incremental backups. -- Mladen Gogala Database Consultant Tel: (347)

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

t;dba" group on the Oracle servers, so that I can do "sqlplus / as sysdba" without switching to the user "oracle". It's the same thing. If I was to respond by a single word, the word would be "convenience". Or maybe "covfefe"? -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault

On 11/7/22 06:19, Laurenz Albe wrote: Don't continue to work with that cluster even if everything seems OK now. "pg_dumpall" and restore to a new cluster on good hardware. Why would that be necessary if the original machine works well now? -- Mladen Gogala Database Consultant

Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP

hen to commit. Advice like "commit often and commit early", to paraphrase the famous Chicago mayor, is easy to find but I would take it with grain of salt. Regards -- Mladen Gogala Database Consultant https://dbwhisperer.wordpress.com

Re: Different execution plan between PostgreSQL 8.4 and 12.11

plans over to the new version. If you don't want to install the new extension, you can try by running vacuum analyze on the database. Also, upgrading to PgSQL 12 doesn't make much sense given the fact that PgSQL 15 will be released in a few weeks. Can you upgrade to PgSQL 14? Regards

Re: I slipped up so that no existing role allows connection. Is rescue possible?

On 9/20/22 18:54, Theodore M Rolle, Jr. wrote: And Tom’s English is excellent! As opposed to mine? -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: I slipped up so that no existing role allows connection. Is rescue possible?

ered creating a dedicated page for beginners? Something like AskTom.postgresql.org would probably be appropriate. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?

On 9/14/22 23:27, Tom Lane wrote: Looks to me like you made the same mistake as Bryn. You revoked the permission in the postgres database: You are right. When I do it correctly, "revoke execute" works. Thanks for taking time to show me the errors of my wicked ways. Regards

Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?

+-+-- f | f | f (1 row) Yet, it is still able to execute the function in question. My version is the following: scott=> select version(); version ---------  Post

Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?

e only a superuser can do this. Bryn, you can revoke execute on pg_terminate_backend from public and that will, by extension, revoke it from all users who do not have DBA privilege or have not been explicitly granted the "execute" privilege on pg_terminate_backend. This doesn't look like a big problem because applications usually don't contain code for killing other user's sessions. I am not sure that GTA is running on top of Postgres database. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: ***SPAM*** Re: WARNING: could not open statistics file "pg_stat_tmp/global.stat": Operation not permitted

d not an external directory. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: WARNING: could not open statistics file "pg_stat_tmp/global.stat": Operation not permitted

LABEL Description="This install PostgreSQL 14 on top of Oracle Linux 8" LABEL maintainer="Mladen Gogala" RUN dnf -y update COPY RPMS/pgdg-redhat-repo-latest.noarch.rpm /tmp COPY RPMS/pg_hint_plan14-1.4-1.el8.x86_64.rpm /tmp/ COPY RPMS/pg_hint_plan14-llvmjit-1.4-1.el8.x86_64

Re: Postgres SQL unable to handle Null values for Text datatype

uniqueness the same way as with Oracle, you actually need 2 indexes.  You need to use the "coalesce" function. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: [Beginner Querstion]Where can I find the news of database?

lso a very nice blog with RSS feed: https://planet.postgresql.org/ Any RSS reader like Liferea will be good for following the blog. As for the news the hurricane 15.1 is about to hit the Postgres world. For now, it is only a Cat 1 hurricane, but it's likely to strengthen..... Regards -- Mla

Re: Was my question inappropriate for postgres?

various databases. That is why people still use it, even on Linux. And yes, like you, I am a Linux user too. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Was my question inappropriate for postgres?

an you possibly translate the question and explain to me what a "suitable driver" is and what is M365? If you manage to prove to me that the question makes sense, I will apologize to the OP and offer you a pint of Sam Adams as an apology for my bad behavior. On the other hand,

Re: Was my question inappropriate for postgres?

DBA who don't check their backups. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Was my question inappropriate for postgres?

n, that may say something about the question. At this point, you gotta ask yourself one question only: do I feel lucky? -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: postgis

en and convert the .rpm package into the .deb package. When dealing with alien be careful, so that it doesn't jump and stick to your face. Bad things can happen then -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: More than one Cluster on single server (single instance)

tical movements is purely accidental). -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Proposal to introduce a shuffle function to intarray extension

6}   Time: 2315.431 ms (00:02.315) Am i doing something wrong? Martin Hi Martin, No, you're doing everything right. I have no solution for you. You may need to do some C programming or throw a stronger hardware at the problem. The performance of your processors may be the problem. Good

Re: Proposal to introduce a shuffle function to intarray extension

aggregating them again. Martin, have you considered PL/Python and NumPy module? -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Get the table creation DDL

On 7/10/22 22:52, Rob Sargent wrote: Are you alone or on a team? What are your pronouns? -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Get the table creation DDL

On 7/10/22 21:13, Igor Korot wrote: How should I do that? Thank you. Oh boy! I give up. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Get the table creation DDL

a part of the standard install, it wouldn't need a separate Git repo on Gitlab. And of course you can use it in your database, just send me $1000 and you will have no problems with the license. I believe there is license file in the repo and it says something like that. Regards -- Ml

Re: Get the table creation DDL

On 7/10/22 20:02, Mladen Gogala wrote: This "extension" is nothing PL/PGSQL source code This "extension" is nothing _*but*_ PL/PGSQL source code -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Get the table creation DDL

text | in_schema character varying, in_t able character varying, in_fktype tabledef_fkeys DEFAULT 'FKEYS_INTERNAL'::table def_fkeys, in_trigger tabledef_trigs DEFAULT 'NO_TRIGGERS'::tabledef_trigs | fun c (1 row) | |As expected, the function returns the "text" data type. | |Regards | || || -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Get the table creation DDL

at for you. Somebody else has already done the hard work. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Get the table creation DDL

ables. https://www.postgresql.org/docs/14/functions-info.html -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: How can I set up Postgres to use given amount of RAM?

e is relatively simple to master and you can use Docker to run almost anything. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Question about attention to pgsql-hack...@lists.postgresql.org

ed by using plpython3u and importing "numpy". -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: External psql editor

=> /lib64/liblber-2.4.so.2 (0x7ff144982000)     libsasl2.so.3 => /lib64/libsasl2.so.3 (0x7ff144962000)     libselinux.so.1 => /lib64/libselinux.so.1 (0x7ff144935000)     libcrypt.so.2 => /lib64/libcrypt.so.2 (0x7ff1448fb000)     libpcre2-8.so.0 => /lib64/libpcre2-8.so.

Re: External psql editor

nother database with the same editor construct as \e. I am actually quite used to that. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Whole Database or Table AES encryption

both Oracle and PostgreSQL databases. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Are stored procedures/triggers common in your industry

business rules in the database itself makes the application more clear and easier to write. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Huge archive log generate in Postgresql-13

with pg_waldump. My guess would be that your vacuum is probably more active than in the version 11. However, that's just a guess. You can also turn on WAL compression. Be aware that compression will reduce disk consumption at the expense of CPU consumption. Regards -- Mladen Gogala Database Cons

Re: Select .... where id not in (....) returns 0 incorrectly

han Oracle because in Postgres, the condition "is not null" can be resolved by index. In Oracle, it can not. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal

is used in the explain plan? Can you give me an example? TIA -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: 20220226-Clarification regarding delay time of PostgeSQL starting up

a DBA for a very long time and I know. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: 20220226-Clarification regarding delay time of PostgeSQL starting up

didn't show any interesting messages.) Yours, Laurenz Albe Thanks for letting me know, I didn't know that. Are there any such limitations with NFS and NAS devices like NetApp? Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: 2 phase commit with FDW

On 2/17/22 13:10, Mladen Gogala wrote: Hi! I am getting the following error when trying to PREPARE transaction which updates both local and foreign table: 2/17/22 12:48:00:657 EST] 0128 RegisteredRes E   WTRN0046E: An attempt by the transaction manager to call prepare on a

2 phase commit with FDW

there a way around it? If not, we will need yet another code change and another data source. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Can we go beyond the standard to make Postgres radically better?

do that without rebuilding would be nice. Babelfish Postgres is version 13.5, currently the most prevalent version in the data centers. A library to implement foreign communication protocol primitives would be a very nice thing indeed. -- Mladen Gogala Database Consultant Tel: (347) 321-1217

Re: Can we go beyond the standard to make Postgres radically better?

27;s not interactive, one has to do some pythong programming in order do to that. Unfortunately, it is not possible to just "describe the cursor", the description becomes available after the "execute" call. Hopefully, I understood you correctly. -- Mladen Gogala Datab

Babelfish for PostgreSQL

A point of view, I didn't find any differences in the functionality of the PostgreSQL database itself. Amazon RDS incorporates that modification and allows creating Aurora PostgreSQL database with the Babelfish extension from the menu. Regards -- Mladen Gogala Database Consultant Tel: (347)

Re: Microsoft Report Builder

-practices-and-lessons-learned-from-the-field/ That means that it will continue to be developed and that you will not waste all that effort. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Can we go beyond the standard to make Postgres radically better?

't talked about people, I leave that to politicians. Second, I was defending SQL. You've got me confused with somebody else. Last but not least, I didn't bring anything to this list, I was just responding to the posts. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Can we go beyond the standard to make Postgres radically better?

On 2/10/22 23:56, Guyren Howe wrote: On Feb 10, 2022, at 17:06 , Mladen Gogala wrote: But SQL is a terrible, no good, very bad language. I cannot accept such a religious persecution of SQL without a detailed explanation. I feel like anyone who is defending SQL here isn’t aware of how

Re: Can we go beyond the standard to make Postgres radically better?

am sure that your endeavor with Datalog will have similar success. Market decides what is the standard. May the Force be with you. In the mean time, I will still be using SQL. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

How to determine whether I'm running on a standby?

to do that, which is silly. Knowing Postgres idioms, there will probably be a function for this but I was unable to figure out which one. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: what is the solution like oracle DB's datafile

r and use ACFS as the file system. The result was very nice, roughly the same as with LVM. However, the installation of ASM is rather complex and since PostgreSQL cannot be clustered, there is no justification for doing that. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: pg_try_advisory_lock is waiting?

On 1/28/22 20:54, Michael Lewis wrote: On Fri, Jan 28, 2022 at 5:34 PM Mladen Gogala wrote: pg_try_advisory_lock returned TRUE even without "FOR UPDATE" clause in the subquery. Shouldn't it return false because it can't lock the row until the uncommitted update

Re: pg_try_advisory_lock is waiting?

, but pg_try_advisory_lock returned TRUE even without "FOR UPDATE" clause in the subquery. Shouldn't it return false because it can't lock the row until the uncommitted update finishes? Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

pg_try_advisory_lock is waiting?

saction block on the 1st error. Is there a way to get PostgreSQL to use something like NOWAIT without aborting the transaction block? -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: PostgreSQL Management and monitoring tool

to work for Commvault Systems until May 2019, for 7 years. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Could not serialize access due to concurrent update

olationLevel custom property a. Click *New*. b. Enter *webSphereDefaultIsolationLevel* for the name field. c. Enter one of the *"possible values*" in the value field from the table above.**i.e. 0, 1, 2, 4, or 8 The value that needs to be entered is 2. ** * * -- Mla

Re: WAL Archiving and base backup

replication to work. In addition to that, pgbackrest can employ parallelism while pg_rman cannot do that. I find pgbackrest by far the best Postgres backup system. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: WAL Archiving and base backup

l such an evaluation provide? All commercial databases have some form of backup software included into the core database. After all, backup and restore are extremely important functions which IMHO should be provided along with the database software. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Assistance with an out of shared memory error

a mistake.) Interesting. What resources do partitions consume? Is it documented anywhere? Why do you think that more than a few dozen partitions is a mistake? Thanks in advance for your explanation. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: List all tables from a specific database

There is also INFORMATION_SCHEMA which is SQL standard and extremely easy to use. On Fri, Jan 14, 2022, 1:08 PM Thomas Boussekey wrote: > > > Le ven. 14 janv. 2022 à 12:04, Ray O'Donnell a écrit : > >> On 14/01/2022 10:39, Flaviu2 wrote: >> > I work on a project that use Postgre SQL, and I have

Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL

Oracle DBA that Josh Berkus is talking about in that article. Recent events with "advice" to a very well known Oracle personality testify to the fact that the emotions haven't changed much since that article was written. Of course, Oracle is still the most popular database in the w

Re: Reindex "locked" standby database

l also, in theory, populate the statistics which is also held in the database blocks. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT

On 12/6/21 22:16, Laurenz Albe wrote: An ugly alternative is to use "ORDER BY id + 0", which prevents PostgreSQL from using the index. That was actually the earliest form of Oracle hints. I remember doing exactly that in Oracle 5.1.22 on VAX/VMS. -- Mladen Gogala Database Cons

Re: Database Scalability

ostly useless, at least in my opinion. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Postgres Equivalent of Oracle Package

? You can create a temporary table with "ON COMMIT PRESERVE ROWS", which is visible in a session and cannot cross the session boundary.  Values in the table can be queried throughout the session. That is a pretty good approximation of the session variables in Oracle. -- Mladen Gogal

Re: ZFS filesystem - supported ?

). Also, when using file level utilities, I would go full commercial. Commercial backup utilities are usually optimized for speed, support deduplication and maintain backup catalog, which can come handy if there are regulatory requirements about preserving your backups (HIPPA, SOX) -- Mladen

Re: Incremental backup

On 10/29/21 09:43, Peter J. Holzer wrote: On 2021-10-29 09:03:04 -0400, Mladen Gogala wrote: On 10/29/21 08:49, Peter J. Holzer wrote: I don't think that's equivalent. An Oracle instance is a runtime concept (the collection of server processes on a single machine serving a singl

Re: Incremental backup

which are completely analogous to WAL logs, if managed a bit differently. Let's not be nitpicking here. Oracle instance is completely analogous to Postgres cluster. If you ask me, the word cluster was picked to avoid the word "instance" -- Mladen Gogala Database Consultant

Re: Incremental backup

On 10/29/21 03:30, Peter J. Holzer wrote: I was not aware that Oracle even has something equivalent to a Postgres cluster. hp It's called "Oracle instance". Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Incremental backup

are much more important things to do on Postgres than incremental database level backups. BTW, Chuck Norris can take and incremental database level backup of a Postgres database and recover database without restoring the preceding full backup. I am not sure whether Chuck Norris is a member of

Re: ZFS filesystem - supported ?

at is really interesting. Here is the gist of it: XFS is the clear winner. It also answers the question about BTRFS. Thanks Imre! -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: ZFS filesystem - supported ?

ve any results to report. The difference is imperceptible. I am primarily an Oracle DBA and I am testing with Oracle. That doesn't necessarily have to be pertinent for Postgres. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: ZFS filesystem - supported ?

et the object part for now) and the IO patterns will be similar to SQLite and MariaDB. That benchmark is brand new, done on the kernel 5.14. Of course, the only guarantee is doing your own benchmark, with your own application. -- Mladen Gogala Database Consultant Tel: (

Re: ZFS filesystem - supported ?

place to discuss the inner workings of snapshots, but it is worth knowing that snapshots drastically increase the IO rate on the file system - for every snapshot. That's where the slowness comes from. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: ZFS filesystem - supported ?

. You, of course, are right. I have erroneously thought that backup of WAL logs is implied because I always back that up. And yes, that needs to be made clear. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: ZFS filesystem - supported ?

quot; or ACS. It's documented here: https://www.ibm.com/docs/en/db2/11.1?topic=recovery-db2-advanced-copy-services-acs For Postgres, the old begin/stop backup functions should be sufficient. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: ZFS filesystem - supported ?

t who has built both Exadata and EMC XTRemIO. He is now the principal engineer of the Amazon RDS. This part is intended only for those who would tell him that "Oracle has it is not good enough" if he ever decided to post here. -- Mladen Gogala Database Consultant Tel:

Re: ZFS filesystem - supported ?

thoroughly because your performance is likely to suffer. As for the supported part, that's not a problem. Postgres supports all modern file systems. It uses Posix system calls to manipulate, read and write files. Furthermore, if you need snapshots, disk arrays like NetApp, Hitachi or EMC can

Re: WAL streaming and dropping a large table

escription and discards the old files.  Both 'drop" and "truncate" will not generate much WAL logs. On the other hand, "delete" is a regular DML transaction which will generate logs needed to recover the 200GB table. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Force re-compression with lz4

tory short, for the 3rd party backup tools LZO4 compression will yield better deduplication ratios than other forms of compression, thereby saving you space. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Force re-compression with lz4

. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Faster distinct query?

y the application code or add a trigger to populate the lookup table as needed. I fully agree with this. Adding a trigger to populate a lookup table is a standard design in situations like this. Using "DISTINCT" almost always spells trouble for the performance. -- Mladen Gogala Database

Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper

needs to know how to script. So, this is where you start: https://python.swaroopch.com/ Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: The tragedy of SQL

I love the smell of SQL in the morning. -- I'll speak the key, the whole key and nothing but the key, so help me Codd. Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: The tragedy of SQL

m with SQL. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: The tragedy of SQL

e for performance reasons. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: The tragedy of SQL

On 9/14/21 02:18, Rob Sargent wrote: All languages are fucking terrible. I like English. It's not very complex and it allows me to express myself very well. You should see my native tongue, Croatian language, from the group of Slavic languages. It's fucking terrible. -- Mla

Re: The tragedy of SQL

d that is why we all live in a yellow subroutine (this reference is not for the millennials or younger). -- I'll speak the key, the whole key and nothing but the key, so help me Codd. Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: How to observe plan_cache_mode transition from custom to generic plan?

" situation: https://xkcd.com/327/ -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: How to observe plan_cache_mode transition from custom to generic plan?

e plans or cursor sharing. Frank Pachot, an Oracle Ace, has an excellent article on the subject: https://franckpachot.medium.com/postgresql-bind-variable-peeking-fb4be4942252 -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: database design with temporary tables

d have used Postgres instead of the SQL Server, the comparison would read the same, except for the "#" character which denotes temporary table in SQL Server. Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: database design with temporary tables

x27;s precisely how application servers work. The allocate connection pool and keep them open for a very long time. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Insert statement doesn't complete

an? How do you know that the script doesn't complete? Is the script hanging?  Furthermore, what is the software version? What platform are you using? Could you help me on this issue? Insufficient data for a meaningful answer. Thanks all. Regards, Trang -- Mladen Gogala Database

Re:

s and keep only 4 latest backups. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

Re: Make bloom extension trusted, but can not drop with normal user

that idea. Regards On 8/20/21 7:01 AM, Li EF Zhang wrote: So, I want to know if extensions in contrib dir can be set "trusted" ourselves? If we can, I think drop extension should be allowed by normal user. -- Mladen Gogala Database Consultant Tel: (347) 321-

Re: Postgres Migration error - Need help

sed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com

  1   2   >