[GENERAL] How to get good performance for very large lists/sets?

2014-10-06 Thread Richard Frith-Macdonald
I'm wondering if anyone can help with advice on how to manage large lists/sets of items in a postgresql database. I have a database which uses multiple lists of items roughly like this: CREATE TABLE List ( ID SERIAL, Name VARCHAR ); and a table containing individual entries in the lis

Re: [GENERAL] How to get good performance for very large lists/sets?

2014-10-06 Thread Richard Frith-Macdonald
On 6 Oct 2014, at 17:54, Igor Neyman wrote: > >> -Original Message- >> From: pgsql-general-ow...@postgresql.org >> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Richard >> Frith-Macdonald >> Sent: Monday, October 06, 2014 4:02 AM &g