public inbox for [email protected]  

help / color / mirror / Atom feed

From: o1bigtenor <[email protected]>
Cc: [email protected]
Subject: Re: Regarding use case of epoch to generate nanoseconds precision
Date: Wed, 22 May 2024 05:53:02 -0500
Message-ID: <CAPpdf58BB55co4F9YUTs_dTfMpJoY-=4GFqT=YE+5uXc22M1HQ@mail.gmail.com> (raw)
In-Reply-To: <CAJCZkoJQ9n1o_+1CWAE2gNtSdWxU_MM460dr3Gq69jZr43e_+w@mail.gmail.com>
References: <CAJCZkoJQ9n1o_+1CWAE2gNtSdWxU_MM460dr3Gq69jZr43e_+w@mail.gmail.com>

On Wed, May 22, 2024 at 4:21 AM Durgamahesh Manne <[email protected]>
wrote:

> Hi
>
> Postgres supports only upto microseconds (6 decimal precision).
> How do we generate timestamp with nanoseconds as rds postgres not
> supported timestamp9 extension ?
> Is there a way to generate timestamp with nanoseconds precision on
> pg_partman with epoch without typecasting or with typecasting  ?
>
> p_epoch =>   (to_timestamp(control column))
> Here what is the control column?
> How to run it with the create_parent function of partman?
>
> Here as per the pg_partman doc
> p_epoch - tells pg_partman that the control column is an integer type, but
> actually represents an epoch time value. Valid values for this option are:
> 'seconds', 'milliseconds', 'nanoseconds', and 'none'. The default is
> 'none'. All table names will be time-based. In addition to a normal index
> on the control column, be sure you create a functional, time-based index on
> the control column (to_timestamp(control column)) as well so this works
> efficiently.
>
>
Not a postgresql expert but - - - I'm wondering how you actually plan to
implement this nanosecond timestamp?
You will be working in an area where you will need some extreme corner case
equipment for all items in the system.
Not saying that measurements in this area can't be done rather that you
will have internal ambiguities in your
accuracy (network timing for one at the very least).

Good luck

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Regarding use case of epoch to generate nanoseconds precision
  In-Reply-To: <CAPpdf58BB55co4F9YUTs_dTfMpJoY-=4GFqT=YE+5uXc22M1HQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox