2016-07-12 8:54 GMT-03:00 Miguel Ramos :
>
> Às 12:32 de 12-07-2016, Felipe Santos escreveu:
>
>> I would try lowering max_connections to 50 and then set work_mem to 128MB.
>>
>> After that restart your server and retry the restore.
>>
>
> Ok, I will tr
2016-07-12 8:25 GMT-03:00 Miguel Ramos :
>
> Hi,
>
> We have backed up a database and now when trying to restore it to the same
> server we get this:
>
> > # pg_restore -d recovery /mnt/paysdeloire2013_convertida2.1.dump
> > pg_restore: [custom archiver] out of memory
> > 12:09:56.58 9446.593u+12
2016-06-02 14:23 GMT-03:00 Steve Crawford :
> Something like:
>
> select max(id) from yourtable where sts=0 and ref_id is null;
>
> That assumes that ref_id is null. It would help to see your table
> structure and the query you tried that doesn't work. If ref_id is actually
> a character string th
2016-02-15 15:40 GMT-02:00 Melvin Davidson :
>
>
> On Tue, Feb 9, 2016 at 1:57 AM, subhan alimy wrote:
>
>> Hello Everyone,
>>
>> I want to upgrade PostgreSQL 9.1 to PostgreSQL 9.4, currently my database
>> hold millions of records, shall anyone please help me the recommend steps
>> to
>> upgrade
2016-01-28 16:33 GMT-02:00 Igor Neyman :
>
>
> *From:* pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] *On Behalf Of *Felipe Santos
> *Sent:* Thursday, January 28, 2016 1:17 PM
> *To:* Joshua D. Drake
> *Cc:* Melvin Davidson ; David
2016-01-28 16:03 GMT-02:00 Joshua D. Drake :
> On 01/28/2016 09:41 AM, Melvin Davidson wrote:
>
>> So, IOW, and the answer to my question is yes, it should be insured that
>> all pages involved are physically adjacent (by design or by pre-sort)
>> before creating a BRIN on them.
>> Further to the
Hi,
> I want to ask a question about json index.
> Can I make a index on a field of a json column?
> e.g, for table 'json_tab' you given, can I run something like "create
> index 'json_index' on json_tab::key"?
>
Yes.
Here it is an example:
http://stackoverflow.com/questions/17807030/how-to-crea
