Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Slow count(*) again... - Mailing list pgsql-performance

From Nick Lello
Subject Re: [HACKERS] Slow count(*) again...
Date
Msg-id AANLkTikK86APLfOTdxekudXgK3DNPusbAQZMFfDXoas_@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Slow count(*) again...  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-performance
Tree view

Informix IDS supports hints as well; normally the only need for hints in this engine is when the Table/Index statistics are not being updated on a regular basis (ie: lazy DBA).


On 3 February 2011 22:17, Mark Kirkwood <mark.kirkwood@catalyst.net.nz> wrote:
On 04/02/11 11:08, Josh Berkus wrote:
I don't think that's actually accurate.  Can you give me a list of
DBMSes which support hints other than Oracle?

DB2 LUW (Linux, Unix, Win32 code base) has hint profiles:

http://justdb2chatter.blogspot.com/2008/06/db2-hints-optimizer-selection.html



--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



--
 
 
Nick Lello | Web Architect
o +44 (0) 8433309374 | m +44 (0) 7917 138319
Email: nick.lello at rentrak.com
RENTRAK | www.rentrak.com | NASDAQ: RENT


pgsql-performance by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [HACKERS] Slow count(*) again...
Next
From: Mikkel Lauritsen
Date:
Subject: Different execution plans for semantically equivalent queries