Re: Why do I have reading from the swap partition?

Hi Scott,

Thank you for your answer, this is exactly what happens in this situation.

--- On Fri, 7/22/11, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:

> From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
> Subject: Re: [GENERAL] Why do I have reading from the swap partition?
> To: "Ioana Danes" <ioanasoftware(at)yahoo(dot)ca>
> Cc: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
> Received: Friday, July 22, 2011, 3:24 PM
> On Fri, Jul 22, 2011 at 12:19 PM,
> Ioana Danes <ioanasoftware(at)yahoo(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>