Hi Scott,
Thank you for your answer, this is exactly what happens in this situation.
--- On Fri, 7/22/11, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> From: Scott Marlowe <scott.marlowe@gmail.com>
> Subject: Re: [GENERAL] Why do I have reading from the swap partition?
> To: "Ioana Danes" <ioanasoftware@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 <ioanasoftware@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
>