Re: REINDEX CONCURRENT?

2018-11-08 Thread David Rowley
On 9 November 2018 at 17:05, Ron wrote: > Is this very useful feature on the TODO list, and high enough that it might > get into v12? (Indexes supporting PK and FK constraints just can't be > dropped to use CREATE INDEX CONCURRENT.) There is a patch [1] in the current commitfest which allows ind

REINDEX CONCURRENT?

2018-11-08 Thread Ron
Hi, Is this very useful feature on the TODO list, and high enough that it might get into v12?  (Indexes supporting PK and FK constraints just can't be dropped to use CREATE INDEX CONCURRENT.) Thanks -- Angular momentum makes the world go 'round.

Re: Largest & Smallest Functions

2018-11-08 Thread Ken Tanzer
On Thu, Nov 8, 2018 at 7:01 AM Pavel Stehule wrote: > postgres=# select smallest(VARIADIC ARRAY[1,2,3]); >>> ┌──┐ >>> │ smallest │ >>> ╞══╡ >>> │1 │ >>> └──┘ >>> (1 row) >>> >>> >> That's very helpful and good to know. It's too bad that doesn't work with >> LEAST/

Re: Largest & Smallest Functions

2018-11-08 Thread Pavel Stehule
čt 8. 11. 2018 v 7:02 odesílatel Ken Tanzer napsal: > > > On Wed, Nov 7, 2018 at 9:48 PM Pavel Stehule > wrote: > >> >> You can pass variadic arguments as a array >> >> postgres=# \sf smallest >> CREATE OR REPLACE FUNCTION public.smallest(VARIADIC anyarray) >> RETURNS anyelement >> LANGUAGE sq

Upgrade Standby

2018-11-08 Thread Amine Tengilimoglu
Hi; What is the best way for upgrading standby server on postgresql? I dont want to use --link option for master upgrading that is why it seems just one way for achive this..this way is setup sr again... thanks in advence...

Re: LOG: incomplete startup packet

2018-11-08 Thread Pavel Stehule
Hi čt 8. 11. 2018 v 10:19 odesílatel Pavel Demidov napsal: > Hello, > > Time to time found in postgres.log the following message > > 01:35:22.608 LOG: incomplete startup packet > 01:35:27.147 LOG: incomplete startup packet > 01:35:52.593 LOG: incomplete startup packet > 01:35:57.146 LOG: inc

Re: LOG: incomplete startup packet

2018-11-08 Thread Achilleas Mantzios
On 8/11/18 11:19 π.μ., Pavel Demidov wrote: Hello, Time to time found in postgres.log the following message 01:35:22.608  LOG: incomplete startup packet 01:35:27.147  LOG: incomplete startup packet 01:35:52.593  LOG: incomplete startup packet 01:35:57.146  LOG: incomplete startup packet 01:36:

LOG: incomplete startup packet

2018-11-08 Thread Pavel Demidov
Hello, Time to time found in postgres.log the following message 01:35:22.608 LOG: incomplete startup packet 01:35:27.147 LOG: incomplete startup packet 01:35:52.593 LOG: incomplete startup packet 01:35:57.146 LOG: incomplete startup packet 01:36:22.596 LOG: incomplete startup packet 01:36:2