Re: Problems Importing table to pgadmin

On 12/07/2016 04:02 PM, metaresolve wrote:
> That's.... a little beyond me. Let me back up a sec and maybe you guys can
> help.
>
> I used to use Access to do my data crunching, matching, and cleaning at my
> old job. I worked with a max of 600k records so Access could handle it. I
> know, lame, but it's what I knew.
>
> I was using Alteryx the past 8 months on files of 20M and higher. But, I got
> laid off, so I don't have access to that software anymore.
> [
> My thought was to use postgreSQL as a kind of more advanced Access that I
> could use to crunch numbers on similarly. However, My file has 1.1M records
> on it and pgadmin seems to be choking on it.

Define choking?

>
> How many records and relational tables can pgadmin/postgres actually handle?

https://www.postgresql.org/about/

So you have plenty of head room.

> I'm anticipating tests for my upcoming job hunts and I need something that
> gives me query capability. I figured since I used to do it in Access I could
> do it in SQL.
>
> (btw, the reason I picked postgreSQL is my friend from my old job uses it
> and likes it. i thought it would be easier to get help from her.)
>
> Any input?
>
>
>
> --
> View this message in context: http://postgresql.nabble.com/Problems-Importing-table-to-pgadmin-tp5933807p5933818.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com