Hi Andrew,
Yes there are indexes on both tables, and the issue only shows up with high volumes.
Note I have subsequently isolated the issue down to a pg_dump 10 to pg_restore 11 using -Fc.
Kind Regards,
PAUL SCHAAP / General Manager
IPG Solutions Pty Limited
Full Service eCommerce Payments PartnerLevel 6, Blade Building, 69-71 Walker Street, North Sydney, NSW, Australia
W www.ipggroup.com | M +61-4-0307-0000
"Paul" == Paul Schaap <ps@ipggroup.com> writes:
Paul> Hi Jeff,
Paul> I have it now but it might be difficult for you to reproduce.
Paul> 1) pg_dump a lookup table from a Postgres 10(.5) with -Fc and
Paul> pg_restore to Postgres 11
Paul> 2) Join to the table in a view, but when you join do an INTEGER
Paul> cast
Paul> 3) Test with different quantities of data as it works with
Paul> smaller quantities of data, but fails with larger:
Are there any indexes on either table?
--
Andrew (irc:RhodiumToad)
PRIVACY & CONFIDENTIALITY NOTICE
The information contained in this email is intended for the named recipients only. It may contain privileged and confidential information and if you are not the intended recipient, you should not copy it or disclose its contents to any other person, or take any action in reliance on it. If you have received this email in error, please notify us immediately by return email.