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

2020-09-25 Thread Sam Gendler
On Thu, Sep 24, 2020 at 10:40 PM wrote: > > Well not partial as in incremental. Instead dump only some portion of the > schema with or without its associated data. > > It's funny that you should bring that up, considering how it was one of my > points... See the point about pg_dump's bug on Windo

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

2020-09-25 Thread Bruce Momjian
On Fri, Sep 25, 2020 at 10:04:53AM +0200, Thomas Kellerer wrote: > I am not in the USA (and far from being US-centric as well) and I have been > working > with relational databases for over thirty years. I never had problems using > unquoted > ASCII names (using snake_case) for my database object

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

2020-09-25 Thread Bruce Momjian
On Thu, Sep 24, 2020 at 11:47:10PM -0500, Ron wrote: > On 9/24/20 6:20 PM, Bruce Momjian wrote: > > On Wed, Sep 23, 2020 at 12:28:14AM +0200, tutilu...@tutanota.com wrote: > > > Sep 21, 2020, 7:53 PM by j...@commandprompt.com: > > > See my comment about Google. The information is out there and

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

2020-09-25 Thread Johannes Graën
On 9/25/20 7:40 AM, tutilu...@tutanota.com wrote: > I don't mean this to sound rude, but it's like talking to a wall... What > I mean is that there are obviously technical means for software to know > whether they are exhausting the system they are running on or not, and > expecting people to under

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

2020-09-25 Thread Thomas Kellerer
Adrian Klaver schrieb am 25.09.2020 um 17:02: Would it be nice if I could use special characters like öäü in the names of tables and columns (without the hassle of quoting them)? Yes, absolutely. But you can use them without quoting: select version();   ve

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

2020-09-25 Thread Adrian Klaver
On 9/24/20 10:40 PM, tutilu...@tutanota.com wrote: Well not partial as in incremental. Instead dump only some portion of the schema with or without its associated data. It's funny that you should bring that up, considering how it was one of my points... See the point about pg_dump's bu

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

2020-09-25 Thread Adrian Klaver
On 9/25/20 1:04 AM, Thomas Kellerer wrote: The fact that there are a lot of sloppy, US-centric people who refuse to use correctly named identifiers and cannot understand how there can be anything besides a-z in an alphabet, doesn't change reality and doesn't make a bug "right". I am not in t

Re: horizontal scaling

2020-09-25 Thread Thomas Kellerer
I think currently the best option is something like Citus[1] if you want to stick with vanilla Postgres. Otherwise Greenplum might be another option. Thomas [1] https://github.com/citusdata/citus Rita schrieb am 25.09.2020 um 13:51: There was a lot of talk

Re: horizontal scaling

2020-09-25 Thread Thomas Kellerer
I think currently the best option is something like Citus[1] if you want to stick with vanilla Postgres. Otherwise Greenplum might be another option. Thomas [1] https://github.com/citusdata/citus Rita schrieb am 25.09.2020 um 13:51: There was a lot of talk

horizontal scaling

2020-09-25 Thread Rita
There was a lot of talk about horizontal scaling a few years ago. I was wondering if there have been any new efforts on it. -- --- Get your facts first, then you can distort them as you please.--

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

2020-09-25 Thread Thomas Kellerer
tutilu...@tutanota.com schrieb am 25.09.2020 um 06:41: All lowercase is good That's your personal opinion -- not some kind of fact, and it definitely goes against everything that I believe. You have to accept that every programming environment has its own best practices (in terms of coding