I am selecting data from Amazon Redshift Table with 500 millions rows. I have 64bit python installed.


import psycopg2
from sqlalchemy import create_engine
import pandas as pd
engine = create_engine('postgresql://'username':pwd@host/dbname')
data_frame = pd.read_sql_query('SELECT * FROM table_name ;', 

Everytime I run the code I get a "Out of Memory error". I have 16gb Ram. I am not sure how to resolve this issue.

Would really appreciate any help on this! Thanks


1 Answer 1


First, you are trying to access a big dataset with sqlalchemy, while specialized packages like bigquery would be a more suitable choice. I suggest learning about it on https://www.kaggle.com/learn/intro-to-sql

Also, I think that you get more data than your device can handle. Maybe setting up a limit on your data will help.

data_frame = pd.read_sql_query('SELECT * FROM table_name LIMIT 1000000;', engine)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.