Re: Very large tables - Mailing list pgsql-general

From Ron Mayer
Subject Re: Very large tables
Date
Msg-id 493049E3.6060106@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Very large tables  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
List pgsql-general
Grzegorz Jaśkiewicz wrote:
>
> true, if you don't want to search on values too much ,or at all - use
> float[]. But otherwise, keep stuff in a tables as such.
> It might be humongous in size, but at the end of the day - prime thing
> when designing a db is speed of queries.

If he's worried about speed, he might look into porting contrib/intarray
to arrays of floats.   I've had good luck improving performance by
converting big tables of ints into intarray with indexes.

pgsql-general by date:

Previous
From: "William Temperley"
Date:
Subject: Re: Very large tables
Next
From: "Robert Haas"
Date:
Subject: why hash on the primary key?