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

2014-01-27 Thread Peter Blair
les in each directory. Why are there so many files? Thank you everyone for your time. Peter Blair

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

2014-01-28 Thread Peter Blair
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

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

2014-01-29 Thread Peter Blair
pg_class table How do I get rid of those other files? Just a guess, but do I shutdown the database, and delete any file not listed in pg_class? I do not see anything in the PostgreSQL documentation about this. Thank again. On Tue, Jan 28, 2014 at 9:47 AM, Peter Blair wrote: > Tom, > >