Re: [PERFORM] Vacuum running out of memory

2009-12-08 Thread Jonathan Foy
s with minor version changes... On Tue, Dec 8, 2009 at 11:22 AM, Tom Lane wrote: > Jonathan Foy writes: > > My vacuums have suddenly started to fail, seemingly at random. I am > > confused. > > > I'm running 8.1.3, with close to a dozen servers, up to 150 datab

[PERFORM] Vacuum running out of memory

2009-12-08 Thread Jonathan Foy
Hello My vacuums have suddenly started to fail, seemingly at random. I am confused. I'm running 8.1.3, with close to a dozen servers, up to 150 databases each. I have 8GB of RAM. Vacuums have started to fail on all servers (though only the occasional vacuum) with the following error: VACUUM,ER

Re: [PERFORM] View based upon function won't use index on joins

2009-11-20 Thread Jonathan Foy
esponses...I've been gradually getting deeper and deeper into postgres, and am still very much learning as I go. All advice is very helpful. Thanks.. 2009/11/20 Віталій Тимчишин > > > 20 листопада 2009 р. 17:01 Jonathan Foy написав: > > This seems to result in the sam

Re: [PERFORM] View based upon function won't use index on joins

2009-11-20 Thread Jonathan Foy
This seems to result in the same problem; should I attempt to pull for a specific id_nbr/id_qfr, postgres uses the index without a problem. If I try to join the two tables/views however, it insists on doing a sequential scan (actually two in this case) and will not use the index. Any other ideas/e

[PERFORM] View based upon function won't use index on joins

2009-11-19 Thread Jonathan Foy
Hello, I've inherited some very...interestingly... designed tables, and am trying to figure out how to make them usable. I've got an ugly hack in place, but it will not use an index properly, and I'm hoping someone will be able to point me in the right direction. Production is running 8.1.3, but