I saw that problem when I was running the query from DBeaver.
Got my answer.
Thanks & Regards.
On Tue, Jun 15, 2021 at 12:18 PM Pavel Stehule
wrote:
>
>
> út 15. 6. 2021 v 21:07 odesílatel Tom Lane napsal:
>
>> AI Rumman writes:
>> > I am using Postgresql 1
I am using Postgresql 10 and seeing a strange behavior in CONCAT function
when I am concatenating double precision and int with a separator.
select concat('41.1'::double precision,':', 20);
> Result:
> 41.1014:20
Value 41.1 which double precision converts to 41.100014.
Is that
Hi,
I am running Postgresql 10 where I can see the template0 database is having
longest datfrozenxid:
```db_name age_of_datfrozenxid
--
postgres251365
template1234574
template075366462
db1253097
db2250649
db3250649
db414641
db5
We are running timescale pg_prometheus with separating each services in
schema. So in one database we have:
> >> schema_a
>view: metrics
> tables: metrics_copy, metrics_labels, metrics_values
> >> schema_b
>view: metrics
> tables: metrics_copy, metrics_labels, metrics_values
> and
Thanks, I'll check it out.
On Thu, Jan 17, 2019 at 9:06 AM Jehan-Guillaume (ioguix) de Rorthais <
iog...@free.fr> wrote:
> On Thu, 17 Jan 2019 08:32:48 -0500
> AI Rumman wrote:
>
> > Hi,
> >
> > I am planning to use Postgresql with TimescaleDb extension. I ha
Hi,
I am planning to use Postgresql with TimescaleDb extension. I have to
design a system similar to AWS RDS which supports automated failover,
transparent minor version upgrades etc.
In early days, I worked with PgPool II to enable heartbeat between the
Postgres servers. Is there any new tool to
