Frankly speaking, Aurora PostgreSQL's behaviour is quite unpredictable.
In our case, the autovacuum was not even getting triggered in spite of
crossing the autovacuum_freeze_max_age. Finally, the database went down
abruptly, which resolved the issue.
Thanks,
Ninad
On Wed, Jun 15, 2022 at 7:57 PM
administration, they are different entities.
In case the subscriber has long-running queries, unlike streaming
replication, it does not affect synchronisation operations.
Regards,
Ninad Shah
On Thu, 4 Nov 2021 at 21:16, Alanoly Andrews wrote:
> We are currently running some long-runn
There is no equation to determine the best value. It depends on your
environment.
Regards,
Ninad Shah
On Wed, 3 Nov 2021 at 19:18, Rama Krishnan wrote:
>
> Hi All,
>
> What is the limit value for fixing connection timeout issues?
>
> As i searched in google and verified
Thanks Tom.
Regards,
Ninad Shah
On Sat, 23 Oct 2021 at 20:12, Tom Lane wrote:
> Ninad Shah writes:
> > Would keepalive setting address and mitigate the issue?
>
> [ shrug... ] Maybe; nobody else has more information about this
> situation than you do. I suggested somet
Hey Tom,
Thank you for your response. Actually, when we copy data using scp/rsync,
it works without any issue. But, it fails while attempting to transfer
using pg_basebackup.
Would keepalive setting address and mitigate the issue?
Regards,
Ninad Shah
On Fri, 22 Oct 2021 at 21:39, Tom Lane
run for an hour, and later, it takes 2 hours before it
times out.
Can someone please help me out here?
Regards,
Ninad Shah
Frankly speaking, nothing is impossible. But, I don't see any tools
available for the same.
I found the below link, which has migrated using code only.
https://niravshah2705.medium.com/spanner-database-to-postgres-90740424f744
Regards,
Ninad Shah
On Tue, 19 Oct 2021 at 14:58, Pawan S
On Tue, 21 Sept 2021 at 15:59, Koen De Groote wrote:
> Greetings all,
>
> Working on postgres 11.
>
> I'm researching an index growing in size and never shrinking, and not
> being used anymore after a while.
>
> The index looks like this:
>
> "index002" btree (action_performed, should_still_perfo
Have you used an EXCEPTION block in the procedure?
Regards,
Ninad Shah
On Thu, 16 Sept 2021 at 13:06, Trang Le wrote:
> Hi guys,
>
> I am using pgadmin4 to interact with Postgres database. For now I would
> like to run 2 store procedure (those have commit statement in begin end
This can be accomplished by taking a global dump. pg_dumpall utility has an
option "-g" to accomplish that.
Regards,
Ninad Shah
On Wed, 15 Sept 2021 at 19:24, Sridhar Parepalli
wrote:
> Hello Pros,
> Is there a quick way to create roles from database server to another db
>
this as a last
resort to save your system from the space crunch issue.
Regards,
Ninad Shah
On Tue, 31 Aug 2021 at 15:08, Jehan-Guillaume de Rorthais
wrote:
> On Tue, 31 Aug 2021 10:53:45 +0200
> Laurenz Albe wrote:
>
> > On Tue, 2021-08-31 at 10:36 +0200, basti wrote:
> >
I see an issue with the operator. GIN index is capable of performing index
scan and index-only scan.
Regards,
Ninad Shah
On Thu, 2 Sept 2021 at 20:57, Michael Lewis wrote:
> This is showing many false positives from the index scan that get removed
> when the actual values are examined
Try the pg_tgrm extension. It is a rich set of operators.
Regards,
Ninad Shah
On Thu, 2 Sept 2021 at 23:39, balasubramanian c r
wrote:
> HI Ninad
>
> Thanks for your reply.
> If bitmap index should not be used. Do i need to disable it for the time
> being and carry out th
You may checkout using "free -m" and may see how much memory is cache.
If you are using RHEL, you may clear cache using below commands.
sync; echo 1 > /proc/sys/vm/drop_caches; sync
Though this is going to release some memory from the cache, it may fill up
the cache again.
Regard
it can be performed via a few
commands.
Regards,
Ninad Shah
On Thu, 2 Sept 2021 at 20:05, M Tarkeshwar Rao <
m.tarkeshwar@ericsson.com> wrote:
> Hi all,
>
>
>
> We did a stability test for our product, where we continuously inserting
> data into postgres tables. We di
Kindly consider checking tcp_keepalive in PostgreSQL as well as OS kernel.
By default, it is 2 hours(7200).
Regards,
Ninad Shah
On Thu, 2 Sept 2021 at 11:43, Trang Le wrote:
> Hi Mladen,
>
> I missed previous emails, so I am creating a new one.
>
> I think the problem is coming
bitmap heap scan.
Regards,
Ninad Shah
On Thu, 2 Sept 2021 at 16:39, balasubramanian c r
wrote:
> Hi Team
>
> We have encountered a problem in our testing environment.
> I have a scenario where I am running a similarity match for an address
> I have created a table with foll
Hi David/Karsten,
Thank you for your response. This helped me.
This thread can be closed.
Regards,
Ninad Shah
On Tue, 31 Aug 2021 at 13:26, David G. Johnston
wrote:
> On Tuesday, August 31, 2021, Ninad Shah wrote:
>
>> Hi Karsten,
>>
>> I apologize for the delayed
POINT" command or wait for next
checkpoint to occur.
Regards,
Ninad Shah
On Wed, 1 Sept 2021 at 16:19, wrote:
> Hi,
>
>
>
> Looking at WAL folder after a crash, I noticed that new files after
> restarting overwrite the more recent files before the crash and not the
> ol
Hi Karsten,
I apologize for the delayed response.
There is no script-related transfer happening here. It creates an issue
while using "bash@" inside a column.
Regards,
Ninad Shah
On Fri, 27 Aug 2021 at 12:35, Karsten Hilbert
wrote:
> Deep packet inspection naively scanning
t;tm_user_info_pkey" PRIMARY KEY, btree (user_cd)
"idx_tm_user_info_user_id" UNIQUE, btree (user_id)
Replica Identity: FULL
*Record with an issue:-*
state_cd|off_cd|user_cd|user_name|desig_cd|user_id|user_pwd|phone_off|mobile_no|email_id|user_catg|status|created_by|created_dt|aadhaar|op_dt|login_ipaddress|forget_password|newuser_change_password
HR|31|2106011301|SUBASH AUTO HOUSE|DS|subash@123
|c22d1779437117852ffcdeb7e9c689f41c502a1dae2687b8845a33bb892f3b66||9255561872|
skpanwar2...@gmail.com|B|D|2006078673|2021-01-04|0|2021-01-04
14:30:27.715728||N|F
(1 row)
Can anyone help me out here?
Regards,
Ninad Shah
.
Additionally, entries in pg_hba.conf is required.
Hope this helps.
Regards,
Ninad Shah
On Mon, 23 Aug 2021 at 23:12, Saul Perdomo wrote:
> Sorry, I misspoke there - I meant to say that since one should not count
> on the standby-failover process to always run smoothly (whether it&#x
What are the parameters have you set in the recovery.conf file?
Regards,
Ninad Shah
On Fri, 20 Aug 2021 at 18:53, Hispaniola Sol wrote:
> Team,
>
> I have a pg 10 cluster with a master and two hot-standby nodes. There is a
> requirement for a manual failover (nodes switching t
Most probably, it runs a wraparound process, however, if you may see what
command was invoked by that worker, it would be helpful.
Regards,
Ninad Shah
On Mon, 9 Aug 2021 at 01:48, Luca Ferrari wrote:
> On Thu, Aug 5, 2021 at 6:27 PM Vijaykumar Jain
> wrote:
> > postgres/varsup
This is true. Such a feature is not available in PostgreSQL.
What you need to do is you have to take a structure dump, and change the
schema name as per required. And, then, you may copy the data.
Regards,
Ninad Shah
On Fri, 23 Jul 2021 at 23:08, Mayan wrote:
> Hi,
>
>
>
>
apply operation.
Kindly consider upgrading to a supported version.
Regards,
Ninad Shah
On Fri, 23 Jul 2021 at 15:18, Luca Ferrari wrote:
> On Fri, Jul 16, 2021 at 12:38 AM Lucas wrote:
> > However, it hasn't changed and the replication lag is still high all the
> time.
> >
med a
"deadlock". Do you see any transaction getting rolled back?
Regards,
Ninad Shah
On Fri, 23 Jul 2021 at 11:39, Marcin Barczynski <
mbarczyn...@starfishstorage.com> wrote:
> On Thu, Jul 22, 2021 at 5:08 PM Marcin Barczynski <
> mbarczyn...@starfishstorage.com> wrot
. You may report this to postgresql-bugs group.
Regards,
Ninad Shah
On Fri, 23 Jul 2021 at 17:25, WR wrote:
> Hello,
>
> unfortunately, it's my companys choice of OS.
> In private life I'm riding the penguin.
>
> One last thing: I have 2 Laptops, where the shutdown d
Pgbouncer doesn't provide such a functionality. Kindly consider using
pgpool.
On Thu, 22 Jul 2021 at 15:58, Ganesh Korde wrote:
> Try using HAProxy.
>
> Regards,
> Ganesh Korde.
>
> On Sat, 3 Jul 2021, 9:06 pm Rama Krishnan, wrote:
>
>>
>> Hi Team,
>>
>> How can I split read and write queries u
Factually, Windows itself has a number of issues. Hence, it is always
suggested to use Linux with it.
It can be explored further by querying the table from which
pg_stat_activity gathers data.
Regards,
Ninad Shah
On Thu, 22 Jul 2021 at 12:51, WR wrote:
> Hello Ninad Shah,
>
>
Hello,
Would you be able to verify the process trees for those PIDs on Windows?
You may be able to see who holds the connections?
Regards,
Ninad Shah
On Wed, 21 Jul 2021 at 19:15, WR wrote:
> Hello Vijaykumar Jain,
>
> thank you for fast answer, today I'm not able to acces
31 matches
Mail list logo
