Re: [SQL] Memory usage on subselect

2004-05-23 Thread Alexander M. Pravking
On Sun, May 23, 2004 at 12:28:18PM -0400, Tom Lane wrote: > "Alexander M. Pravking" <[EMAIL PROTECTED]> writes: > > I've got a memory usage problem when I try to do a subselect on the same > > table as the main select (PostgreSQL 7.3.4 on FreeBSD). Here's my query: > > ... > > The "services" table

Re: [SQL] Memory usage on subselect

2004-05-23 Thread Tom Lane
"Alexander M. Pravking" <[EMAIL PROTECTED]> writes: > I've got a memory usage problem when I try to do a subselect on the same > table as the main select (PostgreSQL 7.3.4 on FreeBSD). Here's my query: > ... > The "services" table is indexed only on "id" column and has about a > thousand tuples. sr