an error message that I don't understand

I get this error message: table tid from new index tuple (32586,21) overlaps with invalid duplicate tuple at offset 120 of block 4398 in index "aacorrections_tcpreading_idx" from an update query of the update table 1 set columnx = ‘yes’ where table1.xmlid in (select xmlid from table2) I have no

Re: Why is an error not thrown when the time exceeds the lock timeout for an ExclusiveLock on a transaction ?

display server side postgresql.conf varables from postgresql.conf Server-Side Timeout Configuration: 1. 1. statement_timeout

rookie question about upgrade from 13 to 17

intelligible to others like me, and there may be some. With thanks in advance Martin Mueller Professor emeritus of English and Classics Northwestern University

Re: Issue with Password Authentication for Pgpool

assuming you are implementing kubernetes kubectl exec -it $(kubectl get pods -l app.kubernetes.io/component=pgpool,app.kubernetes.io/name=postgresql-ha -o jsonpath='{.items[0].metadata.name}') -- pg_md5 -m --config-file="/opt/bitnami/pgpool/conf/pgpool.conf" -u "foo" "bar" //cat out pgpool af

Remove from distribution list

Please remove p...@mipta.com from the distribution list thank you Peter L Martin MIPTA ABN 74 843 345 087 p...@mipta.com <mailto:p...@mipta.com> Mobile Au: +61 (0)437 414 689 Todays problems will not be solved, if we think the same, as when we created them! - Albert Ei

Please remove p...@mipta.com from the List

Please remove p...@mipta.com from the List Thank you Peter L Martin MIPTA ABN 74 843 345 087 p...@mipta.com <mailto:p...@mipta.com> Mobile Au: +61 (0)437 414 689 Todays problems will not be solved, if we think the same, as when we created them! - Albert Einstein Information i

Re: Password complexity/history - credcheck?

... until they went down and looked at what might have to be done, after which it all became very quiet ... Regards, Martin.

Re: Password complexity/history - credcheck?

g at, but I'm not sure whether or not it is well adopted, reliable, and without significant issues. I only heard about it a few days ago from a friend/colleague, so I was wondering if anybody else was using it and what experiences with it might be. Regards, Martin. -- Martin Goodson.

Password complexity/history - credcheck?

obviously, but some indication of whether or not it's worth looking at first would be greatly appreciated. Is this something that the community would recommend? Many thanks! -- Martin Goodson. "Have you thought up some clever plan, Doctor?" "Yes, Jamie, I believe I have." "What're you going to do?" "Bung a rock at it."

Re: Tips on troubleshooting slow DELETE (suspect cascades)

Add an index to parent_id. What is likely happening is each time a row is deleted, it has to scan the entire table to make sure it is not referenced by any parent_id records. On Thu, Jan 18, 2024 at 12:04 PM Jim Vanns wrote: > After dropping the constraint entirely the DELETE completes in 4 > m

update from 13 to16

data via Aqua Data Studio, as if they were very large spreadsheets. Is that a correct analysis? I just want to make sure. Martin Mueller Professor emeritus of English and Classsics Northwestern University

a really dumb password question

grateful for advice. Martin Muelleer Professor emeritus of English and Classics Northwestern Univerrsity

Re: a simple-minded question about updating

I currently work with Postgres 13. I forgot to mention that. From which I gather that around version 18 it would be time to upgrade. But in the interim I’d be OK. Right? From: Adrian Klaver Date: Thursday, May 18, 2023 at 11:21 PM To: Martin Mueller , pgsql-general@lists.postgresql.org

a simple-minded question about updating

ment, which handles up to 10 million rows quite comfortably. A I right in thinking that given my tasks and equipment it would be a waste of time to update? Or is there something I’m missing? Martin Mueller Professor emeritus of English and Classiccs Northwestern University

Re: Help? Unexpected PostgreSQL compilation failure using generic compile script

On 13/03/2023 00:02, Adrian Klaver wrote: On 3/12/23 14:43, Martin Goodson wrote: Hello. For reasons I won't bore you with, we compile PostgreSQL from source rather than use the standard packages for some of our databases. So a fairly basic script that has been used for years sud

Re: Help? Unexpected PostgreSQL compilation failure using generic compile script

On 12/03/2023 21:52, Tom Lane wrote: Martin Goodson writes: So I simply removed the --with-gssapi, and tried again. AND IT FAILED AGAIN. This time it failed claiming it couldn't find the ldap library. Which is most -definitely- present. Hard to debug this sort of thing remotely when you

Help? Unexpected PostgreSQL compilation failure using generic compile script

ng. I am assuming there must be something wrong with the box/our configuration somewhere, but where to look? If anyone can help - even if it's to tell me I'm an idiot for missing one or more incredibly basic things somehow - I would be very grateful. Many thanks. Regards, M. --

Re: RLS without leakproof restrictions?

r procedure that deals with tenant-specific data, is a headache that can also complicate queries and query plans. (Am speaking for myself as a PG developer for the last 2.5 years, not for my employer.) Sincerely, Martin L Buchanan Laramie, WY, USA

Boyer-Moore string searching in LIKE, ILIKE, and/or POSITION?

s://www.postgresql.org/message-id/27645.1220635...@sss.pgh.pa.us . Sincerely, Martin L Buchanan senior software engineer Laramie, WY, USA

Re: Intervals and ISO 8601 duration

docs.yugabyte.com/preview/api/ysql/datatypes/type_datetime/conceptual-background/#two-ways-of-conceiving-of-time-calendar-time-and-clock-time > > type interval_mm_dd_ss_t as (mm, dd, ss) > > https://docs.yugabyte.com/preview/api/ysql/datatypes/type_datetime/date-time-data-types-semantics/typ

pg_multixact_member file limits

Are there any limits on the number of records in the postgresql/12/main/pg_multixact/members directory? We have a database that has grown to tens of thousands of files in this directory during an autovacuum after a large data purge. It shrank after the autovacuum completed. Martin Ritchie *Geotab

Re: integer square root function proposed

. So something for you all to think about. Best wishes, Happy Channukah, and Merry Christmas, Martin L. Buchanan software developer and writer since 1976 Laramie, WY On Sat, Dec 17, 2022 at 8:20 PM Rob Sargent wrote: > On 12/17/22 19:39, Martin L. Buchanan wrote: > > Dear PostgreSQL c

integer square root function proposed

pes). I did not see an explicit enhancement request list in the PG mailing lists. Recommendations for a more specific list to post this to are welcome. Sincerely, Martin L. Buchanan software developer Laramie, WY, USA

Re: Missing query plan for auto_explain.

category)::text = 'CASH'::text)) Filter: ((currency)::text = (users.real_base_currency)::text) Buffers: shared hit=67 Planning: Buffers: shared hit=859 Planning Time: 50.833 ms Execution Time: 5.480 ms (85 rows) On Fri, 9 Sept 2022 at 22:06, Max

Re: Missing query plan for auto_explain.

:38 PM Matheus Martin < > matheus.mar...@voidbridge.com> wrote: > >> Our Postgres recently started reporting considerably different execution >> times for the same query. When executed from our JDBC application the >> Postgres logs report an average execution time o

Re: Missing query plan for auto_explain.

`auto_explain.log_min_duration` is set to 500 ms. On Mon, 5 Sept 2022 at 12:35, Peter J. Holzer wrote: > On 2022-09-02 10:58:58 +0100, Matheus Martin wrote: > > Yes, we do see some plans logged by the auto_explain. We couldn't find a > > `auto_explain.log_min_duration

Re: Missing query plan for auto_explain.

ic we have, we cannot lower the threshold for the auto_explain. `log_lock_waits` is turned on and the logs do not indicate any locks related to the tables in the query. On Fri, 2 Sept 2022 at 05:49, Julien Rouhaud wrote: > Hi, > > On Thu, Sep 01, 2022 at 08:20:13PM +0100, Matheus Martin

Re: Missing query plan for auto_explain.

rt it? On Tue, 30 Aug 2022 at 17:45, Alvaro Herrera wrote: > On 2022-Aug-30, Matheus Martin wrote: > > > Good idea on using an actual prepared statement but unfortunately it > didn't > > produce any different result. > > I should have also mentioned to try the EXPLA

Re: Missing query plan for auto_explain.

The threshold for `auto_explain` was changed to 500 ms and explain plans are still not being logged. On Tue, 30 Aug 2022 at 13:30, Julien Rouhaud wrote: > Hi, > > On Tue, Aug 30, 2022 at 01:16:43PM +0200, Alvaro Herrera wrote: > > On 2022-Aug-30, Matheus Martin wrote: > &g

Re: Missing query plan for auto_explain.

> On 2022-Aug-30, Matheus Martin wrote: > > > Our Postgres recently started reporting considerably different > > execution times for the same query. When executed from our JDBC > > application the Postgres logs report an average execution time of 1500 > > ms but whe

Missing query plan for auto_explain.

Our Postgres recently started reporting considerably different execution times for the same query. When executed from our JDBC application the Postgres logs report an average execution time of 1500 ms but when the query is manually executed through `psql` it doesn't take longer than 50 ms. With a

Re: "Missing" column in Postgres logical replication update message

Thanks for the response, Tom. I think that's exactly what's going on here. On Wed, Aug 3, 2022 at 11:28 AM Tom Lane wrote: > Adrian Klaver writes: > > On 8/3/22 08:09, Kevin Martin wrote: > >> I thought that any UPDATE message in the replication logs is designed

Re: "Missing" column in Postgres logical replication update message

My apologies. Read that in the mailing list instructions, and still forgot. Thanks for the reminder. On Wed, Aug 3, 2022 at 11:12 AM Adrian Klaver wrote: > On 8/3/22 08:09, Kevin Martin wrote: > > Please reply to list also > Ccing list > > I don't have answers to be

"Missing" column in Postgres logical replication update message

We have a replication slot set up on a database in Postgres 12.8. For one of the tables, when a row is created, we see a series of records come through - an INSERT followed by a handful of UPDATEs. All of these messages in the WAL files show all columns, except for the last UPDATE message, which is

Re: Proposal to introduce a shuffle function to intarray extension

Am 16.07.22 um 18:53 schrieb Mladen Gogala: On 7/15/22 04:36, Martin Kalcher wrote: Dear list, i am dealing with an application that processes fairly large arrays of integers. It makes heavy use of the intarray extension, which works great in most cases. However, there are two requirements

Proposal to introduce a shuffle function to intarray extension

51 ms I would like to see a function like this inside the intarray extension. Is there any way to get to this point? How is the process to deal with such proposals? Best regards, Martin Kalcher Source code of extension mentioned above: #include "postgres.h" #include &q

a very naive question about table names in Postgres

mapping and how can I query it? On what page of the documentation do I find the answer? I much prefer Postgres to Mysql for a variety of reasons, but mostly for its elegant string functions. But in Mysql it seems to be much easier to keep track of tables. Martin Mueller Professor emeritus of

Re: The tragedy of SQL

javascript.. gross! Martin Ritchie *Geotab* Senior DBA Direct +1 (519) 741-7660 Toll-free +1 (877) 436-8221 Visit www.geotab.com Twitter <https://twitter.com/geotab> | Facebook <https://www.facebook.com/Geotab> | YouTube <https://www.youtube.com/user/MyGeotab> | LinkedIn <https://www

Re: Problem with connecting with named host parameter

On Fri, 27 Aug 2021 at 15:00, Tom Lane wrote: > Mike Martin writes: > > I am getting the following error when I connect with hostname on > localhost > > > psql -h capture -U -p 5432 > > psql: error: FATAL: no pg_hba.conf entry for host > > "fe80::72

Problem with connecting with named host parameter

Hi I am getting the following error when I connect with hostname on localhost psql -h capture -U -p 5432 psql: error: FATAL: no pg_hba.conf entry for host "fe80::7285:c2ff:feb0:cd4%eth0", user "usevideo", database "usevideos", SSL off The hba.conf is local all all

A simple question about text fields

Are there performance issues with the choice of 'text' vs. varchar and some character limit? For instance, if I have a table with ten million records and text fields that may range in length from 15 to 150, can I expect a measurable improvement in response time for using varchar(150) or will t

Re: Failed to initialize 13.2-1 cluster on Windows

Update: I've just tried with version 12.6-1 and works perfectly fine. Clearly, there is some bug in the 13.2-1 published version. On 2021-03-31 16:35, Martin wrote: Hello, I'm trying to install 13.2-1 on Windows 10. Previous version was 10.5, installed using the EnterpriseDB

Failed to initialize 13.2-1 cluster on Windows

previous Windows installations. Would that be something to try? I'm running out of ideas for what else to try. Any help will be much appreciated. Regards, Martin

Re: Encryption of Data Specific to a Tenant in PostgreSQL database | General Idea

than a couple, but less than 50 or so, then best to give them all separate schemas. If there are thousands of tenants (like an internet application) then security barrier views are usually the easiest option to manage. Martin Ritchie *Geotab* Senior DBA Direct +1 (519) 741-7660 Toll-free +1 (877

Re: Should pgAdmin 3 be saved?

a PgAdmin 3) functional in parallel to the newer Hosted Web Version of PgAdmin (aka PgAdmin 4). regards, gm Le sam. 6 févr. 2021, à 14 h 26, Tom Lane a écrit : > > Gabriel Martin writes: > > Do you think there's a possibility that people could fix pgAdmin 3, even if > >

Should pgAdmin 3 be saved?

Hello, I know that since the launch of pgAdmin 4 in 2016, pgAdmin has been using a web-based model, as announced as early as 2014. You only need to do a little research on the Web to understand all the reasons behind this choice, which I do not seek to question. However, I wonder if it would be r

Re: PL/java

Nota Bene: Almost all official interfaces to/from Oracle are coded in Java FWIK google's implementations are 95% python (although you would need to understand JSON formatting for import/export requirements) for those reasons i tread lightly before disparaging either language Going Forward: try to

Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...

On 02/12/2020 23:46, Dave Cramer wrote: On Sun, 29 Nov 2020 at 14:09, Martin Goodson wrote: On 29/11/2020 18:46, David G. Johnston wrote: On Sun, Nov 29, 2020 at 11:06 AM Martin Goodson Hello. I wonder if anyone can assist with this? Some of my developers are reporting that they are

Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...

On 29/11/2020 18:46, David G. Johnston wrote: On Sun, Nov 29, 2020 at 11:06 AM Martin Goodson wrote: Hello. I wonder if anyone can assist with this? Some of my developers are reporting that they are getting the following message when attempting to connect to the database using jdbc: Caused

Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...

On 29/11/2020 18:28, Adrian Klaver wrote: On 11/29/20 10:22 AM, Martin Goodson wrote: On 29/11/2020 18:10, Adrian Klaver wrote: On 11/29/20 10:06 AM, Martin Goodson wrote: Hello. I wonder if anyone can assist with this? Some of my developers are reporting that they are getting the

Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...

On 29/11/2020 18:10, Adrian Klaver wrote: On 11/29/20 10:06 AM, Martin Goodson wrote: Hello. I wonder if anyone can assist with this? Some of my developers are reporting that they are getting the following message when attempting to connect to the database using jdbc: Caused by

"Server versions prior to 8.0 do not support savepoints" when using JDBC ...

s. Regards, M. -- Martin Goodson Whatever you've got planned, forget it. I'm the Doctor. I'm 904 years old. I'm from the planet Gallifrey in the constellation of Kasterborous. I am The Oncoming Storm, the Bringer of Darkness and you are ... basically just a rabbit, aren&

Re: Return value of CREATE TABLE

Thanks , exactly what I was looking for On Thu, 10 Sep 2020 at 13:16, Christoph Moench-Tegeder wrote: > ## Mike Martin (redt...@gmail.com): > > > So basically I would like to be able to know what namespace a temp table > is > > created in, so that I can constrain lookup.

Return value of CREATE TABLE

Is this possible? Basically I want to manage temp table status for use in a procedure. The procedure looks at pg_catalog to get information for processing. So basically I would like to be able to know what namespace a temp table is created in, so that I can constrain lookup. example CREATE TEMP

Stored procedure with execute and returning clause

Hi I am having difficulty with returning clause and stored procedure. This is an (edited) example of where I am CREATE OR REPLACE PROCEDURE public.arrcopy1( dataarr anyarray, tblname text, cols text DEFAULT NULL::text, selstr text DEFAULT NULL::text, INOUT outarr text[] DE

Re: Certficates

cant you use keytool ? assume server certificate is called server.crt assume truststore file is called server.truststore.jks cd %JRE_HOME%/lib/security keytool -import -alias %ALIAS% -file server.crt -keystore server.truststore.jks m. From: Shankar Bhaskaran Sent

Is it possible to use keywords (date units) in a function definition?

Hello, I recently tried to write a wrapper function to calculate the difference between two dates, mainly as a convenience. I'd essentially be emulating EXTRACT( FROM date1 - date2), in various ways. I got a bit stuck on allowing specification of the : is this possible in function definitions?

Re: Oracle vs. PostgreSQL - a comment on Mysql

On the topic of what other databases do better: I much prefer Postgres to Mysql because it has better string functions and better as well as very courteous error messages. But MySQL has one feature that sometimes makes me want to return it: it stores the most important metadata about tables in a

Re: full text

i dont know how to do with elastic-search according to programcreek you can create an index from a jdbc source https://www.programcreek.com/java-api-examples/?code=SeldonIO/semantic-vectors-lucene-tools/semantic-vectors-lucene-tools-master/src/main/java/io/seldon/semvec/CreateLuceneIndexFromDb.j

Re: MS Access Frontend

n Klaver > Sent: Saturday, November 30, 2019 01:52 PM > To: Jason L. Amerson ; 'Martin Gainty' > ; PostgreSQL > Subject: Re: MS Access Frontend > > On 11/30/19 11:04 AM, Jason L. Amerson wrote: >> Thanks Martin. I have decided to go another route. I have nothing but >&

Re: MS Access Frontend

Leaving aside the question of money, a frontend like AquaData Studio or the equivalent program by Jetbrains would be a much better solution. I used to work with Access a lot and quite liked it. But AquaData Studio is not any more difficult to learn and gives you access to everything Postgress ca

Finding out about the dates of table modification

ified table. Which is really useful if you have a bad memory, as I do, and can't remember the name of a particular table that I worked on last Wednesday. Are those capabilities hidden somewhere in Postgres? There isn't an obvious section in the documentation. At least I can't find

Drop a primary

I created a primary key with the following commands Add id serial Add primary key (id) I cannot figure out from the documentation how to drop that column.

SV: Databases and servers

Från: Peter J. Holzer Skickat: den 20 augusti 2019 22:58 Till: pgsql-general@lists.postgresql.org Ämne: Re: Databases and servers On 2019-08-20 10:33:17 +, Karl Martin Skoldebrand wrote: > I just discovered that a client has done this: > >

SV: Databases and servers

On Tue, Aug 20, 2019 at 6:33 AM Karl Martin Skoldebrand mailto:ks0c77...@techmahindra.com>> wrote: Hi, I just discovered that a client has done this: They have two web applications A1 and A2. They have seperate hostnames/URLs. Both have a production and a test database A1p and A1t/ A

Databases and servers

Hi, I just discovered that a client has done this: They have two web applications A1 and A2. They have seperate hostnames/URLs. Both have a production and a test database A1p and A1t/ A2p and A2t. What they've done is have both A1p and A2p on the same actual databaser server and A1t and A2

RE: Too short field

Valid point. I've added that to the report. Best regards, Martin Skjoldebrand Disclaimer: This message and the information contained herein is proprietary

RE: Too short field

Thanks. That is what I thought - good to have a confirmation. Best regards, Martin S Disclaimer: This message and the information contained herein is proprietary and

Too short field

can I just go on running the app as is. Do we need to restart databases or something else that requires an interrupted service? Best regards, Martin S Disclaimer: This me

RE: Sequences part 2

t the moment. Either way it's not a quick fix for someone fairly inexperienced with PostgreSQL and having a couple of days to holiday. //Martin S Disclaimer: This me

RE: Sequences part 2

Karl Martin Skoldebrand schrieb am 02.07.2019 um 12:44: > Looking more at sequences, I have some sequences that start with ID 1, > incrementing each record by 1. > > So I have e.g. 1 Spain 2. Germany 3. France 4. Ireland 5. Norway > > Now I want to insert more countries,

Sequences part 2

be easy as I understood it? But can I achieve this: 1 Spain 2. Germany 3. France 4. Greece 5. Latvia 6. Cyprus 7. Ireland 8. Norway That is inserting records in the middle of the records, maybe even 1 Spain 2. Germany 3. France 4. Greece 5. Ireland 6. Norway 14. Latvia 24. Cyprus //Martin S

RE: sequences

Thanks for replies. I looked at some tutorial page and there were more instructions in that, so got confused. I was aware sequences create integers. //Martin S

sequences

ce db_table_seq owner to dbnameuser; (all names obfuscated) To me it look like the only thing going is changing the ownership of the sequence. For unknown reasons. What is your impression the intention is with th

INSERT where not exists with foreign key

work because the subquery returned more than one value. Of course I want it to return all values, but just one per insert. I can do this outside of Postgres, but would like to learn how to do this with SQL. Chuck Martin Avondale Software

Column type changed "spontanously"?

reSQL 9.3.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit" What other information would help solve this? Chuck Martin Avondale Software

Re: Query not producing expected result

where I once lived). Chuck Martin Avondale Software On Wed, May 1, 2019 at 1:52 PM Francisco Olarte wrote: > On Wed, May 1, 2019 at 7:37 PM Chuck Martin > wrote: > > > > Something like daterange would be a solution in some circumstances, but > this query is a user-generated

Re: Query not producing expected result

(given the advice received here) inclined to check the value entered when searching for a date, and if no time is entered, add '24:00' to the date. Chuck Martin Avondale Software On Wed, May 1, 2019 at 1:32 PM Adrian Klaver wrote: > On 5/1/19 10:15 AM, Francisco Olarte wrote: > >

Re: Query not producing expected result

;May 2, 2019' wouldn't it? I'm not sure one is easier to implement than the other. Chuck Martin Avondale Software On Wed, May 1, 2019 at 1:16 PM Francisco Olarte wrote: > Chuck: > > On Wed, May 1, 2019 at 6:56 PM Chuck Martin > wrote: > > Thanks, guys. It

Re: Query not producing expected result

Thanks, guys. It should have been obvious to me, but wasn't. I found the correct result was returned with either AND event.DateTime <= 'May-1-2019 24:00' or AND event.DateTime::date <= 'May-1-2019' The latter seems best. Chuck Martin Avondale Software On W

Query not producing expected result

g the data comparison correctly, but don't know why. Chuck Martin Avondale Software

Re: analyze causes query planner to choose suboptimal plan for a select query in separate transaction

I’ve got it now, thank you for the clarification. You are right. Martin Kováčik +421904236791 > On 26 Apr 2019, at 00:25, Adrian Klaver wrote: > >> On 4/25/19 1:28 PM, Martin Kováčik wrote: >> I'm not sure if I understand what you mean. My initial thought was that

Re: analyze causes query planner to choose suboptimal plan for a select query in separate transaction

ion was it is isolated like other statements. *Martin Kováčik* *CEO* *redByte*, s.r.o. +421 904 236 791 kova...@redbyte.eu, www.redbyte.eu <http://redbyte.eu> On Thu, Apr 25, 2019 at 9:58 PM Adrian Klaver wrote: > On 4/25/19 12:47 PM, Martin Kováčik wrote: > > As my example shows y

Re: analyze causes query planner to choose suboptimal plan for a select query in separate transaction

my own analyze after bulk insert as you suggested. Initially I thought that inside a transaction stats are automatically updated after the inserts because the query ran much faster than the query which was based on statistics with no rows. I did not realize the planner chooses a "default" pla

Re: analyze causes query planner to choose suboptimal plan for a select query in separate transaction

ooses wrong plans. *Martin Kováčik* *CEO* *redByte*, s.r.o. +421 904 236 791 kova...@redbyte.eu, www.redbyte.eu <http://redbyte.eu> On Thu, Apr 25, 2019 at 9:28 PM Michael Lewis wrote: > > > On Thu, Apr 25, 2019, 11:34 AM Martin Kováčik wrote: > >> Turning off autova

Re: analyze causes query planner to choose suboptimal plan for a select query in separate transaction

rwise fine select query. I was puzzled by this behavior back then but now it makes sense. *Martin Kováčik* *CEO* *redByte*, s.r.o. +421 904 236 791 kova...@redbyte.eu, www.redbyte.eu <http://redbyte.eu> On Thu, Apr 25, 2019 at 5:26 PM Michael Lewis wrote: > I assume it is in the docume

analyze causes query planner to choose suboptimal plan for a select query in separate transaction

rows=1 width=8) (actual time=0.003..0.057 rows=1000 loops=100900) -> Seq Scan on a a8 (cost=0.00..5.00 rows=1 width=8) (actual time=0.003..0.057 rows=1000 loops=100900) Planning Time: 0.522 ms Execution Time: 81483.797 ms (36 rows) What do you think, is this intended behavior or a potential bug ? Regards, Martin *Martin Kováčik* *CEO* *redByte*, s.r.o. +421 904 236 791 kova...@redbyte.eu, www.redbyte.eu <http://redbyte.eu>

RE: Transactions

: 09 April 2019 11:41 To: pgsql-general@lists.postgresql.org Subject: Sv: Transactions På tirsdag 09. april 2019 kl. 11:26:29, skrev Karl Martin Skoldebrand mailto:ks0c77...@techmahindra.com>>: Hi, Is there a way to track “transactions” by default (i.e. without anyone having set up an

Transactions

Hi, Is there a way to track "transactions" by default (i.e. without anyone having set up anything specific). The problem I am facing is that users are claiming that settings are disappearing with them doing anything to affect them. It would be good to be able to see what postgresql thinks is go

Is it possible to have a cascade upwards query?

As per title, is this possible? Scenario being two tables with a linking pair of fields, where one table is a superset of the other and key is generated by the second table I would like to have the record in table two deleted when I delete the record in table 1 Thanks

Re: software or hardware RAID?

screen. I never know if adding an HD to an exiting raid will wipe it or > maintain it. > 4) I setup smartctl to watch and report on drives. Even a 50% chance it > detects before failure is a net benefit. You cant always to that through > hardware raid > > You can always start with

Re: Where to store Blobs?

I store them as bytea in the database despite the fact that there are benefits to storing them in the file system. The reason is that it is easier to secure access to the database than to secure both the database and provide secure access to the file system. Chuck Martin Avondale Software On

Re: crosstab function

26/19, 8:04 PM, "Adrian Klaver" wrote: On 2/26/19 5:51 PM, Martin Mueller wrote: > I run Postgres 10.5. I understand that there is something called > tablefunc and it includes a crosstab function. On Stack Overflow I learn > that you import this function. But

crosstab function

EXTENSION IF NOT EXISTS tablefunc; but it did nothing. It doesn’t seem to work as import statements in Python do - Martin Mueller Professor emeritus of English and Classics Northwestern University

Re: HAVING query structured wrong

On Mon, Feb 18, 2019 at 12:37 PM Andrew Gierth wrote: > >>>>> "Chuck" == Chuck Martin writes: > > Chuck> I am trying to create a query that returns all transactions for > Chuck> each person who has a balance over a given amount. I thought > Ch

HAVING query structured wrong

o how do I get all transactions for each case_pkey? I've read the documentation on WITH clauses (CTEs), but that just left my head spinning. Chuck Martin Avondale Software

Re: Connection issue

Hi, Can you read the event viewer? Obtener Outlook para Android<https://aka.ms/ghei36> From: Adrian Klaver Sent: Wednesday, February 6, 2019 1:43:24 PM To: Maximilian Tyrtania Cc: Ricardo Martin Gomez; pgsql-general@lists.postgresql.org Subject: Re: Conn

RE: Connection issue

Hi, Can you do some tests in both (Mac and Windows ) ? * telnet {IP_Server} {5432} * ping {IP_Server} * tracert {IP_Server} Regards __ Saludos Ing. Ricardo Martín Gomez DBA - SysAdmin De: Adrian Klaver Enviado: martes, 5 de febrero

Re: Query help

On Sun, Jan 27, 2019 at 5:27 PM Chuck Martin wrote: > On Sun, Jan 27, 2019 at 8:07 AM Peter J. Holzer wrote: > >> On 2019-01-26 18:04:23 -0500, Chuck Martin wrote: >> [snip] >> > The idea should be obvious, but to explain, insdatetime is set when a >> new &g

Re: Query help

On Sun, Jan 27, 2019 at 8:07 AM Peter J. Holzer wrote: > On 2019-01-26 18:04:23 -0500, Chuck Martin wrote: > [snip] > > The idea should be obvious, but to explain, insdatetime is set when a new > > record is created in any table. All records in ombcase have a foreign > k

  1   2   >