Re: [GENERAL] How to retrieve jsonb column through JDBC

> On 29 Aug 2016, at 20:23, Alexander Farber wrote: > On Mon, Aug 29, 2016 at 7:50 PM, Merlin Moncure wrote: > On Sat, Aug 27, 2016 at 5:39 AM, Alexander Farber > wrote: > > > > List last_tiles = (List)

Re: [GENERAL] Any work on better parallelization of pg_dump?

Jehan-Guillaume de Rorthais wrote: > > Yeah. I recall there being some stupid limitation in ALTER TABLE .. ADD > > CONSTRAINT USING INDEX to create a primary key from a previously > > existing unique index, which would be very good to fix (I don't recall > > what it was, but it was something

[GENERAL] 9.6 Release: Call for Quotes

PostgreSQL Users: For the PostgreSQL 9.6 release, we are looking for two to three quotes to promote the release. These quotes should come from representatives of PostgreSQL-using organizations (not support vendors). They should focus on one or more of the following: * A new feature, such as:

Re: [GENERAL] How to retrieve jsonb column through JDBC

On Mon, Aug 29, 2016 at 7:50 PM, Merlin Moncure wrote: > On Sat, Aug 27, 2016 at 5:39 AM, Alexander Farber > wrote: > > > > List last_tiles = (List) JSON.parse(rs.getString("last_ > tiles")); > > > > has not work for me even though the

Re: [GENERAL] How to retrieve jsonb column through JDBC

On Sat, Aug 27, 2016 at 5:39 AM, Alexander Farber wrote: > Hello, > > what do you use to retrieve a jsonb column using JDBC? > > I have tried > > Object last_tiles = rs.getObject("last_tiles"); > > and the resulting Object seems to be a String. > > Then I have

Re: [GENERAL] a column definition list is required for functions returning "record"

On Mon, Aug 29, 2016 at 6:28 AM, Tom Lane wrote: > Pavel Stehule writes: >> 2016-08-29 1:59 GMT+02:00 Jim Nasby : >>> It would be nice if there was a way to pass dynamically formed records >>> around, similar to how you can

Re: [GENERAL] Any work on better parallelization of pg_dump?

On Mon, 29 Aug 2016 13:13:17 -0300 Alvaro Herrera wrote: > Jehan-Guillaume de Rorthais wrote: > > On Mon, 29 Aug 2016 13:38:03 +0200 > > hubert depesz lubaczewski wrote: > > > > > Hi, > > > we have rather uncommon case - DB with ~ 50GB of data, but

Re: [GENERAL] Any work on better parallelization of pg_dump?

On Mon, Aug 29, 2016 at 01:13:17PM -0300, Alvaro Herrera wrote: > > > This happens on Pg 9.5. Are there any plans to make getting schema > > > faster for such cases? Either by parallelization, or at least by getting > > > schema for all tables "at once", and having pg_dump "sort it out", > > >

Re: [GENERAL] Any work on better parallelization of pg_dump?

Jehan-Guillaume de Rorthais wrote: > On Mon, 29 Aug 2016 13:38:03 +0200 > hubert depesz lubaczewski wrote: > > > Hi, > > we have rather uncommon case - DB with ~ 50GB of data, but this is > > spread across ~ 8 tables. > > > > Running pg_dump -Fd -jxx dumps in parallel,

Re: [GENERAL] Any work on better parallelization of pg_dump?

On Mon, 29 Aug 2016 13:38:03 +0200 hubert depesz lubaczewski wrote: > Hi, > we have rather uncommon case - DB with ~ 50GB of data, but this is > spread across ~ 8 tables. > > Running pg_dump -Fd -jxx dumps in parallel, but only data, and MOST of > the time is spent on

[GENERAL] Any work on better parallelization of pg_dump?

Hi, we have rather uncommon case - DB with ~ 50GB of data, but this is spread across ~ 8 tables. Running pg_dump -Fd -jxx dumps in parallel, but only data, and MOST of the time is spent on queries that run sequentially, and as far as I can tell, get schema of tables, and sequence values.

Re: [GENERAL] a column definition list is required for functions returning "record"

Pavel Stehule writes: > 2016-08-29 1:59 GMT+02:00 Jim Nasby : >> It would be nice if there was a way to pass dynamically formed records >> around, similar to how you can pass the results of row() around. Someone >> else has actually be asking

Re: [GENERAL] a column definition list is required for functions returning "record"

Thank you for your comments! I have switched to SQL function now (I didn't realize it is better performancewise) - CREATE OR REPLACE FUNCTION words_select_games(IN in_uid integer) RETURNS TABLE( out_gid integer, out_created integer,