Re: [GENERAL] a JOIN to a VIEW seems slow

2017-09-17 Thread Frank Millman
2017-09-14 15:09 GMT+02:00 Pavel Stehule : 2017-09-14 14:59 GMT+02:00 Frank Millman : Pavel Stehule wrote: 2017-09-14 10:14 GMT+02:00 Frank Millman : Hi all This is a follow-up to a recent question I

[GENERAL] pg_rewind issue

2017-09-17 Thread James Sewell
Hi All, pg_rewind is failing to bring an old master back into a workable state. I'm wondering if I'm missing a step? EDB 9.6.4 using pg_backrest for archive management. High write rate throughout this process. Steps to cause: - Stop old master - Promote old standby to new master -

Re: [GENERAL] Selecting a daily puzzle record - which type of column to add?

2017-09-17 Thread David G. Johnston
On Sun, Sep 17, 2017 at 1:13 PM, Alexander Farber < alexander.far...@gmail.com> wrote: > > I need to add a useful column, so that it would be easy to me to create a > web script which would display today's and all past "daily puzzle" records > - and wouldn't change the already published

Re: [GENERAL] looking for a globally unique row ID

2017-09-17 Thread Gmail
> > As you may have noticed, I've put significant effort to focus the > discussion on my actual question: the "global index" (which btw I didn't > know is called this way here - if I new, I'd probably could have google > it instead). This was intentional. I like my schema design very much and >

Re: [GENERAL] advisory locks namespace?

2017-09-17 Thread John R Pierce
On 9/17/2017 1:33 PM, Rob Nikander wrote: Am I right if two applications use advisory locks in the same database, they need to know which lock numbers are used to by the other application, to avoid conflicts? indeed.   it also depends if they want to honor each others locks. -- john r

[GENERAL] advisory locks namespace?

2017-09-17 Thread Rob Nikander
Hi, Am I right if two applications use advisory locks in the same database, they need to know which lock numbers are used to by the other application, to avoid conflicts? Rob -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] Selecting a daily puzzle record - which type of column to add?

2017-09-17 Thread Alexander Farber
Good evening, In a word game I store all player moves in the table: CREATE TYPE words_action AS ENUM ( 'play', 'skip', 'swap', 'resign', 'ban', 'expire' ); CREATE TABLE words_moves ( mid BIGSERIAL PRIMARY KEY, action

Re: [GENERAL] Remove useless joins (VARCHAR vs TEXT)

2017-09-17 Thread Tom Lane
David Rowley writes: > On 17 September 2017 at 08:07, Kim Rose Carlsen wrote: >> It seems there are some difference in VARCHAR vs TEXT when postgres tries to >> decide if a LEFT JOIN is useful or not. > Yeah, it looks like the code to check for

Re: [GENERAL] looking for a globally unique row ID

2017-09-17 Thread Rafal Pietrak
W dniu 17.09.2017 o 03:30, Gmail pisze: > > >> On Sep 16, 2017, at 11:18 AM, Rafal Pietrak wrote: >> >> Dear robjsarg...@gmail.com, >> >> W dniu 16.09.2017 o 17:19, Gmail pisze: >>> >>> On Sep 16, 2017, at 8:23 AM, Rafal Pietrak wrote:

Re: [GENERAL] looking for a globally unique row ID

2017-09-17 Thread Rafal Pietrak
W dniu 16.09.2017 o 22:20, rob stone pisze: > > > On Sat, 2017-09-16 at 19:18 +0200, Rafal Pietrak wrote: >> Dear robjsarg...@gmail.com, [-] >> >> > Hello Rafal, Hi, > > > I've been trying to follow this discussion but now I'm totally > confused. (Some people might say that