> -----Original Message-----
> From: Mark Rotteveel <mark@lawinegevaar.nl>
> Sent: Saturday, October 2, 2021 04:57
> To: pgsql-jdbc@lists.postgresql.org
> Subject: Re: JDBC Meta-data performance for Foreign Keys
>
> On 02-10-2021 08:29, ldh@laurent-hasson.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
somethingI was paying attention to specifically.
Thank you,
Laurent.
