On Thu, Mar 19, 2009 at 8:42 AM, Anton V. Belyaev <anton.belyaev@xxxxxxxxx> wrote: > I have 4-cored machine, so I expected the query to be able to run for > a long time without performance degrade for application. As Bill mentioned, this won't help a bit if you've got a slow / dodgy / overloaded IO subsystem. What does vmstat 1 60 have to say about the situation when the queries are running? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
