dbTalk Databases Forums  

search database with compressed datafiles

comp.databases.postgresql comp.databases.postgresql


Discuss search database with compressed datafiles in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Thomas Fragstein
 
Posts: n/a

Default search database with compressed datafiles - 06-30-2007 , 05:07 PM






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

Reply With Quote
  #2  
Old   
Andreas Kretschmer
 
Posts: n/a

Default Re: search database with compressed datafiles - 07-01-2007 , 03:22 AM






begin Thomas Fragstein <news (AT) fragstein (DOT) de> wrote:
Quote:
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/curre...age-toast.html


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


Quote:
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°


Reply With Quote
  #3  
Old   
Thomas Fragstein
 
Posts: n/a

Default Re: search database with compressed datafiles - 07-02-2007 , 01:14 PM



Hallo Andreas,

Quote:
it is possible that postgres use compressed datafiles?

You have nothing to do, this is the default ;-)
http://www.postgresql.org/docs/curre...age-toast.html
i will read it.

Quote:
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

Quote:

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


Reply With Quote
  #4  
Old   
Thomas Fragstein
 
Posts: n/a

Default Re: search database with compressed datafiles - 07-02-2007 , 04:22 PM



Thomas Fragstein schrieb:
Quote:
Hallo Andreas,

it is possible that postgres use compressed datafiles?

You have nothing to do, this is the default ;-)
http://www.postgresql.org/docs/curre...age-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

Quote:
on what irc server i can find the postgres channel?

thx for help

bye
Thomas

Reply With Quote
  #5  
Old   
Andreas Kretschmer
 
Posts: n/a

Default Re: search database with compressed datafiles - 07-03-2007 , 12:34 AM



begin Thomas Fragstein schrieb:
Quote:
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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.