Re: Was my question inappropriate for postgres?

On 25/07/22 12:31, Mladen Gogala wrote: On 7/24/22 20:15, Gavin Flower wrote: I suspect that most people do not know what 'M365' is, would be good to explain.  Am curious as to what 'M365' is! M365 is the latest member in the ArmaLite M-16 family of products. It can be c

Re: Was my question inappropriate for postgres?

On 25/07/22 12:19, Adrian Klaver wrote: On 7/24/22 17:15, Gavin Flower wrote: On 25/07/22 11:56, Taka Taka wrote: Hello. I suspect that most people do not know what 'M365' is, would be good to explain.  Am curious as to what 'M365' is! New branding and pricing(subscr

Re: Was my question inappropriate for postgres?

On 25/07/22 11:56, Taka Taka wrote: Hello. I posted question bellow. Hello. I would like to know if psqlodbc_13_02 is compatible with M365. Also, could you please tell me which of the psqlodbc_13_02 would be suitable to Windows 10 64-bit? Was my question inappropriate? I wanted to know if the p

Re: a very naive question about table names in Postgres

On 1/01/22 09:27, Martin Mueller wrote: I have a very naïve question and don’t know where tp  look for the answer.  I use Postgres via AquaData Studio as a giant spreadsheet.  I create tables and give them names. I see the table names  and know how to manipulate them with simple SQL queries.

Re: [EXTERNAL] Re: Inserts and bad performance

On 28/11/21 17:17, Godfrin, Philippe E wrote: Right you are sir! I figured that out a few hours ago! pg *From:* Ron *Sent:* Wednesday, November 24, 2021 10:58 PM *To:* pgsql-general@lists.postgresql.org *Subject:* [EXTERNAL] Re: Inserts and bad performance On 11/24/21 1:15 PM, Godfrin, Phili

Re: "two time periods with only an endpoint in common do not overlap" ???

On 16/10/21 18:41, David G. Johnston wrote: On Friday, October 15, 2021, Ron wrote: Prima facie, if you were told "numbers in the range 0-10", would you really think, "ah, they *really* mean 0 through 9"? I would indeed default to both endpoints of the range being inclusive.  I also

Re: JOB | DBA (Canada)

On 15/10/21 02:00, James Tobin wrote: Hello, we are working with an employer that is looking to hire someone capable of managing Mongo and Sybase databases at their office in Canada. Consequently, I had hoped that some members of this list may like to discuss further. Kind regards, James If t

Re: Timestamp with vs without time zone.

On 22/09/21 20:11, Tim Uckun wrote: I'll add another layer of complication. You have a database server hosted in Australia, and that's also where your web server and api server is. You have customers all over the world though so you set up additional API servers in Europe, USA, Japan etc. A kor

Re: Question about behavior of conditional indexes

On 21/09/21 22:28, Koen De Groote wrote: Greetings all, Working on postgres 11. I'm researching an index growing in size and never shrinking, and not being used anymore after a while. The index looks like this: |"index002" btree (action_performed, should_still_perform_action, action_perfor

Re: The tragedy of SQL

On 17/09/21 23:49, Raymond Brinzer wrote: On Tue, Sep 14, 2021 at 9:06 AM Merlin Moncure wrote: I've long thought that there is more algebraic type syntax sitting underneath SQL yearning to get out. I wanted to come back to this, because I've been looking to take a single problem (from my pers

Re: The tragedy of SQL

On 17/09/21 11:29, Guyren Howe wrote: [...] The set theory is the _point_. SQL is a gargantuan distraction from using it efficiently. Imagine if COBOL was the only widely-available programming language with functions. You might use it, because functions are really great abstraction for progra

Re: Alter and move corresponding: was The tragedy of SQL

On 17/09/21 11:22, Rob Sargent wrote: As far as alter, in 1981, before I became a programmer, I asked my Cobol Programmer friend if there was anything you could put in a program that would get you fired. He said yes, the alter statement :-). In my 3 semesters of Cobol, I never once used the Alte

Re: Alter and move corresponding: was The tragedy of SQL

On 16/09/21 04:52, Steve Litt wrote: Gavin Flower said on Wed, 15 Sep 2021 13:49:39 +1200 Hi Michael, [snip] COBOL has strange verbs like 'move corresponding' that could accomplish complicated tasks in a few lines but you have to be careful that you knew what you were asking fo

Re: The tragedy of SQL

On 17/09/21 04:26, Michael Nolan wrote: In the same 1971 seminar where we studied Algol-68, we had to read and write a short paper on the 1970 Codd paper on relational  theory, which had only been out for about a year.  The professor running the seminar noted that Codd proved that the relationa

Re: Alter and move corresponding: was The tragedy of SQL

On 16/09/21 05:47, Michael Nolan wrote: When I was working at the help desk at the computer center as an undergrad, the professor in charge of that group used to give us interesting little language tests for things we needed to watch out for, especially with beginning programmers. One of his

Re: The tragedy of SQL

Hi Michael, Appropriate comments interspersed below. I'm happy writing SQL and moderately competent using it.  But like all the languages I've used, without exception, it has its pain points. Cheers, Gavin On 15/09/21 11:25, Michael Nolan wrote: Of all the languages I wrote in, I think SNOB

Re: The tragedy of SQL

On 15/09/21 10:30, Peter J. Holzer wrote: On 2021-09-14 16:51:39 -0400, Mladen Gogala wrote: As software engineers, we are very much opposed to poetry, especially those among us using Perl. When I learned Perl, Perl poetry was a real thing! hp Perl is too verbose, use APL!  See: htt

Re: The tragedy of SQL

On 15/09/21 04:10, Michael Nolan wrote: I started programming in 1967, and over the last 50+ years I've programmed in more languages than I would want to list.  I spent a decade writing in FORTRAN on a GA 18/30 (essentially a clone of the IBM 1130) with limited memory space, so you had to write

Re: Series of 10 questions about the use of postgresql, generally.

On 6/08/21 4:45 pm, A Z wrote: I have been going through the free online book LEARNING postgresql book, that has been compiled by Stack Overflow contributors. I have gotten to the point where I have the following series of unanswered questions: [...] 9. What does the VARYING keyword do to a

Re: Why is Postgres only using 8 cores for partitioned count? [Parallel Append]

On 14/02/2021 22:47, David Rowley wrote: On Sun, 14 Feb 2021 at 13:15, Seamus Abshere wrote: The comment from Robert says: (src/backend/optimizer/path/allpaths.c) /* * If the use of parallel append is permitted, always request at least * lo

Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?

On 24/09/2020 18:13, Tony Shelver wrote: On 9/23/20 11:51 AM, tutilu...@tutanota.com  wrote: >     Huh? A schema is just a name space, why does it matter how the >     extension chooses to define it? I mean you could have number of >     permutations of p

Re: Issues of slow running queries when dealing with Big Data

On 29/07/2020 03:51, Shaozhong SHI wrote: Hi, Please find the result of select name, setting, source from pg_settings where source <> 'default'; Regards, Shao On Tue, 28 Jul 2020 at 16:42, Michael Lewis > wrote: On Tue, Jul 28, 2020 at 7:59 AM Shaozhong SH

Re: Issues of slow running queries when dealing with Big Data

On 28/07/2020 22:54, Shaozhong SHI wrote: It has been found that issues occur when Big Data is being handled with PostGIS. Typically, queries can be killed by the system or memory is out.  Often, queries can be very slow.  Sometimes, it will take days or weeks to complete. What are the best a

Re: Inherited an 18TB DB & need to backup

On 17/05/2020 08:12, Ron wrote: On 5/16/20 7:18 AM, Rob Sargent wrote: O Another problem is storage devices fail.  S3 storage lakes _should_ be checking your data integrity on a regular basis and possibly maintaining copies of it iin multiple locations so you're not vulnerable to a site disas

Re: Work hours?

On 28/08/2019 15:22, Christopher Browne wrote: On Tue, Aug 27, 2019, 6:27 PM stan > wrote: I am just starting to explore the power of PostgreSQL's time and date functionality. I must say they seem very powerful. I need to write a function that, given a mon

Re: Variable constants ?

On 16/08/2019 09:27, Rich Shepard wrote: On Thu, 15 Aug 2019, stan wrote: I need to put a few bossiness constants, such as a labor rate multiplier in an application. I am adverse to hard coding these things. The best plan i have come up with so far is to store them in a table, which would hav

Re: Error XX000 After pg11 upgrade

On 16/08/2019 04:35, Simon Windsor wrote: Hi The Full system used to in an Oracle DB and was ported to Postgres 9.5 about 2+ years ago, and partitioned using inheritance tables. Since then pg_upgrade has been used to upgrade to pg10 (with apt upgrade to take to 10.5 occasionally). Last wee

Re: migrating from Oracle to PostgreSQL 11

On 11/07/2019 17:53, Hitesh Chadda wrote: Hello, The target is PostgreSQL 10.1. I would like to know possible approach that can be followed for doing the migration. Regards H.kumar On Wednesday, June 26, 2019, Hitesh Chadda > wrote: Hi PostgresSQL Supp

Re: Too short field

On 03/07/2019 23:30, Karl Martin Skoldebrand wrote: Hi, We solved the problem of yesterday where I was looking at sequences. It eventually turned that sequence was irrelevant (at least in the PostgreSQL sense) to the problem. Now, we have a bug in another application that prevents an automa

Re: General question about OS

On 10/06/2019 09:45, Drexl Spivey wrote: Hello all, Don't want to start one of those endless internet tug of wars without end threads, but would like some other people's opinions. First off, I use all Operating systems without problems, personally defaulting to linux at home, but mostly mac

Re: Questions about btree_gin vs btree_gist for low cardinality columns

On 01/06/2019 14:52, Morris de Oryx wrote: [...] For an example, imagine an address table with 100M US street addresses with two character state abbreviations. So, say there are around 60 values in there (the USPS is the mail system for a variety of US territories, possessions and friends in th

Re: how to add more than 1600 columns in a table?

On 25/04/2019 10:55, Alvaro Herrera wrote: On 2019-Apr-24, pabloa98 wrote: Regarding to (2), We are good by adding a patch and recompile a patched version for our server databases. But we are open on helping to add thousands of columns support as a compile-time parameter if there are other peo

Re: how to add more than 1600 columns in a table?

On 25/04/2019 10:11, pabloa98 wrote: Thank you Joe! I will take a look Pablo On Wed, Apr 24, 2019 at 1:47 PM Joe Conway > wrote: [...] Hi Pablo, The convention here is to bottom post, or to intersperse comments, like in all the replies to you. So it would be ap

Re: Multicolumn index for single-column queries?

On 19/04/2019 14:01, Gavin Flower wrote: [...] Also there will be fewer index entries per block for the multi_index, which is why the I/O count will be higher even in the best case where there is an equal number of rows referenced by each index entry. Not sure why my system had this still

Re: Multicolumn index for single-column queries?

On 19/04/2019 01:47, Harald Fuchs wrote: Andreas Kretschmer writes: Am 18.04.19 um 08:52 schrieb rihad: Hi. Say there are 2 indexes:     "foo_index" btree (foo_id)     "multi_index" btree (foo_id, approved, expires_at) foo_id is an integer. Some queries involve all three columns in thei

Re: Multicolumn index for single-column queries?

On 19/04/2019 01:47, Harald Fuchs wrote: Andreas Kretschmer writes: Am 18.04.19 um 08:52 schrieb rihad: Hi. Say there are 2 indexes:     "foo_index" btree (foo_id)     "multi_index" btree (foo_id, approved, expires_at) foo_id is an integer. Some queries involve all three columns in thei

Re: Multicolumn index for single-column queries?

On 19/04/2019 02:12, Ron wrote: On 4/18/19 8:45 AM, Gavin Flower wrote: On 19/04/2019 01:24, Ron wrote: On 4/18/19 2:14 AM, Andreas Kretschmer wrote: [snip] (Prefix compression would obviate the need for this question. Then your multi-column index would be *much* smaller.) True, but a

Re: Multicolumn index for single-column queries?

On 19/04/2019 01:24, Ron wrote: On 4/18/19 2:14 AM, Andreas Kretschmer wrote: Am 18.04.19 um 08:52 schrieb rihad: Hi. Say there are 2 indexes:     "foo_index" btree (foo_id)     "multi_index" btree (foo_id, approved, expires_at) foo_id is an integer. Some queries involve all three columns

Re: Multicolumn index for single-column queries?

On 18/04/2019 18:52, rihad wrote: Hi. Say there are 2 indexes:     "foo_index" btree (foo_id)     "multi_index" btree (foo_id, approved, expires_at) foo_id is an integer. Some queries involve all three columns in their WHERE clauses, some involve only foo_id. Would it be ok from general perf

Re: AW: Postgres Enhancement Request

Hi Markus, Please see comment at the bottonm of this email! On 21/03/2019 05:36, Zwettler Markus (OIZ) wrote: Yes, that would be totally ok. Like the "with [grant|admin] option" privilege model in SQL. It should be done with all these predefined top-level database roles like CREATEROLE. It's

Re: POSTGRES/MYSQL

On 12/03/2019 09:40, Thiemo Kellner wrote: Quoting Adrian Klaver : On 3/11/19 9:31 AM, Sonam Sharma wrote: Hi Adrian, Ours is retail company and the DB size is Max 30gb, currently we are using db2. Things to consider: 1) Migration tools for DB2 --> MySQL/Postgresql. I have not done this,

Re: POSTGRES/MYSQL

On 12/03/2019 05:35, Michael Nolan wrote: [...]  MySQL is better at isolating users from each other and requires less expertise to administer. [...] I keep reading that MySQL is easier to administer, but never seen any evidence of that.  And in my very limited experience of both, I've found

Re: simple division

On 06/12/2018 02:32, Adrian Klaver wrote: On 12/5/18 4:45 AM, Gavin Flower wrote: On 06/12/2018 00:05, Geoff Winkless wrote: On Wed, 5 Dec 2018 at 09:13, Gavin Flower wrote: SELECT ceil(10/4.0); Geoff If you divide one integer by another, then it is logical to get an integer as as the

Re: simple division

On 06/12/2018 00:05, Geoff Winkless wrote: On Wed, 5 Dec 2018 at 09:13, Gavin Flower wrote: SELECT ceil(10/4.0); Is what you want for that example. Except that implies that "number of people who can fit in a car" is a real number, not a whole. IMO it's fundamentally broken t

Re: simple division

On 05/12/2018 20:07, Rob Sargent wrote: On Dec 4, 2018, at 9:33 PM, Gavin Flower wrote: On 05/12/2018 10:51, Rob Sargent wrote: On 12/4/18 2:36 PM, Martin Mueller wrote: It worked, and I must have done something wrong. I'm probably not the only person who would find something lik

Re: simple division

On 05/12/2018 10:51, Rob Sargent wrote: On 12/4/18 2:36 PM, Martin Mueller wrote: It worked, and I must have done something wrong. I'm probably not the only person who would find something like the following helpful: division (integer division truncates the result)    10/3    3 The math ty

Re: surprising query optimisation

On 01/12/2018 04:33, Stephen Frost wrote: Greetings, * Chris Withers (ch...@withers.org) wrote: On 28/11/2018 22:49, Stephen Frost wrote: * Chris Withers (ch...@withers.org) wrote: We have an app that deals with a lot of queries, and we've been slowly seeing performance issues emerge. We take

Re: surprising query optimisation

On 29/11/2018 11:26, Chris Withers wrote: Hi All, We have an app that deals with a lot of queries, and we've been slowly seeing performance issues emerge. We take a lot of free form queries from users and stumbled upon a very surprising optimisation. So, we have a 'state' column which is a 3

Re: Open Source tool to deploy/promote PostgreSQL DDL

On 11/07/18 11:04, Hustler DBA wrote: Thanks Adrian and Rich, I will propose sqitch to the client, but I think they want something with a GUI frontend. They want to deploy database changes, track which environments the change was deployed to, be able to rollback a change (with a rollback scr

Re: Database name with semicolon

On 29/06/18 04:22, joby.john@nccgroup.trust wrote: Pavel Stehule wrote 2018-06-28 12:10 GMT+02:00 please, can you try '"db; name"' .. double quotes nested in apostrophes I tried this with no luck. Also tried the other way, apostrophe nested in double quotes with same results. Looks

Re: Code of Conduct plan

On 08/06/18 17:09, Christophe Pettus wrote: [...] It is equally unlikely that the Code of Conduct committee will need to decide what a car is, or whether or not someone has succeeded at university. I'm not trying to be snide, but this does seem to be exactly what I was talking about: When ask

Re: Code of Conduct plan

On 08/06/18 16:55, Ron wrote: On 06/07/2018 04:55 AM, Gavin Flower wrote: [snip] The Americans often seem to act as though most people lived in the USA, therefore we should all be bound by what they think is correct! "You" are wearing a tee-shirt (or hoodie), blue jeans and Ni

Re: Code of Conduct plan

On 08/06/18 14:21, Christophe Pettus wrote: On Jun 7, 2018, at 02:55, Gavin Flower wrote: The Americans often seem to act as though most people lived in the USA, therefore we should all be bound by what they think is correct! I have to say that this seems like a red herring to me. Not

Re: Code of Conduct plan

On 07/06/18 21:49, Raymond O'Donnell wrote: On 07/06/18 09:04, Pablo Hendrickx wrote: You don't have to be a magician to predict this is going to harm the community. Please keep your American social politics out of Postgres, thank you! As a long-time lurker and occasional participant on this

Re: Code of Conduct plan

On 05/06/18 06:41, Jason Petersen wrote: On Jun 4, 2018, at 10:59 AM, Joshua D. Drake > wrote: "snowflake", I find that term hilarious others find it highly offensive. Which is correct? I don’t think it’s offensive but it plainly fails your “if you wouldn’t say

Re: Code of Conduct plan

On 04/06/18 07:32, Adrian Klaver wrote: On 06/03/2018 11:29 AM, Tom Lane wrote: Two years ago, there was considerable discussion about creating a Code of Conduct for the Postgres community, as a result of which the core team announced a plan to create an exploration committee to draft a CoC [1].

Re: Index/trigger implementation for accessing latest records

Hi Alastair, See embedded comments. On 02/05/18 21:51, Alastair McKinley wrote: Hi, I have a table that stores a location identifier per person which will be appended to many times. However, for many queries in this system we only need to know the most recent location per person, which i

Re: Enforce primary key on every table during dev?

On 02/03/18 06:47, Daevor The Devoted wrote: On Thu, Mar 1, 2018 at 2:07 PM, Rakesh Kumar > wrote: >Adding a surrogate key to such a table just adds overhead, although that could be useful >in case specific rows need updating or deleting without also

Re: OPtimize the performance of a query

Hi Hmidi, On 17/01/18 06:57, hmidi slim wrote: I changed the operator like and I'm using the operator = .I got the results much faster but I still have another question about operator. For difference should I use '<>' or 'is distinct from' with indexes? 2018-01-16 17:49 GMT+01:00 Pavel Stehul

Re: To all who wish to unsubscribe

On 21/11/17 09:20, Magnus Hagander wrote: On Mon, Nov 20, 2017 at 9:07 PM, Joshua D. Drake > wrote: On 11/20/2017 12:03 PM, Tom Lane wrote: Unfortunately, the removal of the footer is a feature not a bug. In order to be DKIM-compatible and thus