User: Password:
Subscribe / Log in / New account

PostgreSQL pain points

PostgreSQL pain points

Posted Apr 9, 2014 21:04 UTC (Wed) by bcopeland (✭ supporter ✭, #51750)
In reply to: PostgreSQL pain points by walex
Parent article: PostgreSQL pain points

>Also good guesses for semi-automatic advising could work in most cases for most programs by looking at the flags/modes with which a file is opened in fopen or even open as well as the pattern of IO operations on the file like UNIX 25-40 years ago.

There was a paper a while ago where some researchers looked at the filenames for such hints and got quite good results (e.g. an .mpg is mostly read-only and streamed, a .sqlite file may have seeky writes, and so on.) Cute hack.

(Log in to post comments)

Copyright © 2017, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds