Having some experience in the point of sale area, you are right to be
concerned. Before I go to inline points, I just want to say that my
experience is that PostgreSQL does an admirable job reliability-wise in
such environments, but it isn't perfect (no software solution can be) and
the problems t
Hi John,
On 5/10/2013 2:55 PM, John R Pierce wrote:
On 5/10/2013 2:11 PM, Bexley Hall wrote:
Having designed (regulated) gaming and "grey area" devices (each
handling hard currency), I can tell you that you have to have already
performed a pretty exhaustive threat analysis (e.g., red team, blue
On Sat, May 11, 2013 at 7:56 AM, Moshe Jacobson wrote:
> I have a master database cluster on one server, and it is configured to
> ship logs via scp to an archive directory on my slave server. The slave
> server is configured for streaming replication, and also is configured to
> delete the archi
On Mon, May 6, 2013 at 4:43 PM, Michael Paquier
wrote:
> On Sat, May 4, 2013 at 5:53 AM, Yang Zhang wrote:
>
>> Yeah, I know that indexes for unlogged tables are unlogged. I was
>> just wondering if you could do this for logged tables. (Safely, such
>> that on crash recovery WAL replay won't th
On 5/11/13, Moshe Jacobson wrote:
> I have a master database cluster on one server, and it is configured to
> ship logs via scp to an archive directory on my slave server. The slave
> server is configured for streaming replication, and also is configured to
> delete the archived xlogs when they ar
I have a master database cluster on one server, and it is configured to
ship logs via scp to an archive directory on my slave server. The slave
server is configured for streaming replication, and also is configured to
delete the archived xlogs when they are no longer needed (using
pg_archivecleanup
On 05/10/2013 11:38 AM, Merlin Moncure wrote:
PostgreSQL configuration changes:
synchronous_commit = off
effective_io_concurrency = 4
checkpoint_segments = 1024
checkpoint_timeout = 10min
checkpoint_warning = 8min
shared_buffers = 32gb
temp_buffers = 128mb
work_mem = 512mb
maintenance_work_mem
On 10 May 2013, at 16:25, David Boreham wrote:
> I've never looked at SLC drives in the past few years and don't know anyone
> who uses them these days.
Because SLCs are still more expensive? Because MLCs are now almost as good as
SLCs for performance/endurance?
I should point out that this d
