By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,102 Members | 1,011 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,102 IT Pros & Developers. It's quick & easy.

PGadmin won't let me join tables, because one of them has >3M rows

P: 3
I have a number of tables that I need to join together and so far I have no issues with 3/4 tables.
The 4th table contains >3M rows, and every time I try to join it to another table, the connection breaks.

Is this because I have so many entries?

How can I fix this? I cannot address my tasks without joining this table to the others.
Feb 18 '20 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,409
Your question is missing too much information for anyone to help.

What do you mean it breaks?

Do you get an error message?

Why do you believe it's because of the number of rows?

What is your SQL code?
Feb 19 '20 #2

100+
P: 112
A common solution is to split the data in a large table into several parts, join and save the joined tables in a suitable storage.
The subsequent processing is continued by reading the saved data again.
Feb 20 '20 #3

Post your reply

Sign in to post your reply or Sign up for a free account.