umeric))
Buffers: shared hit=8
Execution time: 0.238 ms
(8 rows)
Regards,
Virendra Kumar
On Monday, April 12, 2021, 4:18:01 AM PDT, Vijaykumar Jain
wrote:
I am sorry if i have messed up the email original content.
feel free to ignore my diversion.
i forwarded this mail from s
x27;::text) AND
(warehouse_owner_group_id = '1'::numeric))
Planning time: 0.530 ms
Execution time: 0.189 ms
(7 rows)
Time: 1.710 ms
testdb=#
--
As we can see the first plan is a prepared statement and is using seq scan of
the table and took 800 ms while the second one is with literals and index scan
and took 0.189 seconds.
Is there a way I can force the prepared statement to go same as the values with
literals.
Thank you in advance!
Regards,
Virendra Kumar
sessions hit
table and queries with different values of a column.
Any input on this is higly appreciated.
Regards,
Virendra Kumar
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
System level call trace might help little bit using strace/truss utility.
Regards,
Virendra Kumar
On Wednesday, July 1, 2020, 9:26:09 PM PDT, Rene de Gek
wrote:
Hi Adrian,
Thank you for your reply. This was one of the things that Matthias has also
suggested to us, referring to
https
You might have index fragmentation and possibly reindexing them conncurrently
on PG12, should do that. As everyone agreed most of space will be marked for
re-use later for table segments but indices in your case could be problem. On
previous versions you can use pg_repack to do index rebuilds wh
| bigint | not null
Indexes:
"process_instance_pkey" PRIMARY KEY, btree (process_instance_id)
"fki_conv_konotor_user_user_id" btree (user_id) WITH (fillfactor='70')
Regards, Amarendra
On Fri, May 8, 2020 at 12:01 AM Virendra Kumar wrote:
Sending table structure with
if that resolves but looks like it is not
buzzing. Also for regular analyze we don't run manually, they are all left to
autoanalyze process.
Regards,Virendra
On Tuesday, May 5, 2020, 6:34:37 PM PDT, David G. Johnston
wrote:
On Tue, May 5, 2020 at 6:15 PM Virendra Kumar
Hi Everyone,
PG Version - RDS PostgreSQL 10.11
We have very simple query of 3 table joins and a few filter clause. Optimizer
is behaving little weird in the sense that for change in one filter it is using
NESTED LOOP JOIN and running for over 30 seconds whereas for other filter is
working fine u
I guess it is long route, once I was setting up POSTGIS on one of our cluster.
I had to install all of these components by downloading them from their sources.
Regards,
Virendra
On Monday, May 4, 2020, 4:40:53 PM PDT, Clifford Snow
wrote:
When I try to install PostGIS version 2.5 to a
-+---+-
public | idx_pg_repack_effectivedate | index | vvikumar | validate_pg_repack
| 19 MB |
public | idx_pg_repack_masterentityid | index | vvikumar | validate_pg_repack
| 19 MB |
(2 rows)
postgres=#
postgres=# drop table validate_pg_repack cascade;
DROP TABLE
uires double
the space of indexes, since there will be two indexes existing during rebuild
processes.
Regards,
Virendra Kumar
On Tuesday, April 21, 2020, 2:26:11 PM PDT, Kevin Brannen
wrote:
From: Michael Loftis
>>From: Kevn Brannen
>> I don't particularly
be I am missing some concept here or hitting a
bug:
postgres=# select min(user_name) from "abc.csv";
ERROR: missing data for column "database_name"
CONTEXT: COPY abc.csv, line 1: "aa,bb,cc"
postgres=#
postgres=#
postgres=# select ftrelid::regclass::text from pg_foreign_table
where ftrelid::regclass::text like
'%abc.csv%';
ftrelid
---
"abc.csv"
(1 row)
Regards,
Virendra Kumar
able testy add constraint testy_fkey foreign key (v_code)
references testx(v_code); <--This works.alter table testy drop constraint
testy_fkey; <--Hangs
Regards,Virendra Kumar
.
Regards,
Virendra Kumar
On Tuesday, March 31, 2020, 8:55:17 AM PDT, Adrian Klaver
wrote:
On 3/31/20 8:51 AM, Pepe TD Vo wrote:
> I have tables ddl data definitions already. Only need to move the data
> over off Oracle to Postgres
PostgreSQL Foreign Data Wrapper for Oracle:
prior
releases.
Regards,
Virendra Kumar
On Wednesday, March 11, 2020, 5:29:38 PM PDT, Tom Lane
wrote:
Virendra Kumar writes:
> Can you please back port patch where if a 0 byte packet sent to PG instance
> (Health Checks), it starts complaining about invalid startup packet and f
-
https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=342cb650e
Please let me know if you have already back ported this to supported versions.
Regards,
Virendra Kumar
Failover is easy but failback is little bit tricky.I have implemented failback
by doing following steps:
1. Start original primary which will be doing crash recovery. It should be
designed in such a way that once it is up application should not start
connecting to it otherwise there will be spli
18 matches
Mail list logo
