Decibel! <decibel(at)decibel(dot)org> writes:
> On Aug 16, 2008, at 9:19 PM, Gurjeet Singh wrote:
>> Awesome!!!! Any comments on the performance of hstore?
> I've looked at it but haven't actually used it. One thing I wish it
> did was to keep a catalog somewhere of the "names" that it's seen so
> that it wasn't storing them as in-line text. If you have even
> moderate-length names and are storing small values you quickly end up
> wasting a ton of space.
> BTW, now that you can build arrays of composite types, that might be
> an easy way to deal with this stuff. Create a composite type of
> (name_id, value) and store that in an array.
If you're worried about storage space, I wouldn't go for arrays of
composite :-(. The tuple header overhead is horrendous, almost
certainly a lot worse than hstore.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2008-08-20 18:28:18|
|Subject: Re: Slow query with a lot of data |
|Previous:||From: Scott Carey||Date: 2008-08-20 18:06:06|
|Subject: Re: Slow query with a lot of data|