[GENERAL] Insertion of large xml files into PostgreSQL 10beta1

Hello, I am building up a PostgreSQL server which I intend to load the entirety of the pubmed database data (23GB bzip2 compressed, 216GB unpacked) which is available in xml form of which, here is an example: https://www.ncbi.nlm.nih.gov/pubmed/21833294?report=xml&format=text I looked at the doc

Re: [GENERAL] Insertion of large xml files into PostgreSQL 10beta1

> Narrowing down the entire file to a small problem region and posting a > self-contained example, The url here contain the set of xml records from a publication I worked on many years ago: https://www.ncbi.nlm.nih.gov/pubmed/21833294?report=xml&format=text The particularly problematic region of

Re: [GENERAL] Insertion of large xml files into PostgreSQL 10beta1

Hello Jan, Hello David, I'll be able to do further testing next week as I am in the middle of a move but for next week, I'll be in vacation from work for the whole month. Best regards, Alain 2017-06-29 0:13 GMT-04:00 David G. Johnston : > On Sun, Jun 25, 2017 at 8:02 PM, Al

Re: [GENERAL] Database cluster?

> Somebody mentioned the fact that postgres uses IPC for communicating > between processes. I think there are tools for clustering (I am not sure if > Mosix supports transparently allowing IPC across nodes) which can work > around that. one of those tool is distributed ipc

Re: [GENERAL] Database cluster?

> Please forgive my ignorance (I haven't used Postgres for that long), but > what are shm and sem? shared memory and semaphores,interresting tidbit on Linux (2.4.0-test series at least) is that shared memory can be a nodev filesystem (like proc or devfs): /dev/ide/host0/bus0/target0/lun0/part2 o

Re: [GENERAL] MacIntosh

> I need to run a Linux Server with MacIntosh clients. > > Is this possible? yes (that is,as long as your mac understand the internet protocol) !!but..what kind of server ?? Alain

Re: [GENERAL] Clarification

> As I've recieved some "interesting" emails to clarify: > > I wish to run postgresql on a Linux (Slackware) server over a LAN. > > The client must reside on Apple MacIntosh (12 of them) > > I am not familair with any client that will allow this. I have no > problem with Linux or mac, I have very

Re: [GENERAL] Clarification

> Not actually necessary. After all, make client part do what it's supposed > to- get user input and display server responses. Browser on Macs and > HTTP/CGI + PGSQL on the server will do in most cases. that too is an option but it would hurt me to have to insert 20K record or something

Re: [GENERAL] Clarification

> > that too is an option but it would hurt me to have to insert 20K record > > or > > something like that with a web browser. > > H How ODBC driver is supposed to help with that? Upload a CSV or > FF file and run bulk insert with COPY. with ODBC: user load the database client app (