Re: REINDEX VERBOSE unknown option

On Sun, Nov 17, 2019 at 04:41:59AM +0100, Pavel Stehule wrote: > Documentation patch is good idea. The documentation is rather clear about the need to of parenthesis when using the VERBOSE option, and that it is not a mandatory option: REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE |

Re: Function's execute overhead reducing

> My suspicion is that the query in the function is hidden from the > planner and so it ends up running two separate SELECT queries without > reference to each other. A quick test and possible solution: > > My results for the above on old machine.: > > Straight query: >

Re: here does postgres take its timezone information from?

> "Tom" == Tom Lane writes: Tom> Andrew Gierth writes: Tom> I think the "official" name of that zone is America/Los_Angeles. Tom> But initdb might seize on the US/Pacific alias, if available, >> And now you know why I have been saying for so many years that initdb >> should use the off

Re: here does postgres take its timezone information from?

Andrew Gierth writes: > Tom> I think the "official" name of that zone is America/Los_Angeles. > Tom> But initdb might seize on the US/Pacific alias, if available, > And now you know why I have been saying for so many years that initdb > should use the official names! [ shrug... ] The installed

Re: porting horde to Postgresql 12, dropped pg_attrdef

On 11/15/19 4:16 PM, Tom Lane wrote: Ivan Sergio Borgonovo writes: Horde (webmail and more) is not anymore compatible with postgresql 12 after pg_attrdef was dropped. We didn't drop the whole catalog, just the adsrc column, which has been deprecated for ages (because it didn't update to track

Re: here does postgres take its timezone information from?

> "Tom" == Tom Lane writes: >>> Ugh. It doesn't have the old backward compatibility names like >>> US/Pacific installed by default, which is a problem if that's what >>> initdb picked for your cluster (or you've stored references to any >>> of those names in other ways). >> One quick fi

Re: Function's execute overhead reducing

On 11/16/19 11:23 PM, Игорь Выскорко wrote: Hi all! The best way to describe my question is to show the code as first: create table tst( id int primary key, j1 jsonb, j2 jsonb ); insert into tst select ser, jsonb_build_object( floor(random() * 10 + 1), floor(random() * 1000

Re: here does postgres take its timezone information from?

> 16 nov. 2019 kl. 23:06 skrev Thomas Munro : > > On Sat, Nov 16, 2019 at 7:13 PM Tom Lane > wrote: >> Palle Girgensohn writes: >>> 15 nov. 2019 kl. 21:32 skrev Thomas Munro : Ugh. It doesn't have the old backward compatibility names like US/Pacific instal