Re: Cursor + upsert (astronomical data) - Mailing list pgsql-performance

From Vitalii Tymchyshyn
Subject Re: Cursor + upsert (astronomical data)
Date
Msg-id CABWW-d3AwgAazR_xuLoTE0WUFL6w2NX9vwUz4mEFv1msRz8F1w@mail.gmail.com
Whole thread Raw
In response to Cursor + upsert (astronomical data)  (Jiří Nádvorník <nadvornik.ji@gmail.com>)
Responses Re: Cursor + upsert (astronomical data)
List pgsql-performance

I am not sure I understand the problem fully, e.g. what to do if there are observations A,B and C with A to B and B to C less then treshold and A to C over treshold, but anyway.

Could you first apply a kind of grid to your observations? What I mean is to round your coords to, say, 1/2 arcsec on each axe and group the results. I think you will have most observations grouped this way and then use your regular algorithm to combine the results.

Best regards, Vitalii Tymchyshyn

pgsql-performance by date:

Previous
From: Ryan Johnson
Date:
Subject: Re: High rate of transaction failure with the Serializable Isolation Level
Next
From: Jiří Nádvorník
Date:
Subject: Re: Cursor + upsert (astronomical data)