Re: Cursor + upsert (astronomical data)

From: Vitalii Tymchyshyn <vit(at)tym(dot)im>
To: Jiří Nádvorník <nadvornik(dot)ji(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Cursor + upsert (astronomical data)
Date: 2014-07-27 06:05:42
Message-ID: CABWW-d3AwgAazR_xuLoTE0WUFL6w2NX9vwUz4mEFv1msRz8F1w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jiří Nádvorník 2014-07-27 14:35:21 Re: Cursor + upsert (astronomical data)
Previous Message Ryan Johnson 2014-07-26 23:51:03 Re: High rate of transaction failure with the Serializable Isolation Level