Hello,
I have two very simple questions:
1) I have an account at postgresql.org, but a link to a 'forgot password' seems
to be missing on the login page. I have my password stored only on an old
Fedora 32 computer. To change the password
when logged in, you need to supply the old password. In s
On Mon, 2021-11-08 at 10:20 +0100, Magnus Hagander wrote:
> On Mon, Nov 8, 2021 at 10:11 AM Michael J. Baars
> wrote:
> > On Mon, 2021-11-08 at 13:30 +0530, Abhijit Menon-Sen wrote:
> >
> > > At 2021-11-08 08:41:42 +0100, mjbaars1977.pgsql.hack...@gmail.com wrote:
On Mon, 2021-11-08 at 13:30 +0530, Abhijit Menon-Sen wrote:
> At 2021-11-08 08:41:42 +0100, mjbaars1977.pgsql.hack...@gmail.com wrote:
> > Could someone please explain to me, why compression is being
> > considered unsafe / insecure?
>
> https://en.wikipedia.org/wiki/CRIME
>
Well Abhijit, person
Hi All,
While I was searching for methods to send the result of a query to the other
side of the world, because it might be nice to go there once in a while, I
noticed
my best option, SSL compression, has been disabled as of version 14. Could
someone please explain to me, why compression is bei
On Wed, 2021-02-24 at 19:18 -0600, Justin Pryzby wrote:
> On Wed, Feb 24, 2021 at 09:14:19AM +0100, Michael J. Baars wrote:
> > I've written this function to insert several rows at once, and noticed a
> > certain postgresql overhead as you can see from the log file. A lot
Hi,
I've written this function to insert several rows at once, and noticed a
certain postgresql overhead as you can see from the log file. A lot more data
than the
user data is actually sent over the net. This has a certain noticeable impact
on the user transmission speed.
I noticed that a lib
On Mon, 2021-02-22 at 10:52 -0500, Tom Lane wrote:
> "Michael J. Baars" writes:
> > So how do you compute the number of seconds in 8 years?
>
> IMO, that's a meaningless computation, because the answer is not fixed.
> Before you claim otherwise, think about th
On Sat, 2021-02-20 at 11:20 -0500, Tom Lane wrote:
> "Michael J. Baars" writes:
> > Can someone please tell me which of these two queries gives the correct
> > result and which one the incorrect?
> > // 2.922 (&)
> > with A1 as ( select make_inte
Hi,
Can someone please tell me which of these two queries gives the correct result
and which one the incorrect?
/* * * *
* dT in days for 1000 samples
*/
// 2.922 (&)
with A1 as ( select make_interval (0, 0, 0, 0, 0, 0, ( extract ( epoch from
interval '8 years' ) / 1000 ) ) as "00"