Hi Scott, Thank you for your answer, this is exactly what happens in this situation.
--- On Fri, 7/22/11, Scott Marlowe <scott.marl...@gmail.com> wrote: > From: Scott Marlowe <scott.marl...@gmail.com> > Subject: Re: [GENERAL] Why do I have reading from the swap partition? > To: "Ioana Danes" <ioanasoftw...@yahoo.ca> > Cc: "PostgreSQL General" <pgsql-general@postgresql.org> > Received: Friday, July 22, 2011, 3:24 PM > On Fri, Jul 22, 2011 at 12:19 PM, > Ioana Danes <ioanasoftw...@yahoo.ca> > 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 (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general