Re: Simple task with partitioning which I can't realize

constraint at global table level, of course. Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Mar 1, 2022 at 4:37 PM Andrew Zakharov wrote: > Hello all – > > I have a task which is simple at the first look. I have a table which > contains hierarchy of address objects s

Re: Simple task with partitioning which I can't realize

Andrew, contrary to Oracle, in postgres you can add the indexes and/or the constraints which are meaningful to you at partition level. I was not saying NOT to create keys, but I was saying to create them at partition level. Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Mar

Re: Separate 100 M spatial data in 100 tables VS one big table

, Postgres will create one index per each partition. and detach them when you detach a department partition. so when importing, first create an appropriate table, load the data, and attach it to the main partitioned table. Postgres will automatically recreate all necessary indexes. Marc MILLAS Senior

Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?

, 10TB for testing dev, ...) we do test zfs, and we will give a try to btrfs. any suggestion ? thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Sat, Apr 24, 2021 at 9:00 PM Bruce Momjian wrote: > On Sat, Apr 24, 2021 at 01:45:48PM -0500, Justin Pryzby wrote: > > On

Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?

Interesting ! the debian blog saying that " but only users who are interested in debugging future bugs should use transparent compression at this time" makes me feel its less urgent to test this option... Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Mon, Apr 26, 2021

logical replication

consumes network ressource) what are ways to avoid this ? (I thought of a trigger to not execute the useless update, but I dont see how to do this) any ideas ? thanks PS: remarks about the meaning of this are off topic, thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: logical replication

perfect :-) thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Fri, May 21, 2021 at 3:21 PM Andrew Dunstan wrote: > > On 5/21/21 8:41 AM, Marc Millas wrote: > > Hi, > > > > my POC in postgres 12.(important ?) > > > > if I setup 2 postgre

9.6 write time

buffers_checkpoint 182447 so, to my understanding, it takes almost 2 hours to write 1.6 GB of data. Can someone either correct my understanding, or shed some light on what can cause this ?? thanks, Marc MILLAS Senior Architect +33607850334 www.mokadb.com

Re: 9.6 write time

Hi Tom, checkpoint completion target is 0.9 Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Tue, Dec 28, 2021 at 6:46 PM Tom Lane wrote: > Marc Millas writes: > > I am looking at a postgres 9.6 on rh7 > > I see that checkpoint_write_time is huge which looks quite

Re: 9.6 write time

Default ie. 5 minutes Le mar. 28 déc. 2021 à 19:34, Tom Lane a écrit : > Marc Millas writes: > > checkpoint completion target is 0.9 > > checkpoint_timeout is the more interesting number here. > > regards, tom lane >