[PERFORM] Query RE: Optimising UUID Lookups

2015-03-20 Thread Roland Dunn
Hi, Wonder if anyone can help. Have a lookup table where the primary key is a native uuid type (filled with uuid's of type 4), around 50m rows in size. Have a separate table, table A, similar size (around 50m rows). Primary key in table A is the standard integer, nextval, etc type primary key. Ta

Re: [PERFORM] [GENERAL] [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary

2015-03-20 Thread Vladimir Borodin
> 19 марта 2015 г., в 20:30, Sergey Shchukin > написал(а): > > 17.03.2015 13:22, Sergey Shchukin пишет: >> 05.03.2015 11:25, Jim Nasby пишет: >>> On 2/27/15 5:11 AM, Sergey Shchukin wrote: show max_standby_streaming_delay; max_standby_streaming_delay --