Search Postgresql Archives

Re: reserving space in a rec for future update

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

 



On Wed, Nov 14, 2007 at 11:31:11AM -0500, Gauthier, Dave wrote:
> Thanks for the advanced warning about problems with vaccuum !

Note this isn't a _problem_ with vacuum, exactly, it's just the set of
compromises that PostgreSQL has settled on.  There are other ways of
cleaning up the system ("defrag", of the sort you were implying is one, "pay
the cost during transaction" is another one, &c.).  The piper has to be
paid, and all we're doing is arguing about what currency we'll use :)

A

-- 
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux