[GENERAL] Translate function and strange results ...

Thanks, -- Hervé Piedvache -- 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] Translate function and strange results ...

? He said SQL_ASCII. translate() will definitely not work nicely with multibyte characters if it doesn't know they are multibyte :-( regards, tom lane -- Hervé Piedvache -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Kernel kills postgres process - help need

number of backends? You never answered me to this point ... we use persistants connections so I don't understand the interest of using a pooler ... Otherwise, what pooler do you recommand, and what will be the improvement for us ? Thanks, -- Hervé Piedvache Elma Ingénierie Informatique Groupe

Re: [GENERAL] Kernel kills postgres process - help need

is the best way to process with a pooler ... install one on each node or one on each database ? Regards, Le jeudi 7 février 2008, Alvaro Herrera a écrit : Hervé Piedvache escribió: Tom, Le mercredi 9 janvier 2008, Tom Lane a écrit : =?utf-8?q?Herv=C3=A9_Piedvache?= [EMAIL PROTECTED

[GENERAL] Kernel kills postgres process - help need

Hi, I have a big trouble with a PostgreSQL server ... regulary since I have added 8 Gb of memory, on a server having already 8Gb of memory, I have troubles. Nothing else have changed ... I'm on a Dell server, and all the memory diagnostics from Dell seems to be good ... When I have a lot of

Re: [GENERAL] Kernel kills postgres process - help need

Tom, Le mercredi 09 janvier 2008, Tom Lane a écrit : =?utf-8?q?Herv=C3=A9_Piedvache?= [EMAIL PROTECTED] writes: When I have a lot of connexions (persistante connexions from 6 web apache/php serveurs using PDO, about 110 process on each web servers) on the server, or long request, it's

Re: [GENERAL] Kernel kills postgres process - help need

is only Linux basic process (cron, atd, getty etc.) regards, -- Hervé Piedvache ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Is there something like MySQL enterprise monitor for Postgres?

but get used thousands time won't be spotted). What about a log analyser? What about a configuration wizard that eat your logs and suggest improvement to the config? -- Hervé Piedvache ---(end of broadcast)--- TIP 3: Have you checked our extensive

[GENERAL] nonremovable row ?

, containing 694487 live rows and 26232918 dead rows; 30 rows in sample, 694487 estimated total rows VACUUM Why I get 26927405 nonremovable row versions in 185707 pages ? How to remove them ? I need to free the space quickly ! Thanks for help ... -- Hervé Piedvache NOUVELLE ADRESSE - NEW ADDRESS

[GENERAL] Accessing two differents database in a SELECT

Hi, How and is it possible to access to two differents tables which are stored in two differents database ? Will it be possible one day ? Thanks for your answers, -- Hervé ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [GENERAL] Really SLOW using GROUP BY ...!?

Hi Tom, Tom Lane a écrit : Unfortunately neither of these plans is likely to be especially speedy on ~3 million rows. The index scan will just thrash the disk, unless the table has been clustered recently --- and given the deficiencies of our CLUSTER implementation, I'd hesitate to