Re: [GENERAL] recovery from out of disk space

2010-10-20 Thread Cédric Villemain
defined conversions > pg_dump: reading user-defined tables > pg_dump: SQL command failed > pg_dump: Error message from server: ERROR:  permission denied for relation > totalcount > pg_dump: The command was: LOCK TABLE public.totalcount IN ACCESS SHARE MODE > pg_dump: *** aborted

Re: [GENERAL] PHP PDO->bindValue() vs row execute speed difference

2010-11-01 Thread Cédric Villemain
execution plan. > Am I correct in my thoughts ? Yes. But usualy for a PK there is no trouble and planner should use index. you can give a try with psql 'prepare foo ... ; explain execute foo(100); ' vs 'explain select where id = 100' > Is there anything I can

Re: [GENERAL] Why so many xlogs?

2010-11-01 Thread Cédric Villemain
gt; > it virtually never goes below 215, and it spikes to 270-300. > > In here: http://www.depesz.com/various/bad-wal.log.gz is log from my test > script since 20th of october. > > Any ideas why number of segments is higher than expected? > > Just so that I am clear: I d

Re: [GENERAL] Why so many xlogs?

2010-11-01 Thread Cédric Villemain
2010/11/1 hubert depesz lubaczewski : > On Mon, Nov 01, 2010 at 07:22:50PM +0100, Cédric Villemain wrote: >> > as I understand, max number of xlog files in pg_xlog should be ( 1 + 2 * >> > checkpoint_segments ). >> (2 + checkpoint_completion_target) * checkpoint_segment

Re: [GENERAL] Why so many xlogs?

2010-11-01 Thread Cédric Villemain
_hdl / gg:6749007 > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Cédric Villemain               2ndQuadrant http://2ndQuadrant.fr/     PostgreSQL : Expertise

Re: [GENERAL] Why so many xlogs?

2010-11-01 Thread Cédric Villemain
2010/11/1 hubert depesz lubaczewski : > On Mon, Nov 01, 2010 at 08:13:49PM +0100, Cédric Villemain wrote: >> 2010/11/1 hubert depesz lubaczewski : >> > On Mon, Nov 01, 2010 at 07:22:50PM +0100, Cédric Villemain wrote: >> >> > as I understand, max number of xlog f

Re: [GENERAL] migrate from 8.1 to 9.0

2010-11-08 Thread Cédric Villemain
and what may impact your application. -- Cédric Villemain               2ndQuadrant http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support -- 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] migrate from 8.1 to 9.0

2010-11-08 Thread Cédric Villemain
al mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Cédric Villemain               2ndQuadrant http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general

Re: [GENERAL] Why facebook used mysql ?

2010-11-09 Thread Cédric Villemain
hub.com/facebook/flashcache/ A good tool by the way. It is the only place where I like to see SSD disk. (not at facebook, but with 'volatile' data) > >                        regards, tom lane > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] Looking for auto starting procedures

2010-12-04 Thread Cédric Villemain
be you'll have better answers if you define your objectives. [1] http://wiki.postgresql.org/wiki/PGQ_Tutorial [2] http://www.postgresql.org/docs/current/interactive/sql-notify.html [3] http://www.postgresql.org/docs/current/interactive/sql-createrole.html -- Cédric Villemain               2ndQuad

Re: [GENERAL] Postgresql as a dictionary coder backend?

2011-01-25 Thread Cédric Villemain
PostgreSQL should work for that, yes. You'll have to compensate the size with good hardware and good SQL (and probably some optimization like using arrays) -- Cédric Villemain               2ndQuadrant http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-ge

Re: [GENERAL] [HACKERS] PLJava for Postgres 9.2.

2013-05-17 Thread Cédric Villemain
xs.mk: No such > > file or directory > > > > What do I need to do to obtain the required files, and does anybody > > know why, given Postgres 9.2 is out some time, and 9.3 is in beta, why > > no prebuild binary PLJavas exist for 9.2? > > Because nobody

Re: [GENERAL] pasting into psql garbles text

2009-06-29 Thread Cédric Villemain
g this is a readline problem. Has anybody else > noticed this? Is there a workaround? > > merlin -- Cédric Villemain Administrateur de Base de Données Cel: +33 (0)6 74 15 56 53 http://dalibo.com - http://dalibo.org signature.asc Description: This is a digitally signed message part.

Re: [GENERAL] Installing postgresql on Debian Lenny-->my /etc/apt/sources.list.

2009-09-14 Thread Cédric Villemain
javadesktop.org/lg3d/debian stable contrib > deb http://ftp.bononia.it/debian lenny main contrib non-free > deb http://ftp.bononia.it/debian lenny-proposed-updates main contrib > non-free > > deb http://ftp.debian.org/debian/ lenny main contrib non-free > > === > On Fri, 11

Re: [GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-24 Thread Cédric Villemain
ou could issue 'kicks' for each laptop sync when you know for sure > that a laptop has got an active network connection to your master. > It's also pretty efficient with updates, only copying the current row > (that's changed) a single time, rather than multiple times

Re: [GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-25 Thread Cédric Villemain
Le vendredi 25 septembre 2009, Selena Deckelmann a écrit : > On Thu, Sep 24, 2009 at 8:09 AM, Cédric Villemain > > wrote: > > Le jeudi 24 septembre 2009, Selena Deckelmann a écrit : > >> Hi! > >> > >> On Wed, Sep 23, 2009 at 10:11 AM, Bryan Montgo

Re: [GENERAL] full text + snowball + ispell?

2009-10-12 Thread Cédric Villemain
t; > Dominic Bevacqua > Director > BPM Logic Ltd. > http://www.bpmlogic.com > -- Cédric Villemain Administrateur de Base de Données Cel: +33 (0)6 74 15 56 53 http://dalibo.com - http://dalibo.org signature.asc Description: This is a digitally signed message part.

Re: [GENERAL] [ANNOUNCE] [pgeu-general] PGDay.EU 2009 - approaching fast!

2009-10-26 Thread Cédric Villemain
details. > > I gather from another Irish attendee that this one is booked out now. Sure ? You *have to* ask for the ParisTech rooms (there were still 10 rooms available on friday, only for Paristech) Else the hotel is full. > > Ray. > -- Cédric Villemain Administrateur de Base de

Re: [GENERAL] Using column aliasses in the same query

2011-04-17 Thread Cédric Villemain
stash the hairy logic >> there. >> >> regards, Leif > > True, but that is essentially the same thing as the example query I gave. > There are plenty of cases where this approach is not workable. select bar.*, b-c from (select i,i,i from foo ) as bar(a,b,c) w

Re: [GENERAL] Extract (Recover) data from a cluster built on a different architecture (ARM).

2011-04-24 Thread Cédric Villemain
hitecture or is my data toast unless I can lay my hands > on an ARM box? I don't think it exists one > > Thanks so much for your time. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.po

Re: [GENERAL] Partitioning an existing table

2011-04-25 Thread Cédric Villemain
lel (depend of your IO system and number of tables) > > Thanks > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Cédric Villemain               2ndQ

Re: [GENERAL] [HACKERS] PostgreSQL Core Team

2011-04-27 Thread Cédric Villemain
ngratulations Magnus ! > > Regards, Dave. > > -- > Dave Page > PostgreSQL Core Team > http://www.postgresql.org/ > > -- > Sent via pgsql-hackers mailing list (pgsql-hack...@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/m

Re: [GENERAL] [ADMIN] Can we Flush the Postgres Shared Memory ?

2011-05-03 Thread Cédric Villemain
ven then they might not be read from disk, because they could > sit in the o/s cache).  to force a read from the drive you'd have to > reboot the server, or at least shut it down and use a lot of memory > for some other purpose. with linux, you can : "echo 3 > /proc/sys/vm/drop_cache

Re: [GENERAL] [ADMIN] Can we Flush the Postgres Shared Memory ?

2011-05-03 Thread Cédric Villemain
2011/5/3 Merlin Moncure : > On Tue, May 3, 2011 at 8:55 AM, Cédric Villemain > wrote: >> 2011/5/3 Merlin Moncure : >>> >>> no it will not, or at least there is no guarantee it will be.  the >>> only way to reset the buffers in that sense is to restart the

Re: [GENERAL] undead index

2011-05-05 Thread Cédric Villemain
2011/5/4 Jens Wilke : > > This index was deleted several weeks ago. > [...] > > after pg_dumpall|psql from 8.4 to 9.0 the undead index revived on the target > DB: I understood that you droped an index and when you dump/restore you get your index again. Did I miss something ? --

Re: [GENERAL] undead index

2011-05-06 Thread Cédric Villemain
2011/5/6 Jens Wilke : > On Thursday 05 May 2011 16:46:05 Cédric Villemain wrote: > >> I understood that you droped an index and when you dump/restore you >> get your index again. > > Yes, that's it, after the pg_upgrade error, i removed the target data > directory

Re: [GENERAL] track functions call

2011-05-10 Thread Cédric Villemain
98.n5.nabble.com/track-functions-call-tp4384220p4384220.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgres

Re: [GENERAL] track functions call

2011-05-11 Thread Cédric Villemain
his message in context: > http://postgresql.1045698.n5.nabble.com/track-functions-call-tp4384220p4385392.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make c

Re: [GENERAL] invalid byte sequence for encoding "UTF8": 0xf1612220

2011-05-12 Thread Cédric Villemain
; > -- > Craig Ringer > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Cédric Villemain               2ndQuadrant http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support -- 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] Role for CSV import

2011-05-15 Thread Cédric Villemain
er may be useful: http://pgloader.projects.postgresql.org > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Cédric Villemain               2ndQuadrant http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support -- 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] Memcached for Database server

2011-05-17 Thread Cédric Villemain
as to be > aware of that. > > How do you handle statements that rely on current_timestamp, random(), etc? > What about if their reliance is via a function? Is that just an understood > limitation of the cache, that it'll cache even queries that don't really > make sense to cac

Re: [GENERAL] max_connections proposal

2011-05-27 Thread Cédric Villemain
"Be aware that a too large value can be counter-productive and a connection pooler can be more appropriate." No scale... I am really happy to face more and more servers where 'top' truncate the list of processors... We will have to scale and not make that limitation a feature, im

Re: [GENERAL] Shared Buffer Size

2011-05-30 Thread Cédric Villemain
mem is not better... Will it be hard to isolate the case and make it public ? In the long term it might be a good test to add to a performance farm if it is not based on a non-optimum linux configuration (I mean if the issue *need* the work_mem to be reduced to be fixed). > > Toby > > -

Re: [GENERAL] Shared Buffer Size

2011-05-31 Thread Cédric Villemain
2011/5/31 Toby Corkindale : > On 30/05/11 20:41, Cédric Villemain wrote: >> >> 2011/5/30 Toby Corkindale: >>> >>> On 28/05/11 18:42, Carl von Clausewitz wrote: >>>> >>>> a few months ago, when I installed my first PostgreSQL, I have had the

Re: [GENERAL] Shared Buffer Size

2011-05-31 Thread Cédric Villemain
size exceeds the shared_buffer limit, a victim dirty >>>> page will be written back to the disk. >>>> >>>> However, I have read on many links that PostgreSQL depends on the OS for >>>> caching. (http://www.varlena.com/GeneralBits/Tidbits/perf.html#shbuf) >>>> >>>> So my question is, the actual limit of the shared buffer will be defined >>>> by OS or the shared_buffer parameter in the postgres.conf to figure whether >>>> a victim dirty page needs to be selected for disk write or not? >>>> >>>> Thanks! >>> >> > > -- Cédric Villemain               2ndQuadrant http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support -- 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] PostgreSQL 8.4.8 bringing my website down every evening

2011-06-16 Thread Cédric Villemain
al/pg_auth > > pool_mode = session > you probably want to use transaction mode here, instead of session. -- Cédric Villemain               2ndQuadrant http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgres

Re: [GENERAL] PostgreSQL 8.4.8 bringing my website down every evening

2011-06-19 Thread Cédric Villemain
ried that already. > > Thank you > Alex > > P.S. Here again my specs: > > pgbouncer-1.3.4-1.rhel5 > postgresql-libs-8.4.8-1PGDG.rhel5 > compat-postgresql-libs-4-1PGDG.rhel5 > postgresql-8.4.8-1PGDG.rhel5 > postgresql-server-8.4.8-1PGDG.rhel5 > postgresql-devel-8.4

Re: [GENERAL] PostgreSQL 8.4.8 bringing my website down every evening

2011-06-19 Thread Cédric Villemain
2011/6/19 Alexander Farber : > Hello Cedric and others, > > On Sun, Jun 19, 2011 at 9:56 PM, Cédric Villemain > wrote: >> 2011/6/19 Alexander Farber : >>> [pgbouncer] >>> logfile = /var/log/pgbouncer.log >>> pidfile = /var/run/pgbouncer/pgbouncer.p

Re: [GENERAL] PostgreSQL 8.4.8 bringing my website down every evening

2011-06-21 Thread Cédric Villemain
IT. A BEGIN > followed by a BEGIN would cause an "already in transaction" error which > would cause the "transaction is aborted" problem. this is not correct cedric=# begin ; BEGIN cedric=# begin ; ATTENTION: une transaction est déjà en cours BEGIN cedric=# select 1; ?column

Re: [GENERAL] pgsql error

2011-07-25 Thread Cédric Villemain
uld not write block 614 of 394198/412175 > > DETAIL: Multiple failures --- write error may be permanent. Maybe you have disk full ? > > ERROR: xlog flush request 0/34D53680 is not satisfied --- flushed only to > 0/34CD1EB0 > > > > Is there anyone who has seen this and can help

Re: [GENERAL] Problem with planner

2011-08-09 Thread Cédric Villemain
#x27;active'::text) >               ->  Bitmap Index Scan on objects_ending_tsz_idx   > (cost=0.00..953722.77 rows=24986738 width=0) >                     Index Cond: (ending_tsz <= $0) > (10 rows) > > running analyze objects 2 times in a row fixed the issue, but hour later &

Re: [GENERAL] Problem with planner

2011-08-10 Thread Cédric Villemain
g > like this) that some newer version has more logic to try harder to use > best index? I wondered if it is the same logic to choose between bitmap and indexscan in both 8.3 and HEAD. It looks like it is (except that now you can put the not-wanted index on another tablepsace and increase the

Re: [GENERAL] How to find freak UTF-8 character?

2011-10-02 Thread Cédric Villemain
, Leif > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Cédric Villemain +33 (0)6 20 30 22 52 http://2ndQuadrant.fr/ PostgreSQL: Support 24x7 - Développement,

Re: [GENERAL] Never-idle autovacuum, and does (auto)vacuuming fill the OS cache ?

2011-10-07 Thread Cédric Villemain
? If not, that might be a low-hanging fruit > to improve postgres performance. Not a direct answer but some items after reading the thread: * 8.4 come with visibility map and it is nice to reduce IO usage (without trouble anymore with FSM_ GUC) * postgresql cache got its own logic, DB oriented.

Re: [GENERAL] many sql file and one transaction

2011-10-18 Thread Cédric Villemain
t;> \i  / .../ module_etc.sql >> COMMIT; >> >> >> Is there a way to do that  using psql command  shell script. >> >> >> I.E. >> >> I want to run the following  in one transaction, >> >> psql  -f  module1.sql >> >> p

Re: [GENERAL] help understanding the bitmap heap scan costs

2012-05-21 Thread Cédric Villemain
_page_cost - (spc_random_page_cost - spc_seq_page_cost) * sqrt(pages_fetched / T); else cost_per_page = spc_random_page_cost; -- Cédric Villemain +33 (0)6 20 30 22 52 http://2ndQuadrant.fr/ PostgreSQL: Support 24x7 - Développement, Expertise et Formation signature.asc Description: This is a digitally signed message part.

Re: [GENERAL] Global Named Prepared Statements

2012-05-21 Thread Cédric Villemain
gt; connection pooler -- not the lame client side pooling solutions you > typically see with the java stack -- but something like pgbouncer. > This amortizes memory costs of server side plans. pgbouncer is > mostly compatible with JDBC; you have to disable automatic statement > pre

Re: [GENERAL] insert ... returning in plpgsql

2012-10-02 Thread Cédric Villemain
ostgresql.org/docs/9.1/static/plpgsql-statements.html Else if you have multiple rows do something like: FOR my_update IN UPDATE ... RETURNING * LOOP -- Cédric Villemain +33 (0)6 20 30 22 52 http://2ndQuadrant.fr/ PostgreSQL: Support 24x7 - Développement, Expertise et Formation signature.asc Descriptio

Re: [GENERAL] Plproxy with returns table() make PG segfault

2012-11-15 Thread Cédric Villemain
rt=) at > /opt/src/postgresql-9.1-9.1.6/build/../src/backend/postmaster/postmaster.c: > 3617 #20 BackendStartup (port=) at > /opt/src/postgresql-9.1-9.1.6/build/../src/backend/postmaster/postmaster.c: > 3302 #21 ServerLoop () at > /opt/src/postgresql-9.1-9.1.6/build/../src/backend/post

Re: [GENERAL] Table Bloat still there after the Vacuum

2010-04-26 Thread Cédric Villemain
and also I did vacuumdb > full on the table. Still there is no change. Can you please suggest if there > is any other operation that can be done to take care of the issue > Thanks for the help > > Regards -- Cédric Villemain -- Sent via pgsql-general mailing list (pgsql-general@post

Re: [GENERAL] Table Bloat still there after the Vacuum

2010-04-26 Thread Cédric Villemain
2010/4/26 Cédric Villemain : > 2010/4/26 akp geek : >> Hi All - >>                   I have a table bloated with following details >> rows:29431 pages:516039 shouldbe:534 (966.4X) wasted size:4223016960 (3 GB) >> * > > I think this info come from check_postgres na

Re: [GENERAL] Storing many big files in database- should I do it?

2010-04-27 Thread Cédric Villemain
yes > Anyone had this kind of design problem and how did you solve it? store your files in a filesystem, and keep the path to the file (plus metadata, acl, etc...) in database. > > Thanks. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make chan

Re: [GENERAL] Open Source BI Tool

2010-04-27 Thread Cédric Villemain
2010/4/27 akp geek : > Hi all - > > I would like to know, if there is a open source BI tool for > creating reports against Postgres database ? appreciate your help Pentaho have some good tools http://www.pentaho.com/ > > Regards > -- Cédric Villemain -- S

Re: [GENERAL] Storing many big files in database- should I do it?

2010-04-29 Thread Cédric Villemain
2010/4/28 Adrian Klaver : > On Tuesday 27 April 2010 5:45:43 pm Anthony wrote: >> On Tue, Apr 27, 2010 at 5:17 AM, Cédric Villemain < >> >> cedric.villemain.deb...@gmail.com> wrote: >> > store your files in a filesystem, and keep the path to the file (plus >

Re: [SPAM] Re: [GENERAL] Best way to replicate to large number of nodes

2010-04-29 Thread Cédric Villemain
the files to the remote machines and execute them there.  This > just seems like a very manual process though. You need to have a look at PgQ. (in short, skytools will do exactly what you want if I understand correctly your requirments, londiste being somewhat like slony) > > - Brian &g

Re: [GENERAL] Inheritance efficiency

2010-05-01 Thread Cédric Villemain
t confirmed this for myself. It has nothing to do with partitionning but how the planner works. Even if the use case remain correct > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/p

Re: [GENERAL] About the limit of storage

2010-05-02 Thread Cédric Villemain
nage-ag-tablespaces.html > Thanks, > Sean > > Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox. > Learn more. -- Cédric Villemain -- 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] (psuedo) random serial for PK or at least UNIQUE NOT NULL?

2010-05-05 Thread Cédric Villemain
isn't it ? > > -- > Vincenzo Romano > NotOrAnd Information Technologies > NON QVIETIS MARIBVS NAVTA PERITVS > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql

Re: [GENERAL] (psuedo) random serial for PK or at least UNIQUE NOT NULL?

2010-05-05 Thread Cédric Villemain
on for 2^64 isn't it ? > > Sure!. > > -- > Vincenzo Romano > NotOrAnd Information Technologies > NON QVIETIS MARIBVS NAVTA PERITVS > -- Cédric Villemain -- 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] question about unique indexes

2010-05-09 Thread Cédric Villemain
so you can have an UNIQUE on a column with multiple times a NULL. You migth want to explicitely add a 'NOT NULL' to your columns here. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postg

Re: [GENERAL] effective_io_concurrency details

2010-05-26 Thread Cédric Villemain
t; > > Postgres 8.4.4 > > pasman > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Cédric Villemain 2ndQuadran

Re: [GENERAL] pg/linux How much swap relative to physical memory is needed?

2010-06-10 Thread Cédric Villemain
monkey was just too fast." > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Cédric Villemain 2ndQuadrant http://2ndQuadrant.fr/ Pos

Re: [GENERAL] Inserting additional data into pg_statistics

2010-06-21 Thread Cédric Villemain
ne, then you *don't* >> need or want that stuff in its pg_statistic.  It won't do you any good >> to have incorrect information in there. >> >>                        regards, tom lane >> > > > -- > Sent via pgsql-general mailing list (pgsql-g

Re: [GENERAL] How can I use parameters in plain sql

2010-09-05 Thread Cédric Villemain
gsql; > > then > > > plpgsql is reserved for fancy things that are tricky to do with plain > sql.  it's got loops, robust error handling, etc. > > http://www.postgresql.org/docs/8.4/static/plpgsql.html > Also, in PostgreSQL 9.0 you can have anonymous

Re: [GENERAL] PG website testing

2010-10-04 Thread Cédric Villemain
> IRC (freenode): dark_ixion > Registered Linux user: #516935 > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Cédric Villemain               2ndQuad

Re: [GENERAL] Is there a logical reason for 25P02?

2010-10-05 Thread Cédric Villemain
will be > noticeable. Is there a better approach? Is it possible to customize INSERT > behavior to not abort transaction due to an integrity violation? Would it be > possible to alter COPY command behavior as well (to gracefully continue > after integrity violation)? you probably want pgload

Re: [GENERAL] storing windows path strings

2010-01-29 Thread Cédric Villemain
NING:  nonstandard use of \\ in a string literal explicetely set ON the standard_conforming_string in the postgresql.conf *but* take care it don't break your application. INSERT INTO foo (name, dirpath) VALUES ('bar', 'c:\windows\path\to\bar'); > > > > -- Cédric Vi

Re: [GENERAL] Multiple buffer cache?

2010-02-06 Thread Cédric Villemain
ttp://villemain.org/projects/pgfincore > >> >> Is it possible? >> >> Thanks for any hints! >> >> Alexei >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> htt

Re: [GENERAL] Multiple buffer cache?

2010-02-06 Thread Cédric Villemain
villemain.org/projects/pgfincore >> >> > >> >> >> >> Is it possible? >> >> >> >> Thanks for any hints! >> >> >> >> Alexei >> >> >> >> -- >> >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> >> To make changes to your subscription: >> >> http://www.postgresql.org/mailpref/pgsql-general >> > >> > -- >> > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> > To make changes to your subscription: >> > http://www.postgresql.org/mailpref/pgsql-general >> > >> >> >> >> -- >> C?dric Villemain > -- Cédric Villemain -- 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] Multiple buffer cache?

2010-02-06 Thread Cédric Villemain
6&c=n > Forget vote: > http://filter.kgbinternet.com/canit/b.php?i=80190050&m=fbb7172fd677&t=201002 > 06&c=f > ------ > END-ANTISPAM-VOTING-LINKS > > __ Information from ESET Smart Security, version of vi

Re: [GENERAL] GIN : Working with term positions

2011-10-27 Thread Cédric Villemain
s, parsing the string returned by the function > to find the term and its positions. But would be way more efficient to get > them directly at the first call when matching the terms with @@ operator. I > know it would be impossible if the query contain more than 1 term because it > can

Re: [GENERAL] How to install pgfincore with PG 9.1

2011-11-20 Thread Cédric Villemain
.1/share/postgresql/extension/' > /opt/PostgreSQL/9.1/lib/postgresql/pgxs/src/makefiles/../../config/install-sh: > ./pgfincore--unpackaged--.sql does not exist. > make: *** [install] Error 1 > Please assist me, thanks in advance. buggy Makefile. Thanks for the report. I'll fi

Re: [GENERAL] General performance/load issue

2011-11-24 Thread Cédric Villemain
;t be that hard to get thrashing >> being set up that way. YMMV. > > This is one of the reasons why effective_cache_size should be lower than > 32GB, probably ... according to 'free' output, 38GB is what is here right now. effective_cache_size is just informative, so you ca

Re: [GENERAL] General performance/load issue

2011-11-24 Thread Cédric Villemain
is going on there. >> >>But all this is just guessing - I want to see the log_checkpoint message, >>iostat results etc. >> >>> On a side note, I'd guess your work_mem is probably too high. 50 >>> (connections) x 128 (mb work mem) x 2 (sorts per quer

Re: [GENERAL] General performance/load issue

2011-11-25 Thread Cédric Villemain
Le 25 novembre 2011 11:25, Tomas Vondra a écrit : > On 24 Listopad 2011, 23:19, Cédric Villemain wrote: >> Le 24 novembre 2011 20:38, Gaëtan Allart a écrit : >>> Finally, it "crashed" againŠ :-( >>> >>> Here's the output of iotop while datab

Re: [GENERAL] General performance/load issue

2011-11-25 Thread Cédric Villemain
c duration ? You should increase shared_buffers (you can iterate) *and* try to not have the long checkpoint sync. (keep shared_buffers <= 8GB, as already mentioned upthread) The output you provided does not show everything, and the select are not looking to write that much. What process are wr

Re: [GENERAL] What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row?

2011-12-05 Thread Cédric Villemain
; tags all that often, but I want it to be at least possible to do >> without major headaches. > > I would use a boolean column per property and a partial index on the > ones > where the property is selective, i.e. only a small percentage of all > recipes > match the property

Re: [GENERAL] pg_standby: How to check in which state the server is currently?

2011-12-05 Thread Cédric Villemain
l-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Cédric Villemain +33 (0)6 20 30 22 52 http://2ndQuadrant.fr/ PostgreSQL: Support 24x7 - Développement, Expertise et Formation -- Sen

Re: [GENERAL] is there example of update skript?

2011-12-07 Thread Cédric Villemain
required. (expect to increase version number) > > Regards > > Pavel Stehule > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Cédric Villem

Re: [GENERAL] Howto to clear PostgreSQL cache and how to preload all tuples of a table into the cache?

2011-12-12 Thread Cédric Villemain
mecanism to decide what to keep and what to remove with (we expect) more intelligence than us. -- Cédric Villemain +33 (0)6 20 30 22 52 http://2ndQuadrant.fr/ PostgreSQL: Support 24x7 - Développement, Expertise et Formation -- 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] PostgreSQL DBA in SPAAAAAAAACE

2011-12-12 Thread Cédric Villemain
unt" type emails will can it. > > I suspect that we're supposed to do this every day- I'm sure that Certain > Corporates will have no compunction at using multiple votes. Correct «Thanks for your vote. You can vote for your favorite DBA every day to boost their chances of tr

Re: [GENERAL] Server/Data Migration Advice

2011-12-12 Thread Cédric Villemain
so that it's compatible with 9.1.1 so if you guys > could please shine in on any recommendations, I would greatly > appreciate it! > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org

Re: [GENERAL] Searchable chess positions in a Postgress DB

2012-04-11 Thread Cédric Villemain
o be just a single byte, or are there > better alternatives? A 13-state enum would be best (listing the 6 > white pieces, 6 black pieces, and 'empty' states for every square on > the board) but as I understand from the documentation, enums always up > take 4 bytes per entry. &g

[GENERAL] Re: [Pkg-postgresql-public] Postgres major version support policy on Debian

2009-03-15 Thread Cédric Villemain
8.04 LTS) > > Martin > Any plan for 8.4 pre-beta package ? (Devrim Gunduz provide usefull rpm package, I'd like to have the same in debian). Can it be in the experimental repository ? - -- Cédric Villemain Administrateur de Base de Données Cel: +33 (0)6 74 15 56 53 http://da

[GENERAL] Re: [Pkg-postgresql-public] Postgres major version support policy on Debian

2009-03-16 Thread Cédric Villemain
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Martin Pitt a écrit : > Cédric Villemain [2009-03-15 23:58 +0100]: >> Any plan for 8.4 pre-beta package ? (Devrim Gunduz provide usefull rpm >> package, >> I'd like to have the same in debian). >> >> Can it be in

[GENERAL] debian package 8.4devel was:[Pkg-postgresql-public] Postgres major version support policy on Debian

2009-03-30 Thread Cédric Villemain
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Cédric Villemain a écrit : > Martin Pitt a écrit : >> Cédric Villemain [2009-03-15 23:58 +0100]: >>> Any plan for 8.4 pre-beta package ? (Devrim Gunduz provide usefull rpm >>> package, >>> I'd like to have