[GENERAL] Creating only static libpg libraries.

[Mimiko]

Hello.

Is there an option to configure or make scripts to build only static 
libraries (.a) without shared libraries for version 9.4?


When using libpq in other projects, which have --disable-shared and 
--enable-static, build is successful, but the project will not work 
without .so library of pgsql.


--
Mimiko desu.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Designing a DB for storing biological data

[Andy Colson]

On 06/14/2014 10:52 AM, Damir Dezeljin wrote:

Hello.





*Finally, here is my dilemma* I am somewhat undecided what is the
best way to implement the database and consequently what kind of
queries to use. At above link a database model I am currently working
on can be found. Looking to the diagram it becomes evident I am
deciding if storing every measurement / determinant / depth triple as
a separate record. The biggest dilemma I have is a query for a simple
sample of pressure, temperature, salinity and oxygen would imply
multiple joins. As far as I know, this will badly affect the
performance; as well, it will harden codding the RESTful interface.




Thanks and best regards, Damir



Normalizing the data into multiple tables ensures correctness.  Worry about 
being correct before you worry about performance.  Don't worry about multiple 
joins being slow, databases are designed to be fast with small tables with lots 
of rows and joining them together.

Correctness first.  Don't worry about join performance, its fast.

-Andy


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general