Re: [GENERAL] Why isn't Java support part of Postgresql core?

On Fri, Sep 19, 2014 at 1:10 PM, Dmitriy Igrishin wrote: > > > 2014-09-15 9:22 GMT+04:00 cowwoc : > >> Hi, >> >> Out of curiosity, why is Postgresql's Java support so poor? I am >> specifically looking for the ability to write triggers in Java. > > >> I took a look at the PL/Java project and it l

Re: [GENERAL] PROBLEM Service Alert: hostname/check_postgres_old_transaction is CRITICAL **

On 2014-9-19 20:33 , Adarsh Sharma wrote: > It returns approx *311 MB* data to the client servers. > > root > netstat -p | grep 45355 > tcp0 1531648 localhost:5499 localhost:48848 > ESTABLISHED 45355/postgres > > root > strace -p 45355 > -- Remain stuck for *2-3

[GENERAL] Oleg's talk in Japan

Hi, On September 11th Oleg Bartunov visited Tokyo to give a keynote talk for a PostgreSQL conference held by SRA OSS, Inc. Japan. There were about 80 attendees and we were very impressed by his talk (consecutive interpreting provided) and the possibility of JSONB. Oleg, thank you for the great pr

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 09/19/2014 02:10 PM, Dmitriy Igrishin wrote: 2014-09-15 9:22 GMT+04:00 cowwoc >: Hi, Out of curiosity, why is Postgresql's Java support so poor? I am specifically looking for the ability to write triggers in Java. I took a look at the PL

Re: [GENERAL] Why isn't Java support part of Postgresql core?

2014-09-15 9:22 GMT+04:00 cowwoc : > Hi, > > Out of curiosity, why is Postgresql's Java support so poor? I am > specifically looking for the ability to write triggers in Java. > I took a look at the PL/Java project and it looked both incomplete and > dead, > yet other languages like Javascript a

[GENERAL] PROBLEM Service Alert: hostname/check_postgres_old_transaction is CRITICAL **

Hi all, >From the past few days i am getting this old transation alert from some of my DB slaves. I am using EDB9.2.7.18 on on CentOS6.5 ( Final ). From my app boxes i got some of the transactions remains stuck for 2-3 hours which took ~ < 60 seconds in database. Below are the details :- -- DB e

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 19/09/2014 4:30 AM, Szymon Guz wrote: I think all people here agree that adding another package to linux repository or an option to windows installer is OK. What some people disagree here is adding jre to the core postgres. So we're in agreement. Oh, and btw, I've got a package named postg

[GENERAL] corruption in system tables (9.1.13)

Hi, One of our postgres database clusters suddenly developed a corruption in the system tables. I tried to debug this as best I could, but haven't found a root cause yet. I'm mainly seeking more pointers to attack this. The error message that suddenly appeared for a lot of queries (but not all

Re: [GENERAL] a couple questions about convert()

smcg2...@frii.com writes: > In a postgresql-9.3.1 database with UTF8 encoding I can do: > select convert_from (E'\\x68656c6c6f', 'LATIN1'); >convert_from > -- >hello > But when I explicitly give the "to" encoding: > select convert (E'\\x68656c6c6f', 'LATIN1', 'UTF8');

Re: [GENERAL] pg_multixact issues

On Fri, Sep 19, 2014 at 7:14 PM, Emanuel Calvo < emanuel.ca...@2ndquadrant.com> wrote: > > Could it be related to some fixes on 9.3.5?: > > - Fix wraparound handling for pg_multixact/members (Álvaro Herrera) > - Truncate pg_multixact during checkpoints, not during VACUUM (Álvaro > Herrera) > Curr

Re: [GENERAL] pg_multixact issues

El 17/09/14 10:51, Dev Kumkar escribió: > On Wed, Sep 17, 2014 at 6:53 PM, Andres Freund > wrote: > > On 2014-09-17 17:46:05 +0530, Dev Kumkar wrote: > > On one my machine the pg_multixact directory size has grown up > to 5 GB and > > am not sure how

Re: [GENERAL] cloning database

On 09/19/2014 07:04 PM, hubert depesz lubaczewski wrote: > > > for i in {1..150}; do createdb -T database_source database$i; done Unless `datistemplate` is set for the database, you'll need to do this as a superuser. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL De

Re: [GENERAL] ALTER TEXT field to VARCHAR(1024)

On Fri, 19 Sep 2014 09:32:09 +0200 Marius Grama wrote: > Hello, > > > i am using Postgres 9.2 and I'd like to perform the following ALTER > statement on a database table with about 30M entries : > > ALTER TABLE images ALTER COLUMN mask_descriptors TYPE VARCHAR(1024); > > > > The mask_descri

Re: [GENERAL] cloning database

On Fri, Sep 19, 2014 at 8:35 AM, Philipp Kraus wrote: > Is there a buildin way to clone the "database_source" with all structure > and data into a new database "database1..150" ? > assuming you're using bash shell, this should work: for i in {1..150}; do createdb -T database_source database$i;

Re: [GENERAL] Why isn't Java support part of Postgresql core?

These are minor nitpicks but they address significant questions about the scope of core. On Fri, Sep 19, 2014 at 1:19 AM, cowwoc wrote: > I am beginning to feel like people are putting words in my mouth :) > > I agree with most of what you said. I will only comment on the differences: > > Ther

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 19 September 2014 10:19, cowwoc wrote: > I am beginning to feel like people are putting words in my mouth :) > > I agree with most of what you said. I will only comment on the differences: > > There is nothing special in java, that's just another language like perl, > python and tcl. I don't

Re: [GENERAL] Why isn't Java support part of Postgresql core?

I am beginning to feel like people are putting words in my mouth :) I agree with most of what you said. I will only comment on the differences: There is nothing special in java, that's just another language like perl, python and tcl. I don't see any reason to treat that differently. I don't d

[GENERAL] Re: How can i monitor exactly what (partition) tables are accessed by a query?

On 19 September 2014 09:13, David Johnston wrote: >> What may be worth a try is to join against a UNION ALL of your partitions, >> with each section of the UNION having an explicirt WHERE clause matching >> your partitioning constraints. >> The idea there is that such a UNION could provide the exp

Re: [GENERAL] [SQL] pg_multixact issues

On Fri, Sep 19, 2014 at 1:03 PM, Andres Freund wrote: > Yes: Learning some patience. You'd given the previous answer two hours > before this one. Nobody is paid to work on this list... Apologies for the delay, was working/troubleshooting same issue and was away from my emails. :( Regards...

Re: [GENERAL] [SQL] pg_multixact issues

On Fri, Sep 19, 2014 at 8:07 AM, Alvaro Herrera wrote: > Can you paste the pg_controldata output please? > pg_controldata output as follows: pg_control version number:937 Catalog version number: 201306121 Database system identifier: 6023658189132429183 Databa

Re: [GENERAL] ALTER TEXT field to VARCHAR(1024)

On 19/09/14 19:32, Marius Grama wrote: Hello, i am using Postgres 9.2 and I'd like to perform the following ALTER statement on a database table with about 30M entries : ALTER TABLE images ALTER COLUMN mask_descriptors TYPE VARCHAR(1024); The mask_descriptors field is currently having the ty

Re: [GENERAL] [SQL] pg_multixact issues

On 2014-09-18 22:52:57 +0530, Dev Kumkar wrote: > On Thu, Sep 18, 2014 at 6:20 PM, Dev Kumkar wrote: > > > On Thu, Sep 18, 2014 at 4:03 PM, Andres Freund > > wrote: > > > >> I don't think that's relevant for you. > >> > >> Did you upgrade the database using pg_upgrade? > >> > > > > That's correc

[GENERAL] ALTER TEXT field to VARCHAR(1024)

Hello, i am using Postgres 9.2 and I'd like to perform the following ALTER statement on a database table with about 30M entries : ALTER TABLE images ALTER COLUMN mask_descriptors TYPE VARCHAR(1024); The mask_descriptors field is currently having the type TEXT. I want to perform the ALTER due

Re: [GENERAL] cloning database

Philipp Kraus wrote: > I need around 150 copies of a database (for an exam). I have got a > database with tables and data and for my exam I would copy this > database in his way: > > database_source > > database1 > database2 > …. > database150 > > Is there a buildin way to clone the "database_so

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 18 September 2014 22:58, cowwoc wrote: Hi, I'm observing the whole discussion, and I really don't like the idea of adding everything to the core. I fully agree that the core should be small, as small as possible. The way it works now is that it provides interfaces to the external languages li

[GENERAL] Re: How can i monitor exactly what (partition) tables are accessed by a query?

On Friday, September 19, 2014, Alban Hertroys wrote: > On 19 Sep 2014, at 3:50, Robert Nix > > wrote: > > > Thanks, David. > > > > I have read that page many times but clearly I have forgotten this: > > > > • Constraint exclusion only works when the query's WHERE clause > contains constants

Re: [GENERAL] cloning database

On 19 Sep 2014, at 8:35, Philipp Kraus wrote: > Hello, > > I need around 150 copies of a database (for an exam). I have got a database > with tables and data and for my exam I would copy this database in his way: > > database_source > > database1 > database2 > …. > database150 > > Is there a

Re: [GENERAL] Reserved keywords and qualified identifiers

cowwoc wrote > Hi, > > http://dev.mysql.com/doc/refman/5.7/en/reserved-words.html explicitly > states that qualified identifiers do not have to be quoted even if they > are reserved keywords ("A word that follows a period in a qualified name > must be an identifier, so it need not be quoted even i

Re: [GENERAL] Re: How can i monitor exactly what (partition) tables are accessed by a query?

On 19 Sep 2014, at 3:50, Robert Nix wrote: > Thanks, David. > > I have read that page many times but clearly I have forgotten this: > > • Constraint exclusion only works when the query's WHERE clause > contains constants (or externally supplied parameters). For example, a > comparison