Re: Postgresql Write cluster needed

2014-11-21 12:56 GMT+01:00 Sergei Sheinin <sergei(dot)sheinin(at)gmail(dot)com>:

> It may be possible to write to text files then use COPY command for bulk
> inserts.
>
> On Fri, Nov 21, 2014 at 6:38 PM, Mario Splivalo <mario(at)splivalo(dot)hr> wrote:
>
>> Unless you shard (partition) your data, writes can't be scaled.
>>
>> Mario
>>
>>
>> On November 21, 2014 12:29:38 PM CET, fahad basheer <
>> fahad(dot)a(dot)basheer(at)gmail(dot)com> wrote:
>>>
>>> Hi ALL,
>>>
>>> I need to scale postgresql with write capabilities, please help me.
>>>
>>> Regards
>>> Fahad
>>>
>>
>> --
>> Sent from my Android device with K-9 Mail. Please excuse my brevity.
>>
>
>

Hi,
I think we need more informations about this problem and how it's
the enviroment (OLTP, dwh ? ) . For example if some tables not need to be
full ACID you could use unlogged table or for example you could relax the
durability of the commit , disabling synchronous commit .

Regards

--
Matteo Durighetto

- - - - - - - - - - - - - - - - - - - - - - -

Italian PostgreSQL User Group <http://www.itpug.org/index.it.html>
Italian Community for Geographic Free/Open-Source Software
<http://www.gfoss.it>