Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: TOAST compression
- From: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
- To: Neil Conway <neilc(at)samurai(dot)com>
- Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: TOAST compression
- Date: Sun, 26 Feb 2006 10:00:46 -0600
- Message-id: <20060226160046(dot)GX82012(at)pervasive(dot)com>
On Sat, Feb 25, 2006 at 09:39:34PM -0500, Neil Conway wrote: > It's true that LZ decompression is fast, so we should probably use the > compressed version of the datum unless the reduction in size is very > small. I'm not sure precisely what that threshold should be, however. Any idea on how decompression time compares to IO bandwidth? In other words, how long does it take to decompress 1MB vs read that 1MB vs read whatever the uncompressed size is? -- Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
- Follow-Ups:
- Re: TOAST compression
- From: Luke Lonergan
- Re: TOAST compression
- References:
- TOAST compression
- From: Neil Conway
- TOAST compression
- Prev by Date: Re: possible design bug with PQescapeString()
- Next by Date: Re: TOAST compression
- Previous by thread: Re: TOAST compression
- Next by thread: Re: TOAST compression
- Indexes: