22 Aug
2009
22 Aug
'09
8:47 p.m.
On 22-08-2009 09:57:22 +0200, Stefan Manegold wrote:
ps: It is interesting to hear that the "vacuum" command in PostgreSQL had a significant impact on a simple select * from table query over bulk-loaded data, i.e., without any updates being performed --- I wouldn't know wht akind of "garbage" bulk-loading leaves behind that needs to be cleaned-up ...
If I recall correctly, vacuum also calls analyze implicitly, which means statistics are being built, and hence a simple select * from X, can be answered from the statistics without even looking at table X itself.