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