Vous n'êtes pas identifié(e).
- Contributions : Récentes | Sans réponse
#176 Re : Général » Récupérer des bases de données postgresql » 20/04/2011 19:36:22
PI : le pbs est résolu après une petite compilation de la 7.3 et un dump.
#177 Re : Réplication » Charge réseau » 18/04/2011 10:45:48
Merci pour votre réactivité !
Effectivement, j'avais zappé que les wal étaient toujours transférés ...
#178 Réplication » Charge réseau » 18/04/2011 10:31:25
- arthurr
- Réponses : 3
Bonjour les éléphants,
J'ai actuellement un serveur en Warm Standby mais avec une bande passante limitée (les serveurs sont sur des sites physiques différents).
je transfère donc des fichiers de 16Mo pas toujours pleins mais compressés.
Est-ce que passer en Hot standby (et donc en streaming) va augmenter ma quantité de données à passer par le réseau ou au contraire est-ce que je vais y gagner ?
Mon ami google n'a pas trouvé de réponse à ma question ... mais j'ai peut être mal cherché !
#179 Re : Général » Fichier postgrèsql.log » 13/04/2011 17:51:30
Un cluster = N databases
Tu peux très bien créer plusieurs bases sur un même cluster :
create database test1;
create database test2;
create database test3;
et identifier les requêtes liées à chaque bases de données dans ton "log_line_prefix" : %d = database name
un log_line_prefix du genre "%t : %d (%u)" va te donner qq chose du genre :
2011-04-13 17:16:08 CEST : test1 (postgres) ...
#180 Re : Général » Fichier postgrèsql.log » 11/04/2011 17:29:53
http://www.linux-kheops.com/doc/man/man … ime.3.html
Pour ma part, je configure mes logs comme ceci :
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql-%d.log'
log_truncate_on_rotation = on
log_rotation_age = 1d
log_rotation_size = 0
Les fichiers se trouvent dans $PGDATA/pg_log/
Ils se nomment : postgresql-<N° du jour du mois en cours>.log
Ils changent automatiquement de nom tous les jours.
J'ai donc 31 fichiers de logs max sur mon serveur.
#181 Re : Général » Fichier postgrèsql.log » 11/04/2011 17:00:25
Bonjour,
Vous devez avoir une version inférieure à la 8.4, non ?
Si vous spécifiez un nom de fichier sans échappements, vous devriez prévoir d'utiliser un utilitaire de rotation des journaux pour éviter le risque de remplir le disque entier. Dans les versions précédentes à 8.4, si aucun échappement % n'était présent, PostgreSQL™ aurait ajouté l'epoch de la date de création du nouveau journal applicatif mais ce n'est plus le cas.
1302527814 = lun. 11 avril 2011 15:16:54 CEST
#182 Re : Migration » Migration PostgreSQL sur Windows de 8.1.4 à 9.0.3 » 24/03/2011 17:10:11
bonjour,
un dump / restore est impératif pour migrer de version : "A dump/restore using pg_dump, or use of pg_upgrade, is required for those wishing to migrate data from any previous release. " (http://docs.postgresql.fr/9.0/release-9-0.html).
bon courage !
#183 Re : Général » Out of memory for the result » 09/03/2011 17:06:09
je ne connais pas assez le code de pgadmin, mais est-ce que votre requete fonctionne avec psql sur le serveur ?
si oui, c'est bien cote pgadmin que ca bloque ! inversement, ramener 9 000 000 d'enregistrements en affichage n'est pas qq chose de courant ...
#184 Re : Général » Arret grosse requete , perte espace libre » 03/03/2011 13:27:39
si la requête nécessite des fichiers temporaires (pour les tri par exemple si work_mem est trop petit), les fichiers se trouvent dans : $PGDATA/base/pgsql_tmp/
mais si tu as arrêté la requête, les fichiers doivent être supprimés
#185 Re : Général » vacuum full est t'il dangereux ? » 03/03/2011 13:01:52
il faut être connecté sur la base à "auditer" (pas sur postgres par exemple)
#186 Re : Général » pg_dump all » 03/03/2011 12:59:51
c'est en gros ce que je fais (pas sur les schémas mais sur les databases).
pour backuper les fichiers de configurations, je fais un liens (ln -s) des fichiers vers le PGDATA et je les récupère (c'est un script perl) :
select * from pg_read_file('postgresql.conf',0,1048576)#187 Re : Général » pg_dump all » 02/03/2011 13:22:43
bonjour,
pour ne recup que les roles : pg_dumpall -g
de mon coté, je fais des "pg_dump -Fc" pour chaque base + un "pg_dumpall -g" pour le cluster
je recup aussi les fichiers postgresql.conf et pg_hba.conf
#188 Re : Général » vacuum full est t'il dangereux ? » 01/03/2011 19:03:53
Pour savoir si autovacuum fait qq chose :
select schemaname,relname,last_vacuum,last_autovacuum,last_analyze,last_autoanalyze
from pg_stat_user_tables ;Il va lancer des autovacuum en se basant sur les paramètres :
autovacuum_vacuum_threshold
autovacuum_analyze_threshold
autovacuum_vacuum_scale_factor
autovacuum_analyze_scale_factor
si la base ne fait pas beaucoup d'insert/update/delete, il ne va pas s’exécuter souvent.
#189 Re : Général » vacuum full est t'il dangereux ? » 01/03/2011 17:50:37
pas "dangereux", mais bloquant ... et il nécessite de REINDEX (également bloquant) les tables touchées par le VACUUM FULL
#190 Re : Général » pg_hba.conf (signe +) » 07/02/2011 13:04:18
pour faire simple :
192.168.1.1/32 => ip exacte
192.168.1.1/24 => 192.168.1.*
192.168.1.1/16 => 192.168.*.*
#191 Re : Général » Petite question sur la table d'activité... » 31/01/2011 17:45:46
bonjour,
<idle> = le client est connecté mais ne fait rien
<idle> in transaction = le client est connecté et dans un bloque de transaction mais ne fait rien
#192 Re : Optimisation » Table heritees » 17/01/2011 18:30:20
Merci pour votre rapidité.
Je vais voir pour faire modifier le code des requêtes qui posent problème.
#193 Re : Optimisation » Table heritees » 17/01/2011 18:18:38
Merci pour votre réponse !
pool=# select tablename , n_distinct from pg_stats where attname='id_source';
tablename | n_distinct
-------------+------------
documents_a | 1
documents_b | 1
documents_c | 3
documents_d | 5
documents_e | 22
documents_f | 24
documents_z | 969
(7 rows)
les id_source sont ventilés dans les tables héritées, ils servent de contraintes de Check :
pool=# \d documents_a
Table "public.documents_a"
Column | Type | Modifiers
---------------+-----------------------------+--------------------------------------------------------
id | integer | not null default nextval('documents_id_seq'::regclass)
id_source | smallint |
...
...
Indexes:
...
...
Check constraints:
"documents_a_id_source_check" CHECK (id_source = 103::smallint)
Inherits: documents
#194 Optimisation » Table heritees » 17/01/2011 17:46:49
- arthurr
- Réponses : 7
Bonjour,
j'ai une base de données d'environ 50 go sous PG 9.0.2 (meme symptômes sur 8.2.4 en production).
j'ai une table "documents" et 9 tables héritées de cette table.
Je fais une requête avec une sous requête (ou une jointure suivant le cas).
Et j'ai trouvé un comportement très étrange suivant que j’utilise IN ou = ...
pool=# explain (analyse true) select id_partition,count(*) from documents where id_source = (select id from sources where name='S201' limit 1) group by id_partition ;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
HashAggregate (cost=2506276.37..2506278.87 rows=200 width=2) (actual time=4635.768..4635.770 rows=2 loops=1)
InitPlan 1 (returns $0)
-> Limit (cost=0.00..3.27 rows=1 width=4) (actual time=0.038..0.038 rows=1 loops=1)
-> Index Scan using idx_sources_name on sources (cost=0.00..3.27 rows=1 width=4) (actual time=0.037..0.037 rows=1 loops=1)
Index Cond: (name = 'S201'::text)
-> Append (cost=0.00..2347056.49 rows=31843323 width=2) (actual time=4635.532..4635.683 rows=194 loops=1)
-> Seq Scan on documents (cost=0.00..18.25 rows=3 width=2) (actual time=0.003..0.003 rows=0 loops=1)
Filter: (id_source = $0)
-> Seq Scan on documents_a documents (cost=0.00..229632.19 rows=10067455 width=2) (actual time=2301.493..2301.493 rows=0 loops=1)
Filter: (id_source = $0)
-> Seq Scan on documents_b documents (cost=0.00..262056.68 rows=11489014 width=2) (actual time=2333.959..2333.959 rows=0 loops=1)
Filter: (id_source = $0)
-> Index Scan using idx_documents_c_id_source_nod on documents_c documents (cost=0.00..203716.13 rows=3658109 width=2) (actual time=0.023..0.023 rows=0 loops=1)
Index Cond: (id_source = $0)
-> Bitmap Heap Scan on documents_d documents (cost=36379.09..310417.26 rows=3066414 width=2) (actual time=0.011..0.011 rows=0 loops=1)
Recheck Cond: (id_source = $0)
-> Bitmap Index Scan on idx_documents_d_id_source_nod (cost=0.00..35612.49 rows=3066414 width=0) (actual time=0.009..0.009 rows=0 loops=1)
Index Cond: (id_source = $0)
-> Bitmap Heap Scan on documents_e documents (cost=26425.31..787901.69 rows=2227231 width=2) (actual time=0.009..0.009 rows=0 loops=1)
Recheck Cond: (id_source = $0)
-> Bitmap Index Scan on idx_documents_e_id_source_nod (cost=0.00..25868.50 rows=2227231 width=0) (actual time=0.008..0.008 rows=0 loops=1)
Index Cond: (id_source = $0)
-> Bitmap Heap Scan on documents_f documents (cost=15275.76..494875.88 rows=1287450 width=2) (actual time=0.008..0.008 rows=0 loops=1)
Recheck Cond: (id_source = $0)
-> Bitmap Index Scan on idx_documents_f_id_source_nod (cost=0.00..14953.90 rows=1287450 width=0) (actual time=0.007..0.007 rows=0 loops=1)
Index Cond: (id_source = $0)
-> Index Scan using idx_documents_z_id_source_nod on documents_z documents (cost=0.00..58438.40 rows=47647 width=2) (actual time=0.022..0.138 rows=194 loops=1)
Index Cond: (id_source = $0)
Total runtime: 4635.979 ms
(29 rows)
Time: 4641,288 ms
pool=# explain (analyse true) select id_partition,count(*) from documents where id_source IN (select id from sources where name='S201' limit 1) group by id_partition ;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
HashAggregate (cost=2933423.78..2933426.28 rows=200 width=2) (actual time=0.922..0.925 rows=2 loops=1)
-> Nested Loop (cost=3.28..2929075.49 rows=869658 width=2) (actual time=0.202..0.756 rows=194 loops=1)
Join Filter: (public.documents.id_source = sources.id)
-> HashAggregate (cost=3.28..3.29 rows=1 width=4) (actual time=0.051..0.052 rows=1 loops=1)
-> Limit (cost=0.00..3.27 rows=1 width=4) (actual time=0.042..0.042 rows=1 loops=1)
-> Index Scan using idx_sources_name on sources (cost=0.00..3.27 rows=1 width=4) (actual time=0.040..0.040 rows=1 loops=1)
Index Cond: (name = 'S201'::text)
-> Append (cost=0.00..2531022.45 rows=31843980 width=4) (actual time=0.133..0.525 rows=194 loops=1)
-> Seq Scan on documents (cost=0.00..16.60 rows=660 width=4) (actual time=0.001..0.001 rows=0 loops=1)
-> Bitmap Heap Scan on documents_a documents (cost=119432.44..323895.99 rows=10067455 width=4) (actual time=0.020..0.020 rows=0 loops=1)
Recheck Cond: (public.documents.id_source = sources.id)
-> Bitmap Index Scan on idx_documents_a_id_source_nod (cost=0.00..116915.58 rows=10067455 width=0) (actual time=0.017..0.017 rows=0 loops=1)
Index Cond: (public.documents.id_source = sources.id)
-> Bitmap Heap Scan on documents_b documents (cost=136296.58..369630.72 rows=11489014 width=4) (actual time=0.014..0.014 rows=0 loops=1)
Recheck Cond: (public.documents.id_source = sources.id)
-> Bitmap Index Scan on idx_documents_b_id_source_nod (cost=0.00..133424.33 rows=11489014 width=0) (actual time=0.012..0.012 rows=0 loops=1)
Index Cond: (public.documents.id_source = sources.id)
-> Bitmap Heap Scan on documents_c documents (cost=43397.55..202298.64 rows=3658109 width=4) (actual time=0.015..0.015 rows=0 loops=1)
Recheck Cond: (public.documents.id_source = sources.id)
-> Bitmap Index Scan on idx_documents_c_id_source_nod (cost=0.00..42483.02 rows=3658109 width=0) (actual time=0.014..0.014 rows=0 loops=1)
Index Cond: (public.documents.id_source = sources.id)
-> Bitmap Heap Scan on documents_d documents (cost=36379.09..302751.23 rows=3066414 width=4) (actual time=0.013..0.013 rows=0 loops=1)
Recheck Cond: (public.documents.id_source = sources.id)
-> Bitmap Index Scan on idx_documents_d_id_source_nod (cost=0.00..35612.49 rows=3066414 width=0) (actual time=0.012..0.012 rows=0 loops=1)
Index Cond: (public.documents.id_source = sources.id)
-> Bitmap Heap Scan on documents_e documents (cost=26425.31..782333.62 rows=2227231 width=4) (actual time=0.016..0.016 rows=0 loops=1)
Recheck Cond: (public.documents.id_source = sources.id)
-> Bitmap Index Scan on idx_documents_e_id_source_nod (cost=0.00..25868.50 rows=2227231 width=0) (actual time=0.016..0.016 rows=0 loops=1)
Index Cond: (public.documents.id_source = sources.id)
-> Bitmap Heap Scan on documents_f documents (cost=15275.76..491657.26 rows=1287450 width=4) (actual time=0.015..0.015 rows=0 loops=1)
Recheck Cond: (public.documents.id_source = sources.id)
-> Bitmap Index Scan on idx_documents_f_id_source_nod (cost=0.00..14953.90 rows=1287450 width=0) (actual time=0.015..0.015 rows=0 loops=1)
Index Cond: (public.documents.id_source = sources.id)
-> Index Scan using idx_documents_z_id_source_nod on documents_z documents (cost=0.00..58438.40 rows=47647 width=4) (actual time=0.034..0.335 rows=194 loops=1)
Index Cond: (public.documents.id_source = sources.id)
Total runtime: 1.160 ms
(36 rows)
Time: 6,888 ms
Le 2eme exemple se comporte exactement comme une jointure (select d.id_partition,count(*) from documents d join sources s on (d.id_source =s.id) where s.name='S201' group by d.id_partition ;)
On passe de 7 ms a 4.5 secondes ...
Vous avez une explications, une piste ?
Merci
#195 Re : Général » Ajouter une ligne total en fin de select » 14/01/2011 13:04:54
2 : 2eme colonne retournée par le select
Exemple : select toto, titi, tata from foo order by 2 ==> va faire un order sur la colonne titi.
#196 Re : Site PostgreSQL.fr » recherche dans la doc 9.0 » 06/01/2011 15:52:21
je vais continuer a parler tout seul :)
donc ... ca ne fonctionne pas sur plusieurs debian avec iceweasel (firefox) en version 3.5.16.
j'ai reussi a le faire fonctionner en collant le fichier suivant directement dans .mozilla/firefox/01kwi6zj.default/searchplugins/ :
<SearchPlugin xmlns="http://www.mozilla.org/2006/browser/search/" xmlns:os="http://a9.com/-/spec/opensearch/1.1/">
<os:ShortName>PgFr Docs 9.0.x</os:ShortName>
<os:Description>Recherche documentation PostgreSQL</os:Description>
<os:InputEncoding>UTF-8</os:InputEncoding>
<os:Image width="16" height="16">data:image/x-icon;base64,AAABAAIAEBAAAAAAAABoBQAAJgAAABAQAAAAAAAAaAQAAI4FAAAoAAAAEAAAACAAAAABAAgAAAAAAAABAAAAAAAAAAAAAAABAAAAAQAAAAAAAH9pRQCIYS4AjmIvAItnLwCOZi8Ai2guAJFlLwCDYTIAhWE1AINkNACGZzYAiGIyAI1iMgCKZDIAjmQxAIliNQCMYzUAjmQ2AIFhOACEYjkAhWQ5AIpjOQCKZTkAh2k/AIloOACPaDoAiWg9AJBiMgCRZTEAlGUwAJFjNACQaD8AiWVBAIltRgCKa0gAinBLAI1xSACZckoAiHZXAJh2VgCWfFkAmH1YAJ59XQCcgF0Ao4FeAJKFYACcg2EAooRhAKaIYQChjmsAoI5uAKqWbgChkHUApZR3AKuXdQCtlnUAsp19ALShfACjlYQArqGKAK2liwCso48AuqmGAL2phQC2pIsAuKaNALSqjwC9qYwAtKWTALerkQC4qpEAu6yRAL6vlQC9rZoAv7CSALiwlQC8spUAwKyMAMGvkADEsZEAxLWTAMC0lQDFt5QAyLSXAMK1mADEuJsAxbegAMe/pwDHuqgAx76pAMi/rwDJwLQAycW2AMvFugDPybwA08m7ANTMuwDKxsEA08/CANXPwADc1MMA2dHHAN/c1ADh2c4A4d7XAOXf1QDm4dcA4+HZAO7r5gDu7uwA8e3nAPHu6QDz8OoA9PLuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAYyMpawAAAAAAAAAAAAAAADYRHy8AAAAAAAAAAAAAAAAwEQMmAAAAAAAAAAAAAAAALR8DIAAAAAAAAABlAGo9XSsfBhZvAAAAAABBEV8AbD0oHwMRWjtiAABnFREiX0FNEREfEUNuAAAAQh8RRCIKURERHyBaXgAAACwfEVEKETkWHx80J0ZqAHIRER9OFhE4IR8VUSQ6MgBjER8RUQE4TRERFk0uQBEAShEfH05RVjkRHxFEWlYRZUYfERE4KwMRFhEfETYwH1ZqFR8RAVEKERERESRGERVfAEYWCgpFQxUKFTJRChVKAAAAcnIAAABybQAAXVtyAAD/DwAA/w8AAP8PAAD/DwAA6AcAAMQBAACAAwAAgAMAAIABAAAAAQAAAAEAAAAAAAAAAAAAAAAAAIABAADOYwAAKAAAABAAAAAgAAAAAQAgAAAAAABABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA0Mm44oprSP+WfFn/29PFrQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA/v7+BqOSdPiOYzL/kGYx/5yDYf/29fRCAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAPj49i+ihGH/jWUw/4tnL/+Zckr/8/LtWAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA9vb1Mu/u7Gfn5+Ruo4Fe/5NmL/+LZy//kGg///Tv6n4AAAAAAAAAAAAAAAAAAAAAAAAAAPPu6lvKvrCz7+7tTtrWzsyqoYz4yMS0+J59Xf+UZjH/i2gu/4pjOf/q5dyq/PfwUf39+yIAAAAAAAAAAPX08kiynoTviGIy/8W4pcDy8e4/39zT2a2li/+Ydlb/j2Yz/45nL/+IYjP/x7qo/5+QfvK7trDG7uzpS////wzY1MrMhmQ5/5BmMP+Kbkf/0ci27Kmbg++4sJX/kGM1/45kNv+TZDL/j2Uy/7Wqj//j4+CXAAAAAAAAAADw7+9YuKaN/5BlMP+OZTH/vamM/4ltRv+GYjf/wrWY/45iL/+LZDP/lWUw/49oOv/Hvqn/ysS5+Pj29DIAAAAA9fPvYZyAXf+RZS//j2Uw/8Swk/+EYjb/i2M0/7Gdfv+LZDr/k2Qx/5FjNP+qlm7/iHZX/7iqkf/Zz8GqAAAAAOvm3ZqJYzb/kWUv/49lMP/ArIz/imY5/45jMv+slXf/iWVB/5BlMf+CYzn/xLWT/41xSP+0oXz/nYpp9f7+/RzKxLXPjGIz/5JlMv+OZS//xLKQ/39pRf+rl3X/vbOU/4xjNP+TYzT/iWg9/7yyl/+ShWD/vamF/4hiNf/s6eB+va2a/5BmMf+SZTL/j2Yw/8GvkP+/sJL/xLib/7Oeff+OZDD/j2Qy/4tkMv+6qYb/x7+n/8i0l/+QYjH/0cWvvb6vlf+TZDL/jGUz/4plMv+ul3T/mH1Y/4hhLv+NYzb/j2Uz/4tlM/+UZDH/jWQx/6GQdf+miGH/jWQz/76ulOLZ0MLJgGA4/5BjM/+QYzP/h2k//8C0lf+FYDX/jWQz/4xkM/+QZTL/j2Uz/4pwS/+7rJH/hmI1/4lhNf/Fva3P9PLxWLWpjviJaDj/g2Iz/4RiOf+zpJL7rqSH7IZnNv+DYTH/hWQ4/6GOa//Ft5T/g2Q0/4VmOv+4ppHp+/v4MgAAAAD6+voW7urhkObh2Y3u6+Vx+/n2Nfj39hzr5tyU4tzSjfHv5HT08ellwLan2cO5qOnq5t6B/v7+EwAAAAD/DwAA/gcAAP4HAAD4BwAAwAEAAIAAAAAAAwAAAAEAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAQAA</os:Image>
<SearchForm>http://docs.postgresql.fr</SearchForm>
<os:Url type="text/html" method="GET" template="http://docs.postgresqlfr.org/search.php">
<os:Param name="q" value="{searchTerms}"/>
<os:Param name="v" value="900"/>
</os:Url>
</SearchPlugin>
#197 Re : Site PostgreSQL.fr » recherche dans la doc 9.0 » 06/01/2011 14:55:25
j'ai testé sur 2 autres postes : ca marche !
donc c'est mon ami iceweasel qui a un probleme ... désolé pour le bruit !
#198 Re : Site PostgreSQL.fr » recherche dans la doc 9.0 » 06/01/2011 11:55:21
merci pour votre reactivite !
mais ...
ASSERT: *** Search: _installLocation: engine has no file!
Stack Trace:
0:ENSURE_WARN(null,_installLocation: engine has no file!,2147500037)
1:()
2:()
3:()
4:SRCH_ENG_parseURL([object Element])
5:SRCH_ENG_parseAsOS()
6:SRCH_ENG_parseAsMoz()
7:SRCH_ENG_initFromData()
8:SRCH_ENG_onLoad(60,63,120,109,108,32,118,101,114,115,105,111,110,61,34,49,46,48,34,32,101,110,99,111,100,105,110,103,61,34,85,84,70,45,56,34,63,62,13,10,60,83,101,97,114,99,104,80,108,117,103,105,110,32,120,109,108,110,115,61,34,104,116,116,112,58,47,47,119,119,119,46,109,111,122,105,108,108,97,46,111,114,103,47,50,48,48,54,47,98,114,111,119,115,101,114,47,115,101,97,114,99,104,47,34,62,13,10,60,83,104,111,114,116,78,97,109,101,62,80,103,70,114,32,68,111,99,115,32,57,46,48,46,120,60,47,83,104,111,114,116,78,97,109,101,62,13,10,60,68,101,115,99,114,105,112,116,105,111,110,62,82,101,99,104,101,114,99,104,101,32,100,111,99,117,109,101,110,116,97,116,105,111,110,32,80,111,115,116,103,114,101,83,81,76,60,47,68,101,115,99,114,105,112,116,105,111,110,62,13,10,60,73,110,112,117,116,69,110,99,111,100,105,110,103,62,85,84,70,45,56,60,47,73,110,112,117,116,69,110,99,111,100,105,110,103,62,13,10,60,73,109,97,103,101,32,119,105,100,116,104,61,34,49,54,34,32,104,101,105,103,104,116,61,34,49,54,34,62,100,97,116,97,58,105,109,97,103,101,47,120,45,105,99,111,110,59,98,97,115,101,54,52,44,82,48,108,71,79,68,108,104,69,65,65,81,65,80,102,76,65,65,65,84,86,105,107,119,100,65,56,83,110,120,85,102,103,65,115,87,112,65,65,105,108,104,111,108,106,120,119,52,106,66,99,55,107,119,65,108,118,81,81,50,115,82,77,115,111,66,85,113,113,104,77,122,117,104,89,47,118,120,119,52,116,83,103,109,105,121,77,49,109,83,85,122,116,105,81,54,115,84,69,51,115,81,52,113,121,120,77,120,120,82,111,121,120,105,65,117,120,82,49,67,116,66,120,74,115,66,120,97,115,83,74,117,117,84,70,103,117,66,116,101,48,82,108,102,50,120,86,99,57,104,57,87,57,120,86,106,122,120,86,114,48,103,100,106,54,66,82,104,52,82,49,111,53,121,66,99,121,105,90,98,121,121,100,84,49,105,57,98,50,68,100,98,49,105,70,89,54,67,74,103,50,86,112,111,114,49,100,122,118,69,74,117,50,48,90,48,121,105,50,51,81,68,121,49,82,69,105,50,79,85,121,48,79,49,87,122,79,86,67,52,80,85,43,116,86,85,101,53,83,107,50,120,81,85,50,122,82,85,79,52,85,69,50,49,85,108,97,50,83,109,75,69,113,87,87,70,50,72,121,80,120,50,43,97,54,88,54,101,54,88,113,107,49,109,43,115,55,56,115,85,68,115,52,85,71,100,69,81,66,57,89,102,68,100,119,97,65,78,69,102,72,100,48,89,69,115,99,106,65,77,52,109,65,77,48,113,65,78,73,111,68,57,73,107,71,100,115,108,71,115,119,117,73,116,89,103,76,52,97,80,48,73,109,80,50,89,71,90,51,54,79,112,122,97,113,50,119,113,47,83,43,114,122,88,47,55,47,101,56,77,114,83,49,77,76,79,47,115,84,98,52,56,114,84,56,115,110,88,47,56,51,99,56,57,80,90,43,99,114,113,43,99,72,49,47,57,68,108,47,57,76,110,47,57,51,114,47,57,102,121,47,43,72,102,55,80,47,52,50,101,68,109,47,79,55,117,47,43,84,50,57,117,88,50,47,101,84,50,47,43,102,52,47,43,102,53,47,43,106,47,57,117,47,47,56,43,51,47,57,117,55,47,57,117,114,53,47,43,106,47,47,43,110,47,47,43,118,47,47,117,51,47,47,43,55,47,47,101,55,47,47,43,47,47,47,47,98,54,54,47,84,47,54,118,88,47,54,47,102,47,55,102,47,48,55,102,106,47,52,102,118,47,52,80,106,47,53,118,47,52,53,118,55,47,52,47,114,43,55,47,51,47,54,102,68,119,43,80,102,120,47,47,68,47,57,47,88,47,56,102,84,47,56,47,102,47,56,102,102,47,56,47,68,47,47,47,72,47,47,47,76,56,47,102,76,47,47,47,80,47,47,47,88,55,47,47,98,54,47,102,102,47,43,47,84,47,47,47,98,57,47,47,102,47,47,47,118,49,57,47,47,119,57,118,47,48,57,80,47,50,57,118,47,120,43,102,47,121,47,47,47,122,47,47,47,49,43,118,47,49,47,47,47,50,47,47,47,51,47,47,106,55,57,80,47,53,56,47,122,47,56,47,122,57,57,47,122,47,57,118,55,47,57,80,55,47,57,118,110,55,47,47,118,54,47,47,106,57,47,47,110,57,47,47,106,47,47,47,110,47,47,47,118,47,47,118,118,47,47,47,47,52,43,118,47,53,43,47,47,54,43,80,47,52,47,47,47,54,47,80,47,54,47,118,47,54,47,47,47,55,47,47,47,57,43,80,47,56,43,118,47,57,43,118,55,47,43,80,122,47,47,47,47,56,47,102,47,57,47,102,55,57,47,47,47,56,47,47,47,57,47,47,55,47,47,47,47,47,47,47,47,47,47,119,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,67,72,53,66,65,69,65,65,77,115,65,76,65,65,65,65,65,65,81,65,66,65,65,65,65,106,47,65,69,110,52,111,73,70,106,66,119,56,98,79,110,114,77,117,74,71,106,104,111,119,90,77,49,84,56,85,100,89,74,85,90,53,90,99,78,82,89,87,106,83,114,86,75,53,81,85,48,68,77,109,116,85,110,122,82,65,88,69,121,52,111,54,70,67,69,121,54,78,68,84,107,81,73,113,49,77,109,82,103,77,48,101,90,84,108,67,88,77,103,81,74,116,82,83,69,52,103,109,103,85,107,119,104,49,69,105,90,84,78,85,105,97,109,121,54,78,85,85,69,120,99,117,111,74,103,68,67,100,68,106,81,103,57,75,103,86,76,50,83,78,70,84,49,104,119,69,118,75,103,108,76,66,87,117,105,120,90,43,106,83,114,108,83,66,100,82,108,76,48,52,98,66,66,107,84,66,100,112,90,84,112,73,113,87,115,70,97,66,99,84,69,114,48,81,97,69,104,108,54,100,87,108,115,119,75,87,54,112,111,68,82,85,80,108,109,65,85,81,75,87,77,107,84,74,76,99,55,54,81,77,81,78,71,85,90,77,87,103,73,103,107,67,70,74,110,108,113,53,87,88,105,103,119,107,70,67,108,86,90,81,81,121,117,82,103,69,76,65,108,107,55,74,66,121,109,67,90,71,89,65,70,48,90,69,80,114,81,105,120,103,85,68,65,105,104,120,86,100,80,112,111,65,90,65,70,85,90,73,82,102,84,104,120,103,118,80,67,119,65,73,76,68,105,112,107,43,79,70,71,50,90,73,86,111,120,65,112,69,82,116,80,102,118,119,108,118,90,43,107,81,70,122,80,118,118,48,77,74,81,69,66,65,68,115,61,60,47,73,109,97,103,101,62,13,10,60,85,114,108,32,116,121,112,101,61,34,116,101,120,116,47,104,116,109,108,34,32,109,101,116,104,111,100,61,34,71,69,84,34,32,116,101,109,112,108,97,116,101,61,34,104,116,116,112,58,47,47,100,111,99,115,46,112,111,115,116,103,114,101,115,113,108,102,114,46,111,114,103,47,115,101,97,114,99,104,46,112,104,112,34,62,13,10,32,32,60,80,97,114,97,109,32,110,97,109,101,61,34,113,34,32,118,97,108,117,101,61,34,123,115,101,97,114,99,104,84,101,114,109,115,125,34,47,62,13,10,32,32,60,80,97,114,97,109,32,110,97,109,101,61,34,118,34,32,118,97,108,117,101,61,34,57,48,48,34,47,62,13,10,32,32,60,33,45,45,32,68,121,110,97,109,105,99,32,112,97,114,97,109,101,116,101,114,115,32,45,45,62,13,10,32,32,60,80,97,114,97,109,32,110,97,109,101,61,34,114,108,115,34,32,118,97,108,117,101,61,34,123,109,111,122,58,100,105,115,116,114,105,98,117,116,105,111,110,73,68,125,58,123,109,111,122,58,108,111,99,97,108,101,125,58,123,109,111,122,58,111,102,102,105,99,105,97,108,125,34,47,62,13,10,32,32,60,77,111,122,80,97,114,97,109,32,110,97,109,101,61,34,99,108,105,101,110,116,34,32,99,111,110,100,105,116,105,111,110,61,34,100,101,102,97,117,108,116,69,110,103,105,110,101,34,32,116,114,117,101,86,97,108,117,101,61,34,102,105,114,101,102,111,120,45,97,34,32,102,97,108,115,101,86,97,108,117,101,61,34,102,105,114,101,102,111,120,34,47,62,13,10,60,47,85,114,108,62,13,10,60,83,101,97,114,99,104,70,111,114,109,62,104,116,116,112,58,47,47,100,111,99,115,46,112,111,115,116,103,114,101,115,113,108,102,114,46,111,114,103,60,47,83,101,97,114,99,104,70,111,114,109,62,13,10,60,47,83,101,97,114,99,104,80,108,117,103,105,110,62,13,10,[object Object])
9:SRCH_loadStopR([xpconnect wrapped (nsISupports, nsIChannel, nsIRequest, nsIHttpChannel)],null,0)
#199 Site PostgreSQL.fr » recherche dans la doc 9.0 » 06/01/2011 11:36:30
- arthurr
- Réponses : 4
Bonjour,
Le plugin firefox de recherche dans la doc 9.0 ne fonctionne pas.
j'utilises avec grand plaisir ce plugin pour la 8.4 ...
Merci pour votre travail !
Ps : le message d'erreur :
Iceweasel could not download the search plugin from:
http://docs.postgresql.fr/addon/pgfr-docs90-ff.xml
#200 Re : Optimisation » tables partitionnées - Perf avant ANALYSE » 30/12/2010 09:59:57
merci de votre interet !
en resume :
avant vacuum analyze : 500 ms
apres vacuum analyze : 5000 ms