Re: Optimizing select count query which often takes over 10 seconds

From:	Kevin Grittner <kgrittn(at)ymail(dot)com>
To:	Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc:	pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject:	Re: Optimizing select count query which often takes over 10 seconds
Date:	2013-01-29 23:09:26
Message-ID:	1359500966.5795.YahooMailNeo@web162905.mail.bf1.yahoo.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2013-01-24 09:57:43 from Alexander Farber <alexander(dot)farber(at)gmail(dot)com>  2013-01-24 12:47:49 from Moshe Jacobson <moshe(at)neadwerx(dot)com>  2013-01-24 14:39:27 from Alban Hertroys <haramrae(at)gmail(dot)com>   2013-01-24 14:45:47 from Alexander Farber <alexander(dot)farber(at)gmail(dot)com>    2013-01-24 16:24:45 from Alban Hertroys <haramrae(at)gmail(dot)com>    2013-01-24 19:12:58 from Guillaume Lelarge <guillaume(at)lelarge(dot)info>     2013-01-25 15:13:38 from Alexander Farber <alexander(dot)farber(at)gmail(dot)com>      2013-01-25 16:00:06 from Guillaume Lelarge <guillaume(at)lelarge(dot)info>  2013-01-25 18:42:38 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>   2013-01-27 17:25:02 from Alexander Farber <alexander(dot)farber(at)gmail(dot)com>    2013-01-27 19:41:30 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>     2013-01-28 07:57:39 from Alexander Farber <alexander(dot)farber(at)gmail(dot)com>      2013-01-29 13:03:39 from Alexander Farber <alexander(dot)farber(at)gmail(dot)com>       2013-01-29 23:09:26 from Kevin Grittner <kgrittn(at)ymail(dot)com>        2013-01-30 07:41:40 from Alexander Farber <alexander(dot)farber(at)gmail(dot)com>         2013-01-30 08:00:24 from Alexander Farber <alexander(dot)farber(at)gmail(dot)com>          2013-01-30 13:06:57 from Kevin Grittner <kgrittn(at)ymail(dot)com>           2013-01-31 09:01:14 from Alexander Farber <alexander(dot)farber(at)gmail(dot)com>         2013-01-30 12:58:41 from Kevin Grittner <kgrittn(at)ymail(dot)com>         2013-01-30 15:18:17 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Lists:	pgsql-general

In response to

• Re: Optimizing select count query which often takes over 10 seconds at 2013-01-29 13:03:39 from Alexander Farber

Responses

• Re: Optimizing select count query which often takes over 10 seconds at 2013-01-30 07:41:40 from Alexander Farber

Browse pgsql-general by date

	From	Date	Subject
Next Message	Noah Misch	2013-01-30 01:51:55	Re: BUG #7493: Postmaster messages unreadable in a Windows console
Previous Message	Adrian Klaver	2013-01-29 19:30:21	Re: Is there a way to add a detail message in a warning with pl/Python?