3 ms·

Interesting. Any nice reference about pgsql and query optimization? Any book recommendation? As an old mysql guy, as far as I do db:s, the advice re subquerie

by berntb 17y ago

Interesting. Any nice reference about pgsql and query optimization? Any book recommendation? As an old mysql guy, as far as I do db:s, the advice re subqueries (#4) was unusual... :-) (I looked at trying pgsql for a hobby a few years back and found lacking support for different char sets for different tables, etc. Is that [still] so?)

rudd 17y ago
Yes, I'm pretty sure charset support in Postgres is at the database level, not the table level. See here: http://www.postgresql.org/docs/8.4/interactive/multibyte.html http://www.postgresql.org/docs/8.4/interactive/multibyte.htm...
- berntb 17y ago
  Ah, thanks. Sigh. (No book recommendations for something like e.g. "High Performance MySQL"? Well, nice with no fanatical fanboys in this area, at least. :-)
  - olefoo 17y ago
    If you are looking for a book on Postgresql the Douglas book http://www.amazon.com/PostgreSQL-Developers-Library-Korry-Douglas/dp/0672327562 http://www.amazon.com/PostgreSQL-Developers-Library-Korry-Do... is pretty good introduction to most of the topics specific to postgres, it includes a sample implementation of a postgres accessing script in most of the languages commonly used for the task, which can be a bit repetitive (perl, python, php, java, C, same tune different instrument) but that does make it a fairly good reference.
  - gtuhl 17y ago
    Thought I was add that the PostgreSQL documentation is really, really good for learning. It is a bit dense but overall very well written, includes nontrivial examples, and you can really get a solid dive into a topic reading it. The current 8.3 documentation is here: http://www.postgresql.org/docs/8.3/static/ http://www.postgresql.org/docs/8.3/static/ I especially enjoy the sections on indexes: http://www.postgresql.org/docs/8.3/static/indexes.html http://www.postgresql.org/docs/8.3/static/indexes.html

by berntb 17y ago

rudd 17y ago

Yes, I'm pretty sure charset support in Postgres is at the database level, not the table level. See here: http://www.postgresql.org/docs/8.4/interactive/multibyte.html http://www.postgresql.org/docs/8.4/interactive/multibyte.htm...

berntb 17y ago
Ah, thanks. Sigh. (No book recommendations for something like e.g. "High Performance MySQL"? Well, nice with no fanatical fanboys in this area, at least. :-)
- olefoo 17y ago
  If you are looking for a book on Postgresql the Douglas book http://www.amazon.com/PostgreSQL-Developers-Library-Korry-Douglas/dp/0672327562 http://www.amazon.com/PostgreSQL-Developers-Library-Korry-Do... is pretty good introduction to most of the topics specific to postgres, it includes a sample implementation of a postgres accessing script in most of the languages commonly used for the task, which can be a bit repetitive (perl, python, php, java, C, same tune different instrument) but that does make it a fairly good reference.
- gtuhl 17y ago
  Thought I was add that the PostgreSQL documentation is really, really good for learning. It is a bit dense but overall very well written, includes nontrivial examples, and you can really get a solid dive into a topic reading it. The current 8.3 documentation is here: http://www.postgresql.org/docs/8.3/static/ http://www.postgresql.org/docs/8.3/static/ I especially enjoy the sections on indexes: http://www.postgresql.org/docs/8.3/static/indexes.html http://www.postgresql.org/docs/8.3/static/indexes.html