I do use an external drive for some work, though, and it's usable. Tobe more conservative in caching the external drive than it would an internal one. For Windows in particular, it's probably going The external disk isn't going to be blindingly fast, however you use it. > Is that a viable alternative considering the expected size of the DB? Any comments or proposal would be appreciatedĪdding postgis to that, if it's not already included, might take some work. PostgreSQLand PostGIS extensions on each PC (setting-up the proper PGDATA directory to the external disk) until I read WitheSATA connection and may be moved to different locations (and Windows desktops/laptops). > I just started to look at PostgreSQL to implement a large GIS DB (1Tb). > First, I am a Newbie regarding PostgreSQL … On Sep 10, 2014, at 2:00 PM, Daniel Begin wrote: Somewhere on the middle of the left coast Is that a viable alternative considering the expected size of the DB? Any comments or proposal would be appreciated JĪ 1TB database on a single disk drive, presumably 7200rpm, will not perform very well under any sort of concurrency, or doing any sort of operation that requires aggregating a lot of rows.Īlso, Windows disables writeback caching on external disks, this will greatly slow down update transactions. I was looking to install PostgreSQL and PostGIS extensions on each PC (setting-up the proper PGDATA directory to the external disk) until I read about PostgreSQL and PgAdmin Portable … The data must reside in an external disk with eSATA connection and may be moved to different locations (and Windows desktops/laptops). I just started to look at PostgreSQL to implement a large GIS DB (1Tb).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |