On Wed, Jun 13, 2018 at 04:17:55PM -0300, Euler Taveira wrote:
> 2018-05-16 10:22 GMT-03:00 PG Doc comments form :
> > The documentation of the SELECT statement lists FETCH FIRST/OFFSET as an
> > alternative to the proprietary LIMIT clause.
> >
> >
Thanks! This helps.
On Thu, Nov 3, 2022, 18:40 Alvaro Herrera wrote:
> On 2022-Nov-03, Tom Lane wrote:
>
> > Stefan Badenhorst writes:
> > > I am using a prometheus exporter:
> > > https://github.com/prometheus-community/postgres_exporter/
> >
> > Hmm, well, maybe prometheus is doing something
On 2022-Nov-03, Tom Lane wrote:
> Stefan Badenhorst writes:
> > I am using a prometheus exporter:
> > https://github.com/prometheus-community/postgres_exporter/
>
> Hmm, well, maybe prometheus is doing something with that part of the URL.
> There's no such behavior in Postgres itself, though.
I am using a prometheus exporter:
https://github.com/prometheus-community/postgres_exporter/
Turning JIT off definitely made a big difference to all our environments.
When using JIT it causes OOM on postgres server after a few days. Adding
jit=off resolved the issue.
I have tested this now for
Stefan Badenhorst writes:
> I am using a prometheus exporter:
> https://github.com/prometheus-community/postgres_exporter/
Hmm, well, maybe prometheus is doing something with that part of the URL.
There's no such behavior in Postgres itself, though.
regards, tom lane
Stefan Badenhorst writes:
> This is working:
> postgresql://USERNAME:PASSWORD@server
> :5432/the_database?sslmode=disable=off
Again, not for me:
$ psql 'postgresql://postgres@localhost:5432/mydb?sslmode=disable=off'
psql: error: invalid URI query parameter: "jit"
I suspect something in your
This is working:
postgresql://USERNAME:PASSWORD@server
:5432/the_database?sslmode=disable=off
Maybe I was looking at the wrong documentation page?
On Thu, 3 Nov 2022 at 14:58, Tom Lane wrote:
> PG Doc comments form writes:
> > On this page:
> >
>
PG Doc comments form writes:
> On this page:
> https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS
> There is a list of keywords that can be specified as part of the connection
> string.
> Specifying `jit=off` or `jit=on` is functional in practice, but `jit` is
> not
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/libpq-connect.html
Description:
On this page:
https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS
There is a list of keywords that can be specified as part of
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/queries-limit.html
Description:
The documentation of the SELECT statement lists FETCH FIRST/OFFSET as an
alternative to the proprietary LIMIT clause.
10 matches
Mail list logo