norn <andrey.perliev@xxxxxxxxx> wrote: > I have some mysterious slow downs with ORDER BY and LIMIT. When > LIMIT getting greater than some value (greater than 3 in my case), > query takes 4-5 secs instead of 0.25ms. All of the necessary > indexes are in place. I have no idea what to do, so any advices > are welcome! Could you show us the output from "select version();", describe your hardware and OS, and show us the contents of your postgresql.conf file (with all comments removed)? We can then give more concrete advice than is possible with the information provided so far. http://wiki.postgresql.org/wiki/SlowQueryQuestions -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
