[GENERAL] server optimisation

I'm look for documentation about server optimization. the only thing I find is QUERY optimization. there are a lot of parameter in postgresql.conf no site explain which value is better ---(end of broadcast)--- TIP 5: don't forget to increase your fr

Re: [GENERAL] PHP and Postgres arrays

Le vendredi 18 janvier 2008 à 23:10 +0100, Ivan Sergio Borgonovo a écrit : > On Fri, 18 Jan 2008 23:01:09 +0100 > Yannick Warnier <[EMAIL PROTECTED]> wrote: > > > Hello, > > > I've been searching (not very thoroughly, but still) for a way to > > get Post

[GENERAL] PHP and Postgres arrays

ose arrays than copy-pasting the user-proposed PHP functions? Thanks, Yannick Warnier [1] http://www.php.net/manual/en/ref.pgsql.php#58660 [2] http://www.perlmonks.org/?node_id=474518 ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] GiST and Gin technical doc

m the source code (I'm not too much into C/C++)? Thank you, Yannick ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] "People near me" query

at's still flying like a bird). A more precise way of doing this would be to keep a table with distances between cities, and then calculate your way to your destination by taking the shorter path (and that's only a question of distance, not time)... That's really a lot more calculations