Re: [GENERAL] SSO Windows-to-unix

Anybody have an help on this topic? Thanks Jeremy From: Guillaume Lelarge [guilla...@lelarge.info] Sent: Wednesday, 14 January 2015 8:20 p.m. To: Jeremy Palmer Cc: PostgreSQL General; raghuchenn...@gmail.com Subject: Re: [GENERAL] SSO Windows-to-unix Le 14

Re: [GENERAL] Partitioning

On 1/18/2015 11:13 PM, James Sewell wrote: Each index is about 2.5GB, I suspect I am trying to read a these into memory in entirety. an 11GB table with a (presumably integer) primary key requires an 2.5GB index ? 100 of these would need 250GB of shared_buffers to stay resident, not lik

Re: [GENERAL] Partitioning

Hello, Thanks for the reply. I can write queries which get index scans, but they are still slow. Each index is about 2.5GB, I suspect I am trying to read a these into memory in entirety. Perhaps there is no way to tune this? Cheers, james On Monday, 19 January 2015, Kyotaro HORIGUCHI < horig

Re: [GENERAL] Simple Atomic Relationship Insert

On 1/16/2015 2:41 AM, Jim Nasby wrote: On 1/15/15 10:57 PM, Roxanne Reid-Bennett wrote: try this: (if you still get deadlocks, uncomment the advisory lock [thanks Daniel] and try again) Logically I suppose it might run faster to do the select, then insert "if". I almost always write these a

Re: [GENERAL] Partitioning

Hello, an 2015 14:13:37 +1100, James Sewell wrote in > Sadly not ... I still hit all the tables. | 5.9.4. Partitioning and Constraint Exclusion http://www.postgresql.org/docs/9.4/static/ddl-partitioning.html Constraint exclusion is a mechanism to omit tables that are known to have no hit by

Re: [GENERAL] Partitioning

Sadly not ... I still hit all the tables. Cheers, James Sewell, PostgreSQL Team Lead / Solutions Architect __ Level 2, 50 Queen St, Melbourne VIC 3000 *P *(+61) 3 8370 8000 *W* www.lisasoft.com *F *(+61) 3 8370 8099 On Mon, Jan 19, 2015 at 1:54 PM, J

Re: [GENERAL] Partitioning

On 1/18/2015 5:58 PM, James Sewell wrote: WITH idlist as (SELECT id from othertable) SELECT id from mastertable WHERE id = idlist.id ); select mt.id, ... from mastertable mt join othertable ot on mt.id=ot.id; might optimize better. -- john r pierce

[GENERAL] Partitioning

Hello, I am using partitioning with around 100 sub-tables. Each sub-table is around 11GB and partitioned on the 'id' column. I have an index on the id column on each sub-table. Is it possible to get a query like the following working using constraint exclusion, or am I doomed to do index/sequenti

Re: [GENERAL] Any changes in Java and PGSQL 9.4?

On Sun, 18 Jan 2015 20:25:48 +0100 Thomas Kellerer wrote: > Bjørn T Johansen wrote on 18.01.2015 20:20: > > Just noticed that a column field of type bigint containing a null, becomes > > a 0 when retrieving it from the resultset using JDBC. > > If I run the same application against my old 9.3 da

Re: [GENERAL] Any changes in Java and PGSQL 9.4?

On Sun, 18 Jan 2015 20:20:35 +0100 Bjørn T Johansen wrote: > Just noticed that a column field of type bigint containing a null, becomes a > 0 when retrieving it from the resultset using JDBC. > If I run the same application against my old 9.3 database, the value > retrieved is a null > >

Re: [GENERAL] Any changes in Java and PGSQL 9.4?

Bjørn T Johansen wrote on 18.01.2015 20:20: Just noticed that a column field of type bigint containing a null, becomes a 0 when retrieving it from the resultset using JDBC. If I run the same application against my old 9.3 database, the value retrieved is a null You need to show us some

[GENERAL] Any changes in Java and PGSQL 9.4?

Just noticed that a column field of type bigint containing a null, becomes a 0 when retrieving it from the resultset using JDBC. If I run the same application against my old 9.3 database, the value retrieved is a null Regards, BTJ -- --

Re: [GENERAL] Surrogate pairs in UTF-8

Martijn van Oosterhout writes: > On Fri, Jan 16, 2015 at 08:16:47AM -0600, Dave Rosckes wrote: >> I have written a test program using postgres that creates a string with a >> surrogate pair. I then insert that string into a varchar property in a >> table. >> >> I then execute a select statement

Re: [GENERAL] Alternatives to a unique indexes with NULL

On Sat, Jan 17, 2015 at 02:03:34PM +0100, Andreas Kretschmer wrote: > Peter Hicks wrote: > > > All, > > > > I have a Rails application on 9.3 in which I want to enforce a unique > > index on a set of fields, one of which includes a NULL-able column. > > > > According to > > http://www.postgre

Re: [GENERAL] Surrogate pairs in UTF-8

On Fri, Jan 16, 2015 at 08:16:47AM -0600, Dave Rosckes wrote: > I have written a test program using postgres that creates a string with a > surrogate pair. I then insert that string into a varchar property in a > table. > > I then execute a select statement to pull the string out. But when I > e

Re: [GENERAL] PG user group in the Kuala Lumpur area?

On 15/01/18 23:12, Torsten Förtsch wrote: > Hi, > > I was looking for a PG user group around KL. I know there is one in > Singapore. As it happens, Chris Travers, the PG contact for Malaysia is > a friend of mine. So, I asked him. He wasn't aware of one either. > However, he very much appreciated

Re: [GENERAL] Can pg_restore produce create or replace commands

On 01/17/2015 06:01 PM, Berend Tober wrote: Thomas Kellerer wrote: Berend Tober wrote on 17.01.2015 19:05: I often work with the output of pg_restore from a custom format dump file. ... Most often, I'm refactoring functions and so don't really want to drop the function but rather want to do a

[GENERAL] PG user group in the Kuala Lumpur area?

Hi, I was looking for a PG user group around KL. I know there is one in Singapore. As it happens, Chris Travers, the PG contact for Malaysia is a friend of mine. So, I asked him. He wasn't aware of one either. However, he very much appreciated the idea of founding one. I know there are lots of PG

Re: [GENERAL] WAL supported extension

Hi, In "Re: [GENERAL] WAL supported extension" on Sun, 18 Jan 2015 15:15:51 +0900, Michael Paquier wrote: >> (Is this mailing list right mailing list for asking this >> question...?) > Hackers would have been fine as well. Thanks for your advice. I'll use hackers mailing list at the next t

Re: [GENERAL] sslcompression / PGSSLCOMPRESSION not behaving as documented?

On Fri, Jan 16, 2015 at 08:41:54AM -0800, Adrian Klaver wrote: > Yes that would seem to be the issue: > > https://launchpad.net/ubuntu/trusty/+source/openssl/+changelog > > openssl (1.0.1e-3ubuntu1) > > Disable compression to avoid CRIME systemwide (CVE-2012-4929). FWIW, it's likely that the ne

Re: [GENERAL] WAL supported extension

On Sun, Jan 18, 2015 at 2:01 PM, Michael Paquier wrote: > Oleg Bartunov wrote: > > We are eager for development of this API. > Yeah, me too actually :) Oleg, are there plans on your side to do > something in this area for 9.6? > Yes, Alexander Korotkov will continue working on this. Are you comi

Re: [GENERAL] WAL supported extension

Oleg Bartunov wrote: > We are eager for development of this API. Yeah, me too actually :) Oleg, are there plans on your side to do something in this area for 9.6? -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po

Re: [GENERAL] WAL supported extension

On Sun, Jan 18, 2015 at 9:15 AM, Michael Paquier wrote: > On Sat, Jan 17, 2015 at 11:18 PM, Kouhei Sutou wrote: > > (Is this mailing list right mailing list for asking this > > question...?) > Hackers would have been fine as well. > > > Is there any plan to implement PostgreSQL API to implement