Re: [PERFORM] Index occupancy

2006-02-04 Thread Tom Lane
"tschak" <[EMAIL PROTECTED]> writes: > I have a question concerning the size of an index... > What I acually did was bulid a btree index on an smallint attribute > within a table with 10^8 rows. The table itself is app. 10GB large and > what I would like to have the smallest possible indeces. Unfor

[PERFORM] Index occupancy

2006-02-04 Thread tschak
Hi everyone, I have a question concerning the size of an index... What I acually did was bulid a btree index on an smallint attribute within a table with 10^8 rows. The table itself is app. 10GB large and what I would like to have the smallest possible indeces. Unfortunately the current size is ab

Re: [PERFORM] Storing Digital Video

2006-02-04 Thread Jeffrey W. Baker
On Tue, 2006-01-31 at 16:32 -0800, Rodrigo Madera wrote: > I am concerned with performance issues involving the storage of DV on > a database. > > I though of some options, which would be the most advised for speed? > > 1) Pack N frames inside a "container" and store the container to the db. > 2)