RE: JDBC Meta-data performance for Foreign Keys

> -----Original Message-----
> From: Mark Rotteveel <mark(at)lawinegevaar(dot)nl>
> Sent: Saturday, October 2, 2021 04:57
> To: pgsql-jdbc(at)lists(dot)postgresql(dot)org
> Subject: Re: JDBC Meta-data performance for Foreign Keys
>
> On 02-10-2021 08:29, ldh(at)laurent-hasson(dot)com wrote:
> > Lots of code refactoring on our end, but it was worth it as the results
> are quite good with a ~70% improvement!
> >
> > The only gotcha is what I tried to also optimize the calls for indices, I
> was surprised that the jdbc method DatabaseMetaData.getIndexInfo()
> doesn't take a table pattern like other "getXXXInfo" methods. For now
> we have decent performance, so dropping to a custom query to optimize
> indices is something we can do later.
> >
> >
> > pre-optimization
> > ==========================================
> > [..]
> > Views: 362 in 22.00ms or 0.1%
> > ------------------------------------------
> > Total: 19,667.00ms
> >
> >
> > post-optimization
> > ==========================================
> > [..]
> > Views: 362 in 113.00ms or 1.9%
> > ----------------------------------------------------------------------------
> > Total: 5,809.00ms
>
> I notice that you seem to be requesting views separately. You should be
> able to do that in a single call to DatabaseMetaData.getTables together
> with retrieving the tables.
>
> Mark
> --
> Mark Rotteveel
>

It's the way we do the logging for processing... But in any case, we are talking a few milliseconds here so not something I was paying attention to specifically.

Thank you,
Laurent.