Re: What is a typical precision of gettimeofday()?

Aleksander Alekseev <aleksander@timescale.com>

From: Aleksander Alekseev <aleksander@timescale.com>

To: pgsql-hackers <pgsql-hackers@postgresql.org>

Cc: Hannu Krosing <hannuk@google.com>, "Andrey M. Borodin" <x4mmm@yandex-team.ru>, Tom Lane <tgl@sss.pgh.pa.us>, Peter Eisentraut <peter@eisentraut.org>

Date: 2024-07-03T11:47:26Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Force LC_NUMERIC to C while running TAP tests.
- f25792c541e5 19 (unreleased) landed
Minor tweaks for pg_test_timing.
- 9dcc7641444f 19 (unreleased) landed
Change pg_test_timing to measure in nanoseconds not microseconds.
- 0b096e379e6f 19 (unreleased) landed

Hi,

> We currently do something similar with OIDs where we just keep
> generating them and then testing for conflicts.
>
> I don't think this is the best way to do it but it mostly works when
> you can actually test for uniqueness, like for example in TOAST or
> system tables.
>
> Not sure this works even reasonably well for UUIDv7.

UUIDv7 is not guaranteed to be unique. It just does it best to reduce
the number of possible conflicts. So I don't think we should worry
about it.


-- 
Best regards,
Aleksander Alekseev