Hi Team,
We have observed that xact_start time is null for some period and suddenly it
populates to very old value. We have a query which runs every minute to report
any transactions running for long time. That query reports nothing continuously
for a minute before and suddenly it reports one tr
Thanks for your reply brother 😊✌
On Mon, 10 Aug, 2020, 09:47 Adrian Klaver,
wrote:
> On 8/9/20 8:01 PM, Rama Krishnan wrote:
> > Hi Mentors,
> >
> >
> > I am searching for an understanding of bloat in PostgreSQL
> >
> > What is bloat?
> >
> > How does it work?
> >
> > What is the use of bloat?
Thank you for the clarification brother 😊👌
On Mon, 10 Aug, 2020, 09:47 Rob Sargent, wrote:
>
>
> > On Aug 9, 2020, at 9:01 PM, Rama Krishnan wrote:
> >
> > 
> > Hi Mentors,
> >
> >
> > I am searching for an understanding of bloat in PostgreSQL
> >
> > What is bloat?
> >
> > How does it work?
>
On 8/9/20 8:01 PM, Rama Krishnan wrote:
Hi Mentors,
I am searching for an understanding of bloat in PostgreSQL
What is bloat?
How does it work?
What is the use of bloat?
Limitations of bloat?
Read this section of the docs:
https://www.postgresql.org/docs/12/routine-vacuuming.html
and if
> On Aug 9, 2020, at 9:01 PM, Rama Krishnan wrote:
>
> 
> Hi Mentors,
>
>
> I am searching for an understanding of bloat in PostgreSQL
>
> What is bloat?
>
> How does it work?
>
> What is the use of bloat?
>
> Limitations of bloat?
>
> Thanks
>
> Rama Krishnan
Bloat is not a feature
Hi Mentors,
I am searching for an understanding of bloat in PostgreSQL
What is bloat?
How does it work?
What is the use of bloat?
Limitations of bloat?
Thanks
Rama Krishnan
On Sun, 9 Aug 2020 at 12:49, Condor wrote:
> Yea, I checked it, but because is 3 years old solution I expect these
> functions to be implemented long ago and just have another names or to
> have similar functions that do the same functionality. It's seems not,
> Okay will use the solution from sof
On 09-08-2020 09:20, Ashesh Vashi wrote:
Hi,
Have you checked this?
https://stackoverflow.com/questions/44813386/mysqls-hex-and-unhex-equivalent-in-postgres
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company [1]
_http://www.linkedin.com/in/asheshvashi_ [2]
O
