Search Postgresql Archives

Re: Order by and timestamp

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




(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.  

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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux