try making it in two steps,using temp table maybe. how many rows does the subselect generate ?
-- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
- [GENERAL] how to avoid that a postgres session eats u... Clemens Schwaighofer
- Re: [GENERAL] how to avoid that a postgres sessi... Richard Huxton
- Re: [GENERAL] how to avoid that a postgres s... Grzegorz Jaśkiewicz
- Re: [GENERAL] how to avoid that a postgr... Clemens Schwaighofer
- Re: [GENERAL] how to avoid that a po... Grzegorz Jaśkiewicz
- Re: [GENERAL] how to avoid that... Schwaighofer Clemens
- Re: [GENERAL] how to avoid that a postgres s... Clemens Schwaighofer
- Re: [GENERAL] how to avoid that a postgr... Richard Huxton
- Re: [GENERAL] how to avoid that a po... Clemens Schwaighofer
- Re: [GENERAL] how to avoid that a postgres sessi... Dhaval Jaiswal
