Re: Event Triggers and Dropping Objects

Thanks, it does! On Sat, Oct 5, 2019 at 1:50 AM Luca Ferrari wrote: > On Fri, Oct 4, 2019 at 10:38 PM Miles Elam > wrote: > > > > The event trigger firing matrix lists tags like DROP TABLE and DROP > FUNCTION are listed below the ddl_command_end event, but when I created a > basic audit table

Re: Performance on JSONB select

No, no, no, partial index is the where clause of it and I´m not talking about that. I´m talking about datevalue, which will be used one or another, depending on status value This record iindex will be status and datevalue from "visitadescartada" object {   "status": "visitadescartada",   "atribui

Re: PMChildFlags array

Thanks Tom Lane for detailing the issue. >So ... how many is "a bunch"? more than 85 >Looking at the code, it seems like it'd be possible for a sufficiently >aggressive spawner of incoming connections to reach the >MaxLivePostmasterChildren limit. While the postmaster would correctly >reject addi

Re: Performance on JSONB select

Em sáb, 5 de out de 2019 às 11:49, PegoraroF10 escreveu: > I told it was almost dynamic because it uses DateValue from an object or > another, depending on value of staus key. > Actually it’s named partial index. Regards, > -- Fabrízio de Royes Mello Timbira - http://www.timbira.co

Re: Performance on JSONB select

I told it was almost dynamic because it uses DateValue from an object or another, depending on value of staus key. -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: Performance on JSONB select

Hi so 5. 10. 2019 v 13:34 odesílatel PegoraroF10 napsal: > I think I solved my problem. I didn´t know it was possible but I´ve created > an almost dynamic index, because it´ll index for status and corresponding > datevalue of an object with that status value. > you created multicolumn functiona

Re: Postgres 12: backend crashes when creating non-deterministic collation

On 2019-10-04 19:36, Tom Lane wrote: > Hm. This trace says that the crash happened somewhere down inside ICU > itself, during the ucol_open() call in get_collation_actual_version(). > There isn't much we could have done to mess up the arguments to that > function. That would seem to mean that it'

Re: Postgres 12: backend crashes when creating non-deterministic collation

Thomas Kellerer schrieb am 05.10.2019 um 13:39: Hm.  This trace says that the crash happened somewhere down inside ICU itself, during the ucol_open() call in get_collation_actual_version(). There isn't much we could have done to mess up the arguments to that function.  That would seem to mean tha

Re: Postgres 12: backend crashes when creating non-deterministic collation

Tom Lane schrieb am 04.10.2019 um 19:36: Hm. This trace says that the crash happened somewhere down inside ICU itself, during the ucol_open() call in get_collation_actual_version(). There isn't much we could have done to mess up the arguments to that function. That would seem to mean that it's

Re: Performance on JSONB select

I think I solved my problem. I didn´t know it was possible but I´ve created an almost dynamic index, because it´ll index for status and corresponding datevalue of an object with that status value. Postgres, I love you. Just one B-Tree index with 2 fields, Status and DateTime of that respective S

Re: Performance on JSONB select

I think I solved my problem. I didn´t know it was possible but I´ve created an almost dynamic index, because it´ll index for status and corresponding datevalue of an object with that status value. Postgres, I love you. Just one B-Tree index with 2 fields, Status and DateTime of that respective

Re: Event Triggers and Dropping Objects

On Fri, Oct 4, 2019 at 10:38 PM Miles Elam wrote: > > The event trigger firing matrix lists tags like DROP TABLE and DROP FUNCTION > are listed below the ddl_command_end event, but when I created a basic audit > table and event trigger, they don't seem to fire. I know sql_drop exists, but > aga