Does pgsql provide support for a clustered index? By that I mean can I specify that the database insert records in the order of a particular attribute. Many of my queries are time-range based and my row inserts are done chronologically, so it would benefit to have them sorted by when they were inserted.
Also, can pgsql be embedded in an application? By that I mean it is easily deployable with an application. The end user is unaware that a database even exists and the end user does not need to install pgsql. I do NOT mean a db that runs on an embedded device (although I am hoping pgsql has a small memory footprint) and I also do NOT mean to ask if pgsql supports embedded sql.