> > (1) Suggest using "pastebin.com <http://pastebin.com/>" for this kind of > data. It may not > look very pretty -- or readable at all -- on the viewer's end > depending on their settings (see below for example).
Ok, sorry about that. https://pastebin.com/2XANMcF6 <https://pastebin.com/2XANMcF6> Odds rows market with ** at the end of the rows > > (3) "Old database" might mean anyting. Provide the PG version > it was created in and the one you are using along with the > result of "\d+" in the current database. version ------------------------------------------------------------------------------------------------ PostgreSQL 9.4.15 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit (1 rad) bnl@ibm2:~$ uname -a Linux ibm2 4.9.0-11-amd64 #1 SMP Debian 4.9.189-3+deb9u1 (2019-09-20) x86_64 GNU/Linux bnl=> \d+ Lista med relationer Schema | Namn | Typ | Ägare | Storlek | Beskrivning --------+----------------+---------+-------+------------+---------------------------- public | abets | tabell | bnl | 62 MB | Bets public | abets_found | tabell | bnl | 702 MB | public | adiff | tabell | bnl | 0 bytes | Price diff between 1 and 2 public | aevents | tabell | bnl | 968 kB | collected runners public | amarkets | tabell | bnl | 15 MB | collected runners public | aprices | tabell | bnl | 122 MB | runners odds public | apriceshistory | tabell | bnl | 95 GB | runners odds during race public | arunners | tabell | bnl | 124 MB | collected runners public | bet_id_serial | sekvens | bnl | 8192 bytes | (9 rader) > (4) Classic causes of this are a botched index. Depending on the > size you might just want to either drop and re-add the > indexes or export and reload the table (e.g., \copy to ... > + truncate + \copy from ...). The point there would be > fully rebuilding the table and index structure. But there is no index on startts I’ll try that later on. > (6) Don't gamble on horses, play the stock market instead: It > sounds fancier and you can loose much more money much more > quickly... er... yeah. I can guarantee you that you can loose on horses in any rate you prefer. :-) > What this looks like on my end. Feel free to try and make sense > of it yourself. Ok - point taken. -- Björn Lundin b.f.lun...@gmail.com
