We are currently storing a large amount of networking data. The database size is over 50 Gigabytes. It also grows by 10 Gigabytes every month.
We are looking if there is a way to speedup lookups by IP Address. The primary key is a set of values. And the key does include IP Address as well. Will it be more efficient to also add index on IP Address to speedup lookups by IP? -- Regards, Maksim -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
