Re: Strange behaviour with a query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



=?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@xxxxxxxxxxxx> writes:
> ANALYZE;
> And everything working like a charm.... 

> What is the reason for this to happen? Is it common? 

It sounds like you might never have ANALYZEd the database at all, or
anyway not have done so recently.  Recommended practice is to ANALYZE
at least as often as you vacuum.  Or turn on autovacuum and let it
take care of it.

			regards, tom lane

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux