Re: [GENERAL] Translate function and strange results ...

coding; tell you? > > 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

[GENERAL] Translate function and strange results ...

translate --- Hervai (1 row) base=# \encoding SQL_ASCII 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] Kernel kills postgres process - help need

ons), what 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 : > > >

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

ions = 2048 > > Have you considered using a connection pooler in front of a smaller > 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,

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

ss was the cause of this ... !? > You may also consider some other linux configuration options that make > invocation of OOM killer less likely. On this server there is only Postgresql, slony, and sshd running the rest 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] 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, i

[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 con

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

alue. > > That is interesting but it may be misleading (something that is below > the threshold 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?

Re: [GENERAL] Wordpress & PostgreSQL ...

615664 > > > ---(end of broadcast)------- > TIP 6: explain analyze is your friend -- Hervé Piedvache Elma Ingénierie Informatique Groupe Maximiles S.A. 3 rue d'Uzès F-75002 - Paris - France Pho. 33-144949901 Fax. 33-144882747 ---(e

Re: [GENERAL] Big trouble with memory !!

cumentation knows > what it's talking about ;-) hugh ? I can't read that ... PostgreSQL documentation is my bible ... the only good explanation are always inside the PostgreSQL documentation ... :o) May be a correction for the next release ? -- Hervé Piedvache NOUVELLE ADRESSE - NEW ADD

Re: [GENERAL] Big trouble with memory !!

nel/0501.2/1295.html > > Hmm, in particular Andrea Arcangeli implies here > http://www.ussg.iu.edu/hypermail/linux/kernel/0501.2/1358.html > that there are some pretty serious bugs in this area in 2.6.10. OK I downgrade to 2.6.9 ... Let's see ! Thanks ! -- Hervé Piedvache NOUVELLE ADR

Re: [GENERAL] Big trouble with memory !!

On Wednesday 06 April 2005 17:03, Richard Huxton wrote: > Hervé Piedvache wrote: > > Hi, > > > > We have switched to kernel 2.6.11.6 from kernel 2.4.26 ... since this > > date we have many troubles with PostgreSQL and most of them seems to be > > memory troub

[GENERAL] Big trouble with memory !!

ges = 60 # min max_fsm_relations*16, 6 bytes each max_fsm_relations = 5000# min 100, ~50 bytes each # - Kernel Resource Usage - #max_files_per_process = 1000 # min 25 #preload_libraries = '' Regards, -- Hervé Piedvache NOUVELLE ADRESSE - NEW ADDRESS : Elma Ingénierie

[GENERAL] Pg 8.01 big trouble with LIMIT (bug !?)

dex Cond: (s.id_site = "outer".id_site) Filter: (("language" = 'aa'::text) AND (id_category = 11)) (6 rows) Time: 1.020 ms Thanks per advance for your ideas ... Regards, -- Hervé Piedvache Elma Ingénierie Informatique 6 rue du Faubourg Saint-Honor

Re: [GENERAL] French paper

list archives? > > http://archives.postgresql.org -- Hervé Piedvache Elma Ingénierie Informatique 6 rue du Faubourg Saint-Honoré F-75008 - Paris - France Pho. 33-144949901 Fax. 33-144949902 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] RSS Feeds are dead on Web site

I don't know who to contact ... but the rss feeds are dead on the PostregSQL.org web site ... Regards, -- Bill Footcow ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] URGENT pg_xlog full impossible to restart ...

OK it's running again many thanks ! :o) But Tom ... could you clearly explain me what is the parameter to set in the postgresql.conf to never have my pg_xlog partition's going full ?? I have 1.8 Gb dedicated to pg_xlog and I have set those options : checkpoint_segments = 3 # in logfile segments

Re: [GENERAL] URGENT pg_xlog full impossible to restart ...

Tom, Le samedi 17 Juillet 2004 23:06, Tom Lane a écrit : > =?iso-8859-15?q?Herv=E9_Piedvache?= <[EMAIL PROTECTED]> writes: > > How to solve this ??? My pg_xlog partition is full ... :o( > > ... so free up some space ... But my pg_xlog partition is dedicated to the WAL files ... so I can't delete

[GENERAL] URGENT pg_xlog full impossible to restart ...

Hi, I have my database stoping by itself during a vacuum full analyse; Impossible to restart it ... I have this message : Jul 17 22:03:09 stats-ugc postgres[7239]: [2-1] LOG: database system was shut down at 2004-07-17 20:53:06 CEST Jul 17 22:03:09 stats-ugc postgres[7239]: [3-1] LOG: checkpoi

[GENERAL] pam authentification trouble ...

linux, on Debian Woody ... but using my own compilation of PostgreSQL v7.4.3. Regards, -- Hervé Piedvache Elma Ingénierie Informatique 6 rue du Faubourg Saint-Honoré F-75008 - Paris - France Pho. 33-144949901 Fax. 33-144949902 ---(end of broadcast)---

Re: [GENERAL] How estimated rows is running ?

Scott, Le mercredi 7 Avril 2004 22:13, scott.marlowe a écrit : > On Wed, 7 Apr 2004, [iso-8859-15] Hervé Piedvache wrote: > > > > I have a database with one table with about 22 millions records. > > I have a script every day wich insert about 200 000 records ... > >

[GENERAL] How estimated rows is running ?

pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.06 sec. INFO: analyzing "public.my_table" INFO: "my_table": 431553 pages, 3 rows sampled, 22440007 estimated total rows V

Re: [GENERAL] WAL Files checkpoint_timeout with voluminous delete/insert

# in logfile segments, min 1, 16MB each Unset in the config file ... so default value ... 3 ? So, any idea of my problem ? regards, -- Hervé Piedvache Elma Ingénierie Informatique 6 rue du Faubourg Saint-Honoré F-75008 - Paris - France Pho. 33-144949901 Fax. 33-144949902 -

[GENERAL] WAL Files checkpoint_timeout with voluminous delete/insert

any test ? ... Is it possible in futur version to change somewhere in realtime this value just for big insert like this ... or this idea have no sence ? Thanks for your reply, Regards, -- Hervé Piedvache Elma Ingénierie Informatique 6 rue du Faubourg Saint-Honoré F-75008 - Paris - Fran

[GENERAL] Why lower's not accept an AS declaration ?

ibute "letter" not found You can imagine my test is simple, in practise it's not the reallity of my original request ... but this example is just to show that lower() function does not accept an AS declaration ... is it normal ? Thanks for your answers ... Regards, -- Hervé Piedva

Re: [GENERAL] PostgreSQL consulting company in France or Europe?

people we don't like" > > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > >http://www.postgresql.org/docs/faqs/FAQ.html -- Hervé Piedvache Elma Ingénierie Informatique 6 rue du Faubourg Saint-Hono

Re: [GENERAL] Selecting dupes from table

takes 30 seconds with 25.000 entries. I have index on url. > > Can I use any other query to select this faster. -- Hervé Piedvache Elma Ingénierie Informatique 6 rue du Faubourg Saint-Honoré F-75008 - Paris - France Pho. 33-144949901 Fax. 33-144949902 ---(end

[GENERAL] Strange trouble with pg_dump import

the same command line as inside the night script cat my_dump | psql -U postgres mydatabase ... then it's running perfectly ... !? We tried twice this morning to import the database on the same server without any troubles ... !???? Any ideas ? Regards, -- Hervé Piedvache Elma Ingénierie

[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? htt

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 re