Hi,
Please find the Vacuum(verbose) output. Can you please suggest what is the
reason?
How can we avoid these scenarios?
The customer tried to run the VACUUM(verbose) last night, but it was running
continuously for 5 hours without any visible progress. So they had to abort it
as it was going t
Hi,
We have got the result of the VACUUM (VERBOSE) as suggested, please find the
output as following & suggest further.
But please note that this was done on an non production server where uncleaned
data was there, although no dead tuples as it doesn’t run any configuration at
present. Howeve
please suggest any workaround so that we can resolve the issue or any
other way by which we can avoid this situation?
Regards
Tarkeshwar
-Original Message-
From: Tomas Vondra
Sent: Thursday, December 17, 2020 7:16 AM
To: M Tarkeshwar Rao ;
pgsql-performa...@postgresql.org
Cc: Neeraj Gupta
Hi all,
We have facing some discrepancy in Postgresql database related to the
autovacuum functionality.
By default autovacuum was enable on Postgres which is used to remove the dead
tuples from the database.
We have observed autovaccum cleaning dead rows from table_A but same was not
functioni
Hi all,
How to fetch certain number of tuples from a postgres table.
Same I am doing in oracle using following lines by setting prefetch attribute.
For oracle
// Prepare query
if( OCIStmtPrepare( myOciStatement, myOciError, (text *)aSqlStatement,
// Get statement type
OCIAttrGet( (voi
use case.
Can you please help us or have you any steps by which we can configure any
postgres with LDAP?
-Original Message-
From: Laurenz Albe
Sent: Thursday, May 9, 2019 12:12 PM
To: M Tarkeshwar Rao ; pgsql-general
;
'postgres-disc...@mailman.lmera.ericsson.se'
; &
Hi all,
We would need to integrate Postgres Users Authentication with our own LDAP
Server.
Basically as of now we are able to login to Postgress DB with a user/password
credential.
[cid:image001.png@01D50650.D807AE30]
These user objects are the part of Postgres DB server. Now we want that thes
Hi all,
Facing issue in using special characters. We are trying to insert records to a
remote Postgres Server and our application not able to perform this because of
errors.
It seems that issue is because of the special characters that has been used in
one of the field of a row.
Regards
Tarkes
