Re: [GENERAL] Manipulating jsonb

No way, Andreas ! But, we hope, Dimitri will release his extension before 9.4, so anybody could install it. Oleg On Sat, May 3, 2014 at 1:21 AM, Andreas Heiduk wrote: > Hello Oleg, > > how are the odds that the '||' and '-' operators from jsonbx will be > included in the public 9.4 release? > >

Re: [GENERAL] Full text: Ispell dictionary

Hi Oleg Haha, understood! Thanks for helping me on this one. Cheers Tim On May 3, 2014 7:24:08 AM GMT+09:00, Oleg Bartunov wrote: >Tim, > >you did answer yourself - don't use ispell :) > >On Sat, May 3, 2014 at 1:45 AM, Tim van der Linden >wrote: >> On Fri, 2 May 2014 21:12:56 +0400 >> Oleg B

Re: [GENERAL] Full text: Ispell dictionary

Tim, you did answer yourself - don't use ispell :) On Sat, May 3, 2014 at 1:45 AM, Tim van der Linden wrote: > On Fri, 2 May 2014 21:12:56 +0400 > Oleg Bartunov wrote: > > Hi Oleg > > Thanks for the response! > >> Yes, it's normal for ispell dictionary, think about morphological dictionary. > >

Re: [GENERAL] Full text: Ispell dictionary

On Fri, 2 May 2014 21:12:56 +0400 Oleg Bartunov wrote: Hi Oleg Thanks for the response! > Yes, it's normal for ispell dictionary, think about morphological dictionary. Hmm, I see, that makes sense. I thought the morphological aspect of the Ispell only dealt with splitting up compound words, b

Re: [GENERAL] Timeouts after upgrade from 9.0 to 9.3

On 05/02/2014 10:46 AM, gvim wrote: I've just upgraded a server from 9.0 to 9.3 using the pgupgrade.sh script and setup the same config but now, when I connect with the latest pgAdmin III I get a timeout after leaving the connection open for a few minutes. Where can I diagnose this fault? A lo

Re: [GENERAL] Vacuuming strategy

On Wed, Apr 30, 2014 at 10:49 AM, Elanchezhiyan Elango wrote: > >> Each table has 4 indices. The updates are to the indexed columns. >> >> Here is the schema of a table: http://pastebin.com/ffu0dUjS All tables >> have this same schema except that some tables don't have a port column and >> so wil

Re: [GENERAL] Manipulating jsonb

Andreas, take a look on https://github.com/erthalion/jsonbx. This is a place, where all hstore functionality will be eventually ported. See this table - https://gist.github.com/erthalion/10890778 Oleg On Fri, May 2, 2014 at 10:32 PM, Andreas Heiduk wrote: > Hello, > > I'm playing with a 9.4 pre

Re: [GENERAL] Vacuuming strategy

On Wed, Apr 30, 2014 at 10:45 AM, Elanchezhiyan Elango wrote: > Missed to answer this one: > >> Is the 5GB for the table plus indexes, or just the table itself? > > No it's not including the the indices. Including indices it's actually > 17GB!! > Is it one particular index that is bloated? Che

Re: [GENERAL] Vacuuming strategy

On Wed, Apr 30, 2014 at 10:40 AM, Elanchezhiyan Elango wrote: > > > Why do you have a 4 minute timeout? That seems counter-productive. > > Oh, Is it less or more? > I would not have timeouts on maintenance operations at all. To me a statement timeout is a last ditch method to deal with a rec

[GENERAL] Manipulating jsonb

Hello, I'm playing with a 9.4 preview and the upcoming jsonb datatype. But I'm missing the basic modification syntax. Given the following situation: CREATE TABLE test(key int, jsonval jsonb); INSERT INTO test VALUES(1, '{"a": 1, "c": 3}'); How can I UPDATE that row with '{"b": 2, "d": 4

[GENERAL] Optimize query for listing un-read messages

Hi all,   I have a schema where I have lots of messages and some users who might have read some of them. When a message is read by a user I create an entry i a table message_property holding the property (is_read) for that user.   The schema is as follows:   drop table if exists message_property;

[GENERAL] Timeouts after upgrade from 9.0 to 9.3

I've just upgraded a server from 9.0 to 9.3 using the pgupgrade.sh script and setup the same config but now, when I connect with the latest pgAdmin III I get a timeout after leaving the connection open for a few minutes. Where can I diagnose this fault? gvim -- Sent via pgsql-general mailin

Re: [GENERAL] Full text: Ispell dictionary

Yes, it's normal for ispell dictionary, think about morphological dictionary. On Fri, May 2, 2014 at 11:54 AM, Tim van der Linden wrote: > Good morning/afternoon all > > I am currently writing a few articles about PostgreSQL's full text > capabilities and have a question about the Ispell diction

Re: [GENERAL] Backups over slave instead master?

On 05/02/2014 09:46 AM, Edson Richter wrote: Yes, backup = pg_dump. Can I use it on slave even on 9.2.7? Yes. The reason I suggested 9.3 was assuming you were using pg_basebackup, rsync, or a similar tool to backup the database binaries. You should be fine with pg_dump. -- Shaun Thomas Opt

Re: [GENERAL] Backups over slave instead master?

Em 01/05/2014 16:39, bricklen escreveu: On Thu, May 1, 2014 at 8:54 AM, Shaun Thomas > wrote: On 05/01/2014 10:31 AM, Edson Richter wrote: I'm wondering if would be possible to execute these backups in the slave server instead, so I

Re: [GENERAL] break table into portions for writing to separate files

Hi Seb: On Thu, May 1, 2014 at 8:50 PM, Seb wrote: > Thanks, I'm glad to hear you've used this approach successfully. Well, this is always successful if you are able to develop a moderately complex script. > It seems as though the best solution is to do a single SELECT to get the > data out of

[GENERAL] Full text: Ispell dictionary

Good morning/afternoon all I am currently writing a few articles about PostgreSQL's full text capabilities and have a question about the Ispell dictionary which I cannot seem to find an answer to. It is probably a very simple issue, so forgive my ignorance. In one article I am explaining about