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: BUG? Slave don't reconnect to the master

Hi, Jehan. > On 9 Sep 2020, at 18:19, Jehan-Guillaume de Rorthais wrote: > > On Mon, 7 Sep 2020 23:46:17 +0300 > Олег Самойлов wrote: > >>> [...] >> 10:30:55.965 FATAL: terminating walreceiver process dpue to >> administrator cmd 10:30:55.966 LOG: redo done at 0/1600C4B0 >> 10:30

Need explanation on index size

Hi, I’m facing of a comportement I don’t understand on indexes, here a quick example to reproduce my problem test=# select version(); version -

Re: Need explanation on index size

Hi, Le jeu. 24 sept. 2020 à 15:55, Guillaume Luchet a écrit : > Hi, > > I’m facing of a comportement I don’t understand on indexes, here a quick > example to reproduce my problem > > > test=# select version(); > version > > > -

Re: Need explanation on index size

On 24/09/2020 15:08, Guillaume Lelarge wrote: Hi, Le jeu. 24 sept. 2020 à 15:55, Guillaume Luchet > a écrit : Hi, I’m facing of a comportement I don’t understand on indexes, here a quick example to reproduce my problem test=# select version();

Re: Need explanation on index size

On Thu, Sep 24, 2020 at 6:55 AM Guillaume Luchet wrote: > I don’t understand why after the update where I only update a non indexed > column the indexes size is growing. Is it something someone can explain ? If you reduce the table fillfactor then these updates will all be HOT updates. That will

Re: multiple tables got corrupted

On Tue, Sep 15, 2020 at 07:58:39PM +0200, Magnus Hagander wrote: > Try reading them "row by row" until it breaks. That is, SELECT * FROM ... > LIMIT > 1, then LIMIT 2 etc. For more efficiency use a binary search starting at what > seems like a reasonable place looking at the size of the table vs t

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

On Sun, Sep 20, 2020 at 01:15:26PM -0400, Tom Lane wrote: > 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 >

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

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 easy to > find. > > I guess I'm the worst idiot in the world, then, who can't DuckDuckGo (Google > is > e

What's the best practice of Postgres sharding?

Hello, We have one master/slave nodes running already, it works very well until now we need more business data to be stored. But our running machine almost reached the read/write limit (1600 ops/s). So what I am thinking is that I add more machines to store the new business data.But I don’t wan

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

(I can't believe I'm replying to this drivel...) >> >     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 postgis. >> > >> > I'm saying that PostGIS has a bug due to incorrectly constru

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

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 easy to find. I guess I'm the worst idiot in the world, then, who

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

Sep 24, 2020, 8:13 AM by tshel...@gmail.com: >> >> 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 postgis. > > > > I'm

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

> 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 Windows. >> I'm saying that PostGIS has a bug d

Re: PG 13 trusted extensions and pg_available_extensions

On Thu, Sep 24, 2020 at 10:58 AM Michael Paquier wrote: >> >> On Wed, Sep 23, 2020 at 03:28:45PM +, Daniel Westermann (DWE) wrote: >> > I was playing a bit with trusted extensions and wondered if there is >> > a reason that the "trusted" flag is not exposed in pg_available_extensions. >> > I b