Hi Scott, Thank you for your answer, this is exactly what happens in this situation.
--- On Fri, 7/22/11, Scott Marlowe <[email protected]> wrote: > From: Scott Marlowe <[email protected]> > Subject: Re: [GENERAL] Why do I have reading from the swap partition? > To: "Ioana Danes" <[email protected]> > Cc: "PostgreSQL General" <[email protected]> > Received: Friday, July 22, 2011, 3:24 PM > On Fri, Jul 22, 2011 at 12:19 PM, > Ioana Danes <[email protected]> > wrote: > > > I do a select * from a 8 GB table (a different one > then the one used in the query). At a point it starts using > swap space on disk. Once it starts swapping I still let it > run for couple of minutes and the I stop it (CTRL+C). > > Are you running psql on the same machine? My guess is > that psql is > what's swapping. Try running: > > select count(*) from (select * from mybigfreakingtable); > > and see if you start hitting swap like that. > > -- > Sent via pgsql-general mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
