[INSTRM-1759] Check/update archiver tables real value precision at LAM Created: 14/Oct/22 Updated: 10/Apr/23 Resolved: 15/Oct/22 |
|
| Status: | Done |
| Project: | Instrument control development |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Normal |
| Reporter: | cloomis | Assignee: | Unassigned |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Description |
|
The plot tool at LAM is plotting temperatures with the resolution truncated to 1mK. If I remember right, this is a postgresql < 12 quirk which can be changed with something like alter system set extra_float_digits TO 3; select pg_reload_conf(); But I thought we did that there already? |
| Comments |
| Comment by fmadec [ 14/Oct/22 ] |
|
I personally have not run that command |
| Comment by cloomis [ 14/Oct/22 ] |
|
Maybe it was Subaru only. Kiyoto Yabe – is this familiar? |
| Comment by Kiyoto Yabe [ 14/Oct/22 ] |
|
According the slack log (https://pfs.ipmu.jp/internal/SlackArchive/Full/opdb-targetdb-queuedb.html), you did that command at JHU and suggested to do so at summit as well. I'm not sure we did that in the end, but it looks to me that extra_float_digits is still 0 at summit. Familiar? Of corse not, but I know this is more familiar to Mineo-san at NAOJ. Do we need him? |
| Comment by arnaud.lefur [ 14/Oct/22 ] |
|
I don't have this issue on my own db, and I cannot reproduce the problem by setting extra_float_digits to 0. |
| Comment by cloomis [ 15/Oct/22 ] |
|
Did the ALTER and the SELECT at LAM and the plot did change. |