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

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Beccybyte
    New Member
    • Feb 2020
    • 3
    #1

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

    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.
    Tags: None
    • Rabbit
      Recognized Expert MVP
      • Jan 2007
      • 12517
      #2
      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?

        Comment

        • SioSio
          Contributor
          • Dec 2019
          • 272
          #3
          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.

            Comment

            Previous template Next
            Working...