hello how to copy CSV files directly into the post...
# helpr
reemwn
07/24/2022, 2:48 PMhello how to copy CSV files directly into the postgres database from the SQL query editor in supebass dashboard
n
Needle
07/24/2022, 2:48 PMHello @reemwn!
This thread has been automatically created from your message in #843999948717555735 a few seconds ago.
We have already mentioned the @User so that they can see your message and help you as soon as possible!
Want to unsubscribe from this thread?
Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates.
Want to change the title?
Use the ``/title`` command!
We have solved your problem?
Click the button below to archive it.
r
reemwn
07/24/2022, 2:55 PMAlso can I store 3 million rows of data on the free tier
reemwn
07/24/2022, 2:56 PMthe csv size is 300mb
g
garyaustin
07/24/2022, 3:07 PMYour first question. You will need to use something like pgAdmin (free) or a 3rd party tool like datagrip. I don't believe the UI SQL window has access to your computers file system and you don't have access to the server's file system.
garyaustin
07/24/2022, 3:16 PMI personally would not attempt to use a free tier (500mb database) and 1GB of memory with a table that size. You will be up against a few things.
Actual table size with datatype sizes and indexes and such. If you google you will see this can be double or more the size of the csv depending on your datatypes and indexes.
Performance and loading of indexes and table data into memory. If it does not fit with everything else then paging will start to happen.
And processing power to process this number of rows. RLS in particular would have to be done with care.
But I'm not a Postgres expert and have never dealt with a table that big. Postgres itself on the right size hardware has no problems with many many millions of rows.
Seems easy enough to try if you can get the csv imported with pgAdmin.
3 Views