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

2020-09-20 Thread Tom Lane
Bruce Momjian writes: > On Mon, Sep 14, 2020 at 05:39:57PM -0400, Tom Lane wrote: >> On the other hand, the very same thing could be said of database names >> and role names, yet we have never worried much about whether those were >> encoding-safe when viewed from databases with different encoding

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

2020-09-20 Thread Bruce Momjian
On Mon, Sep 14, 2020 at 10:22:31PM +0200, tutilu...@tutanota.com wrote: > 4. There is no built-in means to have PG manage (or even suggest) indexes on > its own. Trying to figure out what indexes to create/delete/fine-tune, and > determine all the extremely complex rules for this art (yes, I just c

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

2020-09-20 Thread Bruce Momjian
On Mon, Sep 14, 2020 at 05:39:57PM -0400, Tom Lane wrote: > tutilu...@tutanota.com writes: > > 1. All non-ANSI characters are turned into "?"s for application_name. > > Yeah, that's hard to do much with unfortunately. We cannot assume that > all databases in an installation share the same encodin