# PostgreSQL

**URL:** <https://forum.inductiveautomation.com/t/postgresql/10915>\
**Category:** Archived Topics\
**Created:** [December 14, 2015, 6:45pm UTC](https://forum.inductiveautomation.com/t/postgresql/10915 "2015-12-14T18:45:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vnewman1963](https://avatars.discourse-cdn.com/v4/letter/v/d2c977/32.png) [@vnewman1963](https://forum.inductiveautomation.com/u/vnewman1963)\
**Post date:** [December 14, 2015, 6:45pm UTC](https://forum.inductiveautomation.com/t/postgresql/10915/1 "2015-12-14T18:45:48Z")

</div>

Has anyone used PostgreSQL with ignition? How was it , Stability etc…

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 14, 2015, 7:53pm UTC](https://forum.inductiveautomation.com/t/postgresql/10915/2 "2015-12-14T19:53:31Z")

</div>

I use almost nothing but PostgreSQL. Primarily because it has the absolute best SQL standard conformance in a freely licensed platform, and because it implements the major transaction isolation levels throughout its design.  
It is very stable, but does require some adjustment for best performance: the defaults for shared buffers and work memory tend to be too low. The online documentation is very good. You should start [here](http://www.postgresql.org/docs/9.4/interactive/index.html) and [here](https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server).

---

<div class="post-metadata">

**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\
**Post date:** [December 16, 2015, 9:34am UTC](https://forum.inductiveautomation.com/t/postgresql/10915/3 "2015-12-16T09:34:19Z")

</div>

I also use only postgreSQL and I agree with everything, what @pturmel said.  
I started with postgreSQL mainly because at the time it was the only free db which supported timestamp with ms (milliseconds) and because it was (is) really free for commercial use (not like MySQL). Now I don’t know for other db’s (free) if they’re supporting ms timestamp, but I’m stuck with postgreSQL… ![:thumb_left:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e26afb081ddde6df016df6ee49159cf56aaca688.gif ":thumb\_left:")