Few words regarding small inserts and a lot of fsyncs:
If it is your problem, you can fix this by using battery-backed raid card.
Similar effect can be reached by turning synchronious commit off. Note
that the latter may make few last commits lost in case of sudden reboot.
But you can at least tes
On Sun, Apr 1, 2012 at 6:11 PM, Andrew Dunstan wrote:
>
>
> On 04/01/2012 08:29 PM, Claudio Freire wrote:
>
>> On Sun, Apr 1, 2012 at 8:54 PM, Andrew Dunstan
>> wrote:
>>
>>> You could try using Unix domain socket and see if the performance
improves. A relevant link:
>>>
>>> He said Wi
On 04/01/2012 09:11 PM, Andrew Dunstan wrote:
On 04/01/2012 08:29 PM, Claudio Freire wrote:
On Sun, Apr 1, 2012 at 8:54 PM, Andrew Dunstan
wrote:
You could try using Unix domain socket and see if the performance
improves. A relevant link:
He said Windows. There are no Unix domain sockets
On Sun, Apr 1, 2012 at 1:24 PM, Ofer Israeli wrote:
> Hi all,
>
> We are running performance tests using PG 8.3 on a Windows 2008 R2 machine
> connecting locally over TCP.
> In our tests, we have found that it takes ~3ms to update a table with ~25
> columns and 60K records, with one column indexed
