Re: Order by and timestamp

[Björn Lundin <b.f.lundin@xxxxxxxxx>]

(1) Suggest using "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

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.lundin@xxxxxxxxx