the same time value return different values,is it a problem

From: 姜梦洋 <minesunny(at)icloud(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: the same time value return different values,is it a problem
Date: 2023-09-13 07:24:14
Message-ID: 9831C223-91ED-43FC-8223-B90C46BA77C4@icloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I find the time type accuracy of the database. Using PreparedStatement, the accuracy found out for the sixth time is different from the first five times. This number is exactly the same as the threshold of the PreparedStatement. I can understand that the database can optimize PreparedStatements and reduce repeated parsing and other unnecessary operations. but I don’t quite understand how such processing will affect the execution results(Or maybe I don’t have a deep understanding of PreparedStatement.). now I run the code and get some results;


Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message 姜梦洋 2023-09-13 08:11:26 Re: the same time value return different values,is it a problem
Previous Message Alexander Kukushkin 2023-09-13 07:21:35 Re: pg_rewind WAL segments deletion pitfall