On 09/06/2013 12:35 PM, Tom Lane wrote:
Brian Fehrle writes:
On 09/05/2013 05:50 PM, Tom Lane wrote:
I rather doubt that the now-explicit-instead-of-implicit casts have much
to do with that. It seems more likely that you forgot to re-ANALYZE in
the new database, or there are some different pl
On 09/18/2013 10:42 AM, fburg...@radiantblue.com wrote:
My colleague is under the impression that dead tuples are only cleaned up via
vacuum
full only, while I suggested that the autovaccum process was cleaning up
these dead tuples. Is this true?
You are correct. Only VACUUM FULL (or CLUSTER)
We are running PostgreSQL 9.1.6 with autovacuum = on and I am reporting on dead tuples using the pgstattuple extension. Each time I run the pgstattuple package our dead tuples counts decrease. My colleague is under the impression that dead tuples are only cleaned up via vacuum full only, while I su
17.09.2013 02:40, Robert Haas пишет:
On Mon, Aug 12, 2013 at 8:21 AM, Александр Белинский wrote:
Hi!
I can't explain why function is slow down on same data.
Postgresql.conf the same, hardware is more powerful.
Diffrents is postgresql version
Hmm. PostgreSQL 9.2 will sometimes replan queries a
