me hot bits of cache, which later get asynchronously flushed to
> disk). Unfortunately for your situation, the purpose of hash partitioning
> is to *reduce* locality of data. (Sometimes that's useful, but *not*
> when processing batches.)
>
> --
> Angular momentum makes the world go 'round.
>
--
Regards,
Karthik K Kondamudi
n conflict into insert and update is performant but in
order to split the record into batches( low, high) I need to do a count of
primary key on the batch tables to first split it into batches
On Mon, Feb 15, 2021 at 11:06 AM Rob Sargent wrote:
>
>
> On 2/15/21 11:41 AM, Karthik K wrot
Hi Team,
We are migrating from Oracle 12c to Aurora Postgres 13 and running into
implicit casting issues.
Oracle is able to implicitly cast the bind value of prepared statements
executed from the application to appropriate type - String -> Number,
String -> Date, Number -> String etc. when there
implication on the Postgres server that we need
to worry about?
Thanks,
Karthik K L V
On Tue, Jul 19, 2022 at 12:12 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Monday, July 18, 2022, Karthik K L V
> wrote:
>
>> Hi Team,
>>
>> We are migrating f
Hi Team,
I am getting the below error while executing a Select query using Spring
DataJPA and Hibernate framework in Aurora Postgres SQL.
*Caused by: org.postgresql.util.PSQLException: ERROR: operator does not
exist: text = bytea Hint: No operator matches the given name and argument
types. You
Aurora PostgresSQL v13.3
On Wed, Jul 20, 2022 at 3:02 PM Karthik K L V
wrote:
> Hi Team,
>
> I am getting the below error while executing a Select query using Spring
> DataJPA and Hibernate framework in Aurora Postgres SQL.
>
>
>
> *Caused by: org.postgresql.util.PSQLException: ER
Engine to read *=
null* as *is null*.
On Wed, Jul 20, 2022 at 5:29 PM hubert depesz lubaczewski
wrote:
> On Wed, Jul 20, 2022 at 03:02:13PM +0530, Karthik K L V wrote:
> > *Caused by: org.postgresql.util.PSQLException: ERROR: operator does not
> > exist: text = bytea Hint: No opera
Hi Team,
We are migrating from Oracle 12C to Aurora Postgres 13 and running into
query failures when the bind value of a Text datatype resolves to null.
The same query works fine in Oracle without any issues. We use
SpringDataJPA and Hibernate framework to connect and execute queries and
the appl
