Re: [PERFORM] Select hangs and there are lots of files in table and index directories.

Tom, You are correct. The was an infinate loop created because of the differences in the date math between Oracle and Postgres. Thank again for your help. On Mon, Jan 27, 2014 at 7:43 PM, Tom Lane wrote: > Peter Blair writes: > > Have a problem where a stored procedure is taking a week to run

Re: [PERFORM] Slow query (wrong index used maybe)

RHEL 5.10 kernel 2.6.18 -- View this message in context: http://postgresql.1045698.n5.nabble.com/Slow-query-wrong-index-used-maybe-tp5788979p5789206.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance mailing list (pgsql-performance@p

Re: [PERFORM] Slow query (wrong index used maybe)

On Mon, Jan 27, 2014, at 11:43, Gavin Flower wrote: > On 28/01/14 08:10, bobJobS wrote: > > My developers have had the same issue. > > > > Postgres 9.2.3 on Linux 5.6. > > > The latest Linux kernel is 3.13 (https://www.kernel.org), so I assume > 5.6 is a distribution version. > > So which distr