Re: SELECT ignoring index even though ORDER BY and LIMIT present

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jori Jovanovich <jori@xxxxxxxxxxxxxxxx> wrote:
 
> what is the recommended way to solve this?
 
The recommended way is to adjust your costing configuration to
better reflect your environment.  What version of PostgreSQL is
this?  What do you have set in your postgresql.conf file?  What does
the hardware look like?  How big is the active (frequently
referenced) portion of your database?
 
-Kevin

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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux