On Tue, Jun 1, 2010 at 9:03 AM, Torsten Zühlsdorff <f...@meisterderspiele.de> wrote: > Hello, > > i have a set of unique data which about 150.000.000 rows. Regullary i get a > list of data, which contains multiple times of rows than the already stored > one. Often around 2.000.000.000 rows. Within this rows are many duplicates > and often the set of already stored data. > I want to store just every entry, which is not within the already stored > one. Also i do not want to store duplicates. Example:
The standard method in pgsql is to load the data into a temp table then insert where not exists in old table. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance