search database with compressed datafiles

Thomas Fragstein

unread,

Jun 30, 2007, 6:07:12 PM6/30/07

to

Hi Group,

i am new in the database topic and i look for an database that can work
with compressed database files.

i look mysql 6 has the falcon engine to do that but i thing postgres
it's ab better database for production.

it is possible that postgres use compressed datafiles?

in my scenario i log traffic data (min 100 mb/hour) for statistik.

sorry for my bad english.

bye
Thomas

Andreas Kretschmer

unread,

Jul 1, 2007, 4:22:43 AM7/1/07

to

begin Thomas Fragstein <ne...@fragstein.de> wrote:
> Hi Group,

> i am new in the database topic and i look for an database that can work
> with compressed database files.

> i look mysql 6 has the falcon engine to do that but i thing postgres
> it's ab better database for production.

> it is possible that postgres use compressed datafiles?

You have nothing to do, this is the default ;-)
http://www.postgresql.org/docs/current/static/storage-toast.html

> in my scenario i log traffic data (min 100 mb/hour) for statistik.

Hmm, how large is one record?

> sorry for my bad english.

Btw, we have a german speaking mailing list and an IRC-channel. I guess,
you are from germany, right?

end
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

Thomas Fragstein

unread,

Jul 2, 2007, 2:14:14 PM7/2/07

to

Hallo Andreas,

>> it is possible that postgres use compressed datafiles?
>
> You have nothing to do, this is the default ;-)
> http://www.postgresql.org/docs/current/static/storage-toast.html

i will read it.

>> in my scenario i log traffic data (min 100 mb/hour) for statistik.
>
> Hmm, how large is one record?

i think one record habe no more than 125 bytes

>
>
>> sorry for my bad english.
>
> Btw, we have a german speaking mailing list and an IRC-channel. I guess,
> you are from germany, right?

Right, i am from Germany.

who i can find the mailling list admin site?
on what irc server i can find the postgres channel?

thx for help

bye
Thomas

Thomas Fragstein

unread,

Jul 2, 2007, 5:22:55 PM7/2/07

to

Thomas Fragstein schrieb:

> Hallo Andreas,
>
>>> it is possible that postgres use compressed datafiles?
>>
>> You have nothing to do, this is the default ;-)
>> http://www.postgresql.org/docs/current/static/storage-toast.html
>
> i will read it.
>
>>> in my scenario i log traffic data (min 100 mb/hour) for statistik.
>>
>> Hmm, how large is one record?
>
> i think one record habe no more than 125 bytes
>
>>
>>
>>> sorry for my bad english.
>>
>> Btw, we have a german speaking mailing list and an IRC-channel. I guess,
>> you are from germany, right?
>
> Right, i am from Germany.
>
> who i can find the mailling list admin site?

i have found the maillinglist

Andreas Kretschmer

unread,

Jul 3, 2007, 1:34:20 AM7/3/07

to

begin Thomas Fragstein schrieb:

>> Btw, we have a german speaking mailing list and an IRC-channel. I guess,
>> you are from germany, right?
>
> Right, i am from Germany.
>
> who i can find the mailling list admin site?
> on what irc server i can find the postgres channel?

Mailinglists:
http://postgresql.de/info.whtml
http://archives.postgresql.org/pgsql-de-allgemein/

Forum:
http://www.pg-forum.de

IRC:
http://www.postgresql.org/community/irc
-> join to #postgresql-de

end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net