Re: [GENERAL] [BUGS] compatibilty postgres 9.2 RHEL 6.4

pendency libraries. Now. the data directori *is* compatible if you keep using 9.2 so i would install the right binary from yum.postgresql.org and use existing data directory -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-gen

Re: [GENERAL] How to speed up pg_trgm / gin index scan

rol. if you have 9.3 or superior you can know how big is that pending list installing pgstattuple. CREATE EXTENSION pgstattuple; SELECT * FROM pgstatginindex('tridx_logs_01_msg'); NOTE: remember that pending_pages is expressed in 8kb-pages if that is the problem or if you are in <= 9.2 then try

Re: [GENERAL] Transactional DDL

0 sec) Tom's example seems to show that mysql inserts a commit immidiatelly after a DDL but this one example shows the thing is worse than that. if that is the case this 3 rows should have been gone with the rollback. -- regards, Jaime Casanova "Programming today is a race between

Re: [GENERAL] Transactional DDL

n informix is better than oracle in this point. last time i try this on informix it did the right thing... sadly enough, i don't have an informix database at hand to confirm if my memory has no corrupted indexes ;) -- regards, Jaime Casanova "Programming today is a race between so

Re: [GENERAL] automatically execute a function each day

-- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning."

Re: [GENERAL] Add Column BEFORE/AFTER another column

ch) we had the semblence of a patch and an actual plan for > implementing this, but no one got interested enough to finish it for 8.3. > Should you happen to know an ambituous C hacker, there is a good chance it > could be included in 8.4. > really? i don't remember it? can you po

Re: [GENERAL] Can this function be declared IMMUTABLE?

any > benefit in this scenario. > do you know that early optimization is the root of all evil? -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce

Re: [GENERAL] Max File size per Table (1G limit??)

> I'm wondering what are these since I've not set up table partitioning > just yet. > > postgres uses datafiles from up to 1GB, if a table has more data than that limit then postgres creates more files. http://www.postgresql.org/docs/8.2/static/storage-file-layout.html --

Re: [GENERAL] AUXILIO!!!! CONSULTA SOBRE CURSORES HELP!!! ABOUT CURSORS

s.html#PLPGSQL-STATEMENTS-RETURNING espero que te sirva - hope it helps you -- Atentamente, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better

Re: [GENERAL] publicar

los mensajes a la lista de la comunidad hispana ([EMAIL PROTECTED]) i think you already did it, just write a mail to the list address... but, this is an english list... so write in english or better write to the spanish list ([EMAIL PROTECTED]) -- Atentamente, Jaime Casanova "Program

Re: [GENERAL] match accented chars with ASCII-normalised version

a' to > 'España'. Searching online, I found a few ideas (soundex, intuitive > fuzzy something-or-other) but mostly they seem like overkill for this > application. > what about using to_ascii() ? http://www.postgresql.org/docs/8.3/static/functions-string.html -- regards, Jai

Re: [GENERAL] Copying data files to new hardware?

p; restore the only real way to do this? > it's safe to just install any version of 8.2.x, copy the whole data directory (plus any tablespace's directories you could have) and start again... probably you want to REINDEX your indexes (read the release notes to see what specific kind of in

Re: [GENERAL] School teacher in need of HELP

ave to supply a password. Try the command without a password. > right. and because the OP is a good reader he should read chapter 19.1 (http://www.postgresql.org/docs/9.0/static/auth-pg-hba-conf.html) and use trust in authentication method -- Jaime Casanova         www.2ndQuadrant.com Profe

Re: [GENERAL] shared folder in Hot Standby

hive_command='exit 0' max_wal_senders = on slave: === postgresql.conf === hot_standby=on === recovery.conf === standby_mode='on' primary_conninfo = 'host=master_ip' or you can use repmgr to make all this easier: http://projects.2ndquadrant.com/repmgr -- Jaime Casanova 

Re: [GENERAL] [PERFORM] Very slow inner join query Unacceptable latency.

't get reformatted by the mail client. what version of postgres is this? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] [PERFORM] Very slow inner join query Unacceptable latency.

nel... it will cause more problems than the one it solves. what you can do is: 1) execute: SET enable_hashjoin TO OFF; SELECT here RESET enable_hashjoin TO ON; 2) in a function: CREATE FUNCTION do_something() RETURNS bigint AS $$ SELECT here $$ LANGUAGE sql SET enable_hashjoin TO OFF STABLE;

Re: [GENERAL] temp sequence

unction again. > create, and use the sequence through EXECUTE EXECUTE 'create temp sequence seq1'; EXECUTE 'select nextval(' || quote_literal('seq') || ') '; the same apply for all kind of temp objects, in 8.3 this no longer will be an issue -- regards,

Re: [GENERAL] INFINITE RECURSION with rules...

LUES (33,'[EMAIL PROTECTED]','bill', calc('[EMAIL PROTECTED]', 'bill')); or maybe using a trigger before insert but you're insert should look like: INSERT INTO b(id, email_a, name_a) VALUES (33,'[EMAIL PROTECTED]','bill');

Re: [GENERAL] temporarily deactivate an index

them... the effect, most of the time, is that indexes will not be used but you can't be sure... the better solution was the first one: dropping the index inside a transaction, execute the explain analyze of the query and rollback the transaction -- regards, Jaime Casanova Soporte y ca

Re: [GENERAL] temporarily deactivate an index

NCURRENTLY you could > mark the index not ready to use yet (see pg_index.indisvalid or > pg_index.indisready depending on version). > if i mark the index not ready (using pg_index.indisvalid or pg_index.indisready depending on version), will the index be updated if in another transaction

Re: [GENERAL] ERROR: missing FROM-clause entry for table on postgresql 8.1 not on 7.4; deleting from a join

maybe the add_missing_from parameter in postgresql.conf is what you need to get some sleep :) it's there for older application like yours -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Guayaquil - Ecuador Cel. (593) 87171157 -- Sent via pgsql-general mailing list

Re: [GENERAL] Help interpreting pg_stat_bgwriter output

ast) equal or (better) lower than buffers_clean, rigth? or i'm understanding wrong? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] auto truncate/vacuum full

;t > have, so what you describe is what we would expect. > then we have a bug (at least in 8.3, haven't tried in 8.4)... i see this a month ago, an autovacuum blocking a lot of concurrent updates and selects... once i pg_cancel_backend() the autovacuum process the other ones starting

Re: [GENERAL] Postgres replication question :- One master 2 slaves 9.0.10

ming. but it would be a good idea to set hot_standby_feedback to on and max_standby_archive_delay to something larger than 30s -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-general m

Re: [GENERAL] Postgres replication question :- One master 2 slaves 9.0.10

On Tue, Oct 1, 2013 at 10:48 PM, Sergey Konoplev wrote: > On Tue, Oct 1, 2013 at 6:15 PM, Jaime Casanova wrote: > >> but it would be a good idea to set hot_standby_feedback to on and >> max_standby_archive_delay to something larger than 30s > > Doesn't replica ne

[GENERAL] Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes

-- Forwarded message -- > From: Shahzad Bashir > Date: Thu, Oct 3, 2013 at 5:43 AM > Subject: RE: [ADMIN] Database replication to 50-80 nodes > To: Jaime Casanova > > > hi, > I am very much new to postgres, infact just started... can anyone please share

Re: [GENERAL] Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes

On Thu, Oct 3, 2013 at 5:40 PM, Ian Lawrence Barwick wrote: > 2013/10/4 Jaime Casanova : >> what version of postgres is this? starting in 9.3 you can create >> foreign tables between postgres databases, before that you can create >> a foreing server and use the functions fro

Re: [GENERAL] [HACKERS] PostgreSQL Core Team

On Wed, Apr 27, 2011 at 1:48 PM, Dave Page wrote: > I'm pleased to announce that effective immediately, Magnus Hagander > will be joining the PostgreSQL Core Team. > Congratulations! -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte y capacitación

Re: [GENERAL] Remove Modifiers on Table

ll tables > I'm used to MySQL where this was > as easy as running: > > CREATE TABLE test ( > id INT PRIMARY KEY AUTO INCREMENT); > in postgres is as easy as CREATE TABLE test( id SERIAL PRIMARY KEY); hey! it's even less keystrokes! -- Jaime Casanova         www.2n

Re: [GENERAL] Query to return every 1st Sat of a month between two dates

itial date and now()::date - '1 day' the final one, replace them with you're own range -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte y capacitación de PostgreSQL -- 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] How to check a table content efficiently? With LIMIT and OFFSET?

ght as well run analyse immediately on that table. > > My table is a read-only table after all. > That's another reason why I'm reluctant using ANALYZE . > sorry, i don't follow that... why do you think that a read-only table doesn't need an ANALYZE? -- Jaime Casano

Re: [GENERAL] insert a SYSTIMESTAMP value in postgres

insert into request_queue (request_id, received_time > > ) > > values (new.request_id, SYSTIMESTAMP > > ); > > > > How can I insert a dynamic timestamp value in postgress, please? > Maybe this document can help

Re: [GENERAL] [BUGS] Where is pg_create_restore_point funciton in 9.1a2 ?

'); > > By the way, another issue that I found is when I execute \df. It > doesn't display anything (I must > force with * to do that). i can confirm this -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent

Re: [GENERAL] repmgr problem with registering standby

.2 port=5432 user=repmgr dbname=repmgr > (1 row) > this is on the master or the slave? -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscripti

Re: [GENERAL] repmgr and archive_mode

while archive_command can be changed at anytime just reloading archive_mode needs to restart the server. so this is just a good configuration for 24x7 setups -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-general mailing list (p

Re: [GENERAL] eval function

;cannot cast type boolean to text" are you aware that support for 8.2 will stop in December 2011, right? http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-

Re: [GENERAL] repmgr problem with registering standby

On Wed, Jul 27, 2011 at 7:24 PM, Toby Corkindale wrote: > On 28/07/11 03:47, Jaime Casanova wrote: >> >> On Wed, Jul 27, 2011 at 4:36 AM, Toby Corkindale >>  wrote: >>> >>> So that looks good, but then I try this on the slave: >>> # repmgr -f /e

Re: [GENERAL] Postgres 8.0 upgrade to 9.0

the "Migration to Version X.X" in the release notes for the above mentioned versions > 2)  Do I need to upgrade JDBC driver when I upgrade to postgres9.0. > probably but i'm not so sure about it -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Sopo

Re: [GENERAL] postgres table have a large number of relpages and occupied a big memory size

wo tables that logs all changes in the database... normally only one of the table should be in use while Slony is processing the queu of the other and truncate it. but if the slon process are not running those tables start to grow... can you check that the slon processes are running -- Jaime Casanova

Re: [GENERAL] postgres table have a large number of relpages and occupied a big memory size

you can see an estimate of how many dead tuples are looking at the n_dead_tup in pg_stat_all_tables -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your sub

Re: [GENERAL] about synchronous_standby_names or sync replic

server "set synchronous_commit to on" (of course, this SET is a command you send to the server just like any other SQL command) don't forget to reset synchronous_commit or use set local, otherwise you will let this node as the sync rep until disconnect -- Jaime Casanova         www

Re: [GENERAL] Promoting sync slave to master without incrementing timeline counter?

th the `pg_ctl > restart` approach, or is it safe to use? > it's safe as long as you let repmgr do it ;) -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make cha

Re: [GENERAL] PostgreSQL limitations question

and then you can have "partitioned" tables, while the system consider them almost independent tables (they are dependent only in the sense that if you read the parent it will read the childs too) but for the user they will look as one single table. so even say see limited by ta

Re: [GENERAL] How to read the execution Plan

OUNT http://wiki.postgresql.org/wiki/Using_EXPLAIN -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

Re: [GENERAL] Performance and Clustering

some one or are there numbers supporting that? if the app is correctly written the connections wiil be taken and relesead as needed then you can use a connection pooler -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel.

Re: [GENERAL] autovacuum: 50% iowait for hours

end versions of our product. > why you can't upgrade to say: 8.1.20... it has the same behaviour as 8.1.4 and less bugs... -- Jaime Casanova www.2ndQuadrant.com Soporte y capacitación de PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang

Re: [GENERAL] Commit every N rows in PL/pgsql

r r in select col_a from t loop update t set col_c = col_a + col_b where col_a = r.a; end loop; return; end; $$ language plpgsql; -- Jaime Casanova www.2ndQuadrant.com Soporte y capacitación de PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] 3rd time is a charm.....right sibling is not next child crash.

On Tue, Jun 8, 2010 at 12:49 PM, Jeff Amiel wrote: > > Does Slony manage it's own vacuuming separate from postgres' autovacuum? > Yes it does: http://www.slony.info/documentation/maintenance.html -- Jaime Casanova www.2ndQuadrant.com Soporte y capacitación de P

Re: [GENERAL] non-WAL btree?

On Fri, Aug 1, 2008 at 3:32 PM, Alex Vinogradovs <[EMAIL PROTECTED]> wrote: > Isn't hash indexing implementation non-WAL ? > yes, but that's because no one thinks is worth the effort of making them WAL logged while they keep slower than btree... -- regards, Ja

Re: [GENERAL] non-WAL btree?

hat? if they are non WAL logged the only way to re-create them after a recovery is with a REINDEX... dropping the index and create after the bulk is just the same, i think... -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Guayaquil - Ecuador Cel. (593) 87171157 -- Sent via pgsql-

Re: [GENERAL] non-WAL btree?

; insert... insert... ... commit; or set synchronous_commit to off; copy command; set synchronous_commit to on; -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Guayaquil - Ecuador Cel. (593) 87171157 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] What happen to the VARATT_SIZEP macro in version 8.3?

you really need it maybe you can make your own wrapper in ine of your includes: #define VARATT_SIZEP(_PTR) \ VARATT_SIZEP_DEPRECATED(PTR) -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Guayaquil - Ecuador Cel. (593) 87171157 -- Sent via pgsql-general m

Re: [GENERAL] Initdb problem on debian mips cobalt: Bus error

/wiki/Working_with_CVS > that is for setup your local copy of the repository, you should only need this: http://www.postgresql.org/docs/8.3/static/anoncvs.html -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Guayaquil - Ecuador Cel. (593) 87171157 -- Sent via pgsql-general

Re: [GENERAL] explain inside begin; commit;

5; > commit; > Query result with 2 rows discarded. > > > Query returned successfully with no result in 58 ms. > don't do it in pgAdmin but in psql -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. (593) 87

Re: [GENERAL] Vaccuum best practice: cronjob or autovaccuum?

helpful. VACUUM FULL is recommended for cases where you know you have deleted the majority of rows in a table, so that the steady-state size of the table can be shrunk substantially with VACUUM FULL's more aggressive approach. Use plain VACUUM, not VACUUM FULL, for routine vacuuming for spa

Re: [GENERAL] How do I save data and then raise an exception?

> directly but you can implement using dblink or a plperl function that > connects back to the database. > what about RAISE NOTICE? -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsq

Re: [GENERAL] PL/pgSQL stored procedure returning multiple result sets (SELECTs)?

lazy millionaire :) > > I don't quite understand you here. I'm sure we all crave the lazy > millionaire bit, but what would a lazy millionaire do other than > programming for fun? > read dozens of mails from a forum? -- Atentamente, Jaime Casanova Soporte y capacitació

[GENERAL] filter statements in logs

predefined statements? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- 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] pg_get_serial_sequence Strangeness/Unreliable?

ys this > can we make \d show if the sequence is owned by the table (ie: serial or manually created and owned) or is a manually created and maked default sequence? maybe a flag? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - E

[GENERAL] two postgres server seeing the same data

ny one has tried that configuration? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

[GENERAL] about privileges on pg_stat_activity columns

functions pg_stat_activity is calling) but still he see the columns that comes from the functions as null... is there a way to give him access to that data without give him superuser? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil

Re: [GENERAL] two postgres server seeing the same data

s failed. Two postmasters, one data area, and no > recoverable data. > the worst part of learning the lesson ;) -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-general mailing li

Re: [GENERAL] two postgres server seeing the same data

On Wed, Dec 3, 2008 at 4:30 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Wed, Dec 3, 2008 at 2:29 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: >> On Wed, Dec 3, 2008 at 2:23 PM, Jaime Casanova >> <[EMAIL PROTECTED]> wrote: >>> On Wed, Dec 3, 2008 at

Re: [GENERAL] about privileges on pg_stat_activity columns

On Thu, Dec 4, 2008 at 4:02 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: > Jaime Casanova wrote: >> >> we created an user to him and give him privileges to pg_locks and >> pg_stat_activity (and the functions pg_stat_activity is calling) but >> still he se

[GENERAL] shared disk failover

Hi, any one has doing this... is there a good tutorial o directions for it? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] [HACKERS] New PostgreSQL Committers

On Mon, Dec 7, 2009 at 5:49 AM, Dave Page wrote: > > The new committers are: > > Robert Haas > Simon Riggs > Greg Stark > ITAGAKI Takahiro > > Congratulations! > +1 -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de si

Re: [GENERAL] Implementing next 30 (or so) rows "sliding window"

that's basically LIMIT, you have to combine that with OFFSET -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Implementing next 30 (or so) rows "sliding window"

t using cursor is another (preferred?) solution for this, -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- 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] AccessShareLock question

ith anyone trying to change the structure of the table (ALTER, DROP) and with commands TRUNCATE, REINDEX, CLUSTER, and VACUUM FULL, and every select take it -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157

Re: [GENERAL] AccessShareLock question

E? no -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- 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] alter table performance

but if you insist in plpgsql you can execute "select version() into some_text_var" and act acordingly -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-general mailing list (p

Re: [GENERAL] How to use read uncommitted transaction level and set update order

but must be 4. no. b value "must be" 1, you want it to be 4... in an update the columns always hold the old value until the statement is finished, the only way i can think for doing this is with a trigger -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesorí

Re: [GENERAL] relation pg_autovacuum does not exist in postgresql 8.4.2

changes allowed 2) create pg_catalog.pg_autovacuum with structure it has until 8.3 (i guess if those programs are broken enough to ask for the catalog maybe it is also asking for specific columns of the catalog) 3) Exit and start the service again -- Atentamente, Jaime Casanova Soporte y capacitac

Re: [GENERAL] How to use read uncommitted transaction level and set update order

before update on test1 for each row execute procedure keep_a_in_b_test1(); -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] postgres

On Wed, Jan 13, 2010 at 11:31 AM, Amy Smith wrote: > all > how to set up  PGTAB file ? any example for > PGTAB=/opt/postgres/utilities/conf/pgtab > what is pgtab for? and where do you get it? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo

Re: [GENERAL] Unique cosntraint based on contents of a field?

the number 2 or any other single number in that field. > create unique index unique_field_idx on table1(field) where field = 1; -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-gener

Re: [GENERAL] Disable Streaming Replication ==> Stop WAL Sender on master and WAL receiver on Slave

end and to receive), so it will take some time until standby catch up 2) what if the wal segment that was being used when you stopped walsender is reused in master before walsender is reactivated? -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación

Re: [GENERAL] synchronous replication + fsync=off?

n't tried. anyway that will guarantee you will lose your master instalation on OS crash and i think to remember that even if the OS doesn't crash there is a risk (altough i can't find the mail saying that) -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Sopor

Re: [GENERAL] [ADMIN] Urgente error in restore prod

s error can you show what were you doing? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your sub

[GENERAL] monitor effectiveness of fillfactor and vacuums

Hi, currently i'm trying to $SUBJECT, my actual approach is to look at n_tup_upd and n_tup_hot_upd assuming the more near they are the better... is that a good assumption? what else can i see? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sis

Re: [GENERAL] explain

tenga una tabla -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/ma

Re: [GENERAL] explain

ow it) - you can > use list pgsql-es-ayuda > (http://archives.postgresql.org/pgsql-es-ayuda/). > oops! i answered in spanish too! i never saw the list it was sent to... -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecu

Re: [GENERAL] Indexing columns with low cardinality: persistent bitmap indexes?

25% 5 47% then only partial indexes on values 1 and 2 are of some value -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-general mailing list (pgsql-general

Re: [HACKERS] Re: [GENERAL] Question regarding new windowing functions in 8.4devel

nk > FROM >foo >WINDOW w AS (partition by typ order by ts desc) > WHERE >foo_rank < 4; > > ERROR: syntax error at or near "WHERE" > LINE 8: WHERE >^ the WINDOW specification goes after the WHERE clause not before -- Atentamente,

Re: [GENERAL] Rollback of Query Cancellation

ink the ROLLBACK never executed based on... reponse time? very unscientific (there are plenty other reasons for that to happen) [1] http://www.postgresql.org/docs/8.3/static/tutorial-transactions.html -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistem

Re: [GENERAL] Rollback of Query Cancellation

On Wed, Jan 28, 2009 at 12:56 AM, Abdul Rahman wrote: > > What do the logs show? > > Message just showed the time it took to delete certain number of records. > can you show that message? copy 'n pasted from logs!! -- Atentamente, Jaime Casanova Soporte y capacitación de P

Re: [GENERAL] Rollback of Query Cancellation

09:42:15 LOG: database system is ready > 2009-01-28 09:42:15 FATAL: the database system is starting up > starting up again none of these are saying the time for some records being deleted, read my prior post about why is not possible that message (commit never executed) -- Atentament

Re: [GENERAL] Rollback of Query Cancellation

hine actively refused it. > 2009-01-27 18:52:08 LOG: unexpected EOF on client connection > guess this messages are received after the CANCEL QUERY if the series of deletes are all executed inside a transaction then they all were rollback if not only the last one (the one that generates the error

Re: [GENERAL] BUMP: Using foreign key constraint to eliminate unnecessary joins in view

. > > Am I just missing something obvious, or does postgresql (currently) not do > that? > postgres will look at all tables involved, i think there is work to make it smart enough to make what you describe but that's in the future... -- Atentamente, Jaime Casanova Soporte y capac

Re: [GENERAL] ERROR: syntax error at or near "IF"... why?

at or near "IF" >> if you're inside a server-side function then you cannot use COMMIT nor ROLLBACK; if you aren't inside a server-side function then you cannot use IF -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Gua

Re: [GENERAL] WHERE

temp table"; > select * from datatable1 where genes in (select gene from temp); Actually, i don't like the name "temp" for a table it seems error prone. -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)

Re: [GENERAL] Update on tables when the row doesn't change

Sorry for not beeing that clear. > > Sebastian > > And how are you preventing the rule execute the update if the field has no change? That is way Martijn told you about showing the rule. AFAIK, if you execute an update on a view that has a ON UPDATE rule all

Re: [GENERAL] Trigger and arguments question

te a kind of generic function which I could use on multiple > tables with different field names (myarg being the field name). > But I can't get it to work. > > Any clues or other solutions? No. the argument of the trigger must be a string literal defined at creation time. maybe you be

Re: [SQL] [GENERAL] index row size 2728 exceeds btree maximum, 27

e he feels they are/should be unique. Given that they are rows > from a logfile, I'm not convinced this is the case. > If this a log he will need a timestamp field to be usefull, making that field part of the primary key and letting the data out of the primary has more sense to me. --

Re: [GENERAL] Issue with adding ORDER BY to EXCEPT.

DER BY on a UNION/INTERSECT/EXCEPT result must be on one of the > result columns > I suppose this is because the columns in the except are the same that the ones in the main select and the order by get confused. i'm redirecting to hackers to know if this is a known bug or there is so

Re: [GENERAL] is this a bug ?

ABLE new_test_id_key RENAME TO test_id_key; > > DROP SEQUENCE new_test_id_seq ; > -- this give an error... is this normal > > is this the normal behaviour ? > -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] default tablespaces

space and create all indexes, a workaround that come to my mind. Any other idea? -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Transaction Handling in pl/pgsql

ut of a transaction block are in its own transaction the select calling your_function is inside a transaction... so, the answer is yes... the statements inside the function will be rolled back -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcas

Re: [GENERAL] i need you help about postgresql(rollback)

ck will be rolled back. If you are using pgsql 7.x.x or lower... you will get an error an all your transaction will be rolled back -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] index row size exceeds btree maximum, 2713 - Solutions?

lock size - or the > BLCKSZ variable in the src/include/pg_config_manual.h file. > > Am I correct so far? > > I need to fix this problem. I cannot change the indexed columns. > can you drop the index and retry? what typo is the column? -- Atentamen

  1   2   3   >