On 2024-10-05 15:40:06 -0700, Adrian Klaver wrote:
> On 10/5/24 15:25, Peter J. Holzer wrote:
> > On 2024-10-05 17:03:08 -0400, Tom Lane wrote:
> > > "Peter J. Holzer" writes:
> > > > Again, I'm not arguing for such a change, but I'm wondering if recording
> > > > transaction_timestamp just after
On 10/6/24 06:26, KK CHN wrote:
On Fri, Oct 4, 2024 at 9:17 PM Adrian Klaver
Seems the issue is in the application server. What is not clear to
me is
whether the connection timeout you refer to is from the mobile devices
to the application or the application to the Postgres s
On Fri, Oct 4, 2024 at 9:17 PM Adrian Klaver
wrote:
> On 10/3/24 21:29, KK CHN wrote:
> > List,
> >
> > I am facing a network (TCP IP connection closing issue) .
> >
> > Running a mobile tablet application, Android application to update the
> > status of vehicles fleet say around 1000 numbers i
Hi,
As per my understanding , the pg_stat_statements stores the aggregated
statistics of the query execution history(with almost near real time
executions) and the max number of statements or queries it can store
depends on the pg_stat_statement.max value(which I am seeing as ~5000 in
pg_settings).
On 2024-Oct-04, KK CHN wrote:
> The mobile tablets are installed with the android based vehicle
> tracking app which updated every 30 seconds its location fitted inside the
> vehicle ( lat long coordinates) to the PostgreSQL DB through the java
> backend application to know the latest location of
On 10/6/24 12:11, veem v wrote:
Hi,
As per my understanding , the pg_stat_statements stores the aggregated
statistics of the query execution history(with almost near real time
executions) and the max number of statements or queries it can store
depends on the pg_stat_statement.max value(which
