Re: slow joining very large table to smaller ones
От
Michael Stone
Тема
Re: slow joining very large table to smaller ones
Дата
Msg-id
20050714224746.GD19080@mathom.us
Ответ на
Re: slow joining very large table to smaller ones (Dan Harris)
Список
Дерево обсуждения
slow joining very large table to smaller ones Dan Harris <fbsd@drivefaster.net>
Re: slow joining very large table to smaller ones John A Meinel <john@arbash-meinel.com>
Re: slow joining very large table to smaller ones Dan Harris <fbsd@drivefaster.net>
Re: slow joining very large table to smaller ones Michael Stone <mstone+postgres@mathom.us>
Re: slow joining very large table to smaller ones Bruno Wolff III <bruno@wolff.to>
Re: slow joining very large table to smaller ones Dawid Kuroczko <qnex42@gmail.com>
Re: slow joining very large table to smaller ones PFC <lists@boutiquenumerique.com>
Re: slow joining very large table to smaller ones John A Meinel <john@arbash-meinel.com>
Re: slow joining very large table to smaller ones John A Meinel <john@arbash-meinel.com>
Re: slow joining very large table to smaller ones Tom Lane <tgl@sss.pgh.pa.us>
Re: slow joining very large table to smaller ones John A Meinel <john@arbash-meinel.com>
Re: slow joining very large table to smaller ones Dan Harris <fbsd@drivefaster.net>
Re: slow joining very large table to smaller ones Tom Lane <tgl@sss.pgh.pa.us>
On Thu, Jul 14, 2005 at 04:29:58PM -0600, Dan Harris wrote: >Ok, I tried this one. My ssh keeps getting cut off by a router >somewhere between me and the server due to inactivity timeouts, so >all I know is that both the select and explain analyze are taking >over an hour to run. Try running the query as a script with nohup & redirect the output to a file. Mike Stone
В списке pgsql-performance по дате отправления
