Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using PostgreSQL 9.2 with my web application that has three servlets with three selects.

I turn on the log.

When I send my first query: select * from "Nomi" limit 4

before it the log shows me this other line:

execute <unnamed>: SET extra_float_digits = 3

What is this command?

share|improve this question
up vote 2 down vote accepted

Looks like that is a default setting in postgresql 8.5 onwards to guarantee recovery of higher precisions floats..

share|improve this answer
Version 8.5 doesn't exist, it's 9.0 – Frank Heikens Dec 28 '12 at 9:33
@Frank: I think 8.5 might be a dev version (here is the relevant commit for this change, I am not too sure about the versioning though.. – WrinkleFree Dec 28 '12 at 11:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.