Re: PG 8.3 and large shared buffer settings

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

 



* Scott Carey <scott@xxxxxxxxxxxxxxxxx> [090925 11:57]:
> That won't work well anyway because the postgres shared_buffers dos not cache things that are sequentially scanned (it uses a ring buffer for each scan).  So, for any data that is only accessed by sequential scan, you're relying on the OS and the disks.  If you access a table via index scan though, all its pages will go through shared_buffers.

In older version too, or only since synchronized scans got in?

a.


-- 
Aidan Van Dyk                                             Create like a god,
aidan@xxxxxxxxxxx                                       command like a king,
http://www.highrise.ca/                                   work like a slave.

Attachment: signature.asc
Description: Digital signature


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux