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
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
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
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
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