Thank you a lot, Craig, that's really insightful and exhaustively
complete explanation I've expected!
2011/9/10 Craig Ringer :
> On 10/09/2011 1:55 AM, Antonio Rodriges wrote:
>>
>> Hello,
>>
>> Does anyone know whether PostgreSQL uses DMA (Direct Memory Access) in
>> certain cases to improve netw
Hi Kevin,
First, thanks for taking the time. I wish I could write back with quick,
terse questions to your detailed reply - but I'm sorry, this is still going
to be a wordy post.
>> max_connections = 300
>Too high. Both throughput and latency should improve with correct use of
>a connection pool
Sometimes I read that postgres performance is degraded over the time and
something people talk about backup and restore database solve the problem.
It is really true?
I have postgres 9.0 on a windows machine with The autovacuum is ON
I have some configuration tables
And a couple of tr
On 09/10/2011 11:55 AM, Anibal David Acosta wrote:
Sometimes I read that postgres performance is degraded over the time and
something people talk about backup and restore database solve the problem.
It is really true?
I have postgres 9.0 on a windows machine with The autovacuum is ON
I have s
On Sat, Sep 10, 2011 at 10:55 AM, Anibal David Acosta wrote:
> Sometimes I read that postgres performance is degraded over the time and
> something people talk about backup and restore database solve the problem.
>
> It is really true?
Yes and no. If you let things get out of hand, a backup and
