Nothing larger then int8?
От | The Hermit Hacker |
---|---|
Тема | Nothing larger then int8? |
Дата | |
Msg-id | Pine.BSF.4.31.0101180049580.548-100000@thelab.hub.org обсуждение исходный текст |
Ответы |
Re: Nothing larger then int8?
Re: Nothing larger then int8? |
Список | pgsql-hackers |
I'm logging traffic to a database, so that I can do analysis on usage and whatnot, and I need something bigger then int8 :( /tmp/psql.edit.70.79087: 6 lines, 222 characters. ip | maxbytes | port | runtime ---------------+-------------+------+------------------------216.126.84.28 | 2169898055 | 80 | 2001-01-16 00:00:00-05216.126.84.28| 160579228 | 873 | 2001-01-16 00:00:00-05216.126.84.28 | 365270 | 20 | 2001-01-16 00:00:00-05216.126.84.28| 196256 | 21 | 2001-01-16 00:00:00-05216.126.84.28 | 195238 | 22 | 2001-01-16 00:00:00-05216.126.84.28| 182492 | 1024 | 2001-01-16 00:00:00-05216.126.84.28 | 171155 | 143 | 2001-01-16 00:00:00-05216.126.84.28| -1392384544 | 80 | 2001-01-13 00:00:00-05216.126.84.28 | -1392384544 | 80 | 2001-01-04 00:00:00-05216.126.84.28| -1392384544 | 80 | 2001-01-05 00:00:00-05216.126.84.28 | -1392384544 | 80 | 2001-01-06 00:00:00-05216.126.84.28| -1392384544 | 80 | 2001-01-07 00:00:00-05216.126.84.28 | -1392384544 | 80 | 2001-01-08 00:00:00-05216.126.84.28| -1392384544 | 80 | 2001-01-14 00:00:00-05216.126.84.28 | -1452855018 | 80 | 2001-01-15 00:00:00-05216.126.84.28| -1452855018 | 80 | 2001-01-10 00:00:00-05216.126.84.28 | -1452855018 | 80 | 2001-01-09 00:00:00-05216.126.84.28| -1513325492 | 80 | 2001-01-03 00:00:00-05216.126.84.28 | -1694736914 | 80 | 2001-01-12 00:00:00-05216.126.84.28| -1815677862 | 80 | 2001-01-11 00:00:00-05 hub_traf_stats=# \d daily_stats Table "daily_stats"Attribute | Type | Modifier -----------+-----------+----------ip | inet |port | integer |bytes | bigint |runtime | timestamp| do we have anything larger to work with? I've checked docs, but that looks like about it :( Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
В списке pgsql-hackers по дате отправления: