| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com> |
| Cc: | Chris Browne <cbbrowne(at)acm(dot)org>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] Slow count(*) again... |
| Date: | 2011-02-04 23:17:12 |
| Message-ID: | 201102042317.p14NHCK12314@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Mladen Gogala wrote:
> Chris Browne wrote:
> > Well, the community declines to add hints until there is actual
> > consensus on a good way to add hints.
> >
> OK. That's another matter entirely. Who should make that decision? Is
> there a committee or a person who would be capable of making that decision?
>
> > Nobody has ever proposed a way to add hints where consensus was arrived
> > at that the way was good, so...
> >
>
> So, I will have to go back on my decision to use Postgres and
> re-consider MySQL? I will rather throw away the effort invested in
You want to reconsider using MySQL because Postgres doesn't have hints.
Hard to see how that logic works.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2011-02-04 23:25:25 | Re: SSI performance |
| Previous Message | Kevin Grittner | 2011-02-04 23:11:28 | Re: SSI performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tobias Brox | 2011-02-04 23:24:44 | table partitioning and select max(id) |
| Previous Message | Chris Browne | 2011-02-04 23:15:10 | Re: getting the most of out multi-core systems for repeated complex SELECT statements |