Mailinglist Archive: opensuse (911 mails)

< Previous Next >
Re: [opensuse] Best FS fo PostgreSQL/MariaDB
On 12/03/2015 05:31 AM, Stanislav Baiduzhyi wrote:
On Thu, Nov 26, 2015 at 5:36 PM, Anton Aylward
<opensuse@xxxxxxxxxxxxxxxx> wrote:
On 11/25/2015 04:27 AM, Vojtěch Zeisek wrote:
Any other ideas?

Add memory.
Memory is cheaper.
If necessary, upgrade the mobo so you can add more memory.
That may still be cheaper.

Well that will help for reading, but due to ACID every transaction has
to end up written on the drive, not even in kernel or fs cache (or
whatever additional cache layer is involved). Which means that writing
speed is still hard-bound by "random write" of your drive.

In absolute terms that is true, but in practical terms queries, joins
and sorts dominate the activity of a database that is making use of its
relational nature.

If, perhaps, the database is dominated by writes, then really its doing
logging, in which case a relational database is probably not the best
choice for this function.

As I keep saying ...

Context is Everything

Perhaps the OP would care to comment on the nature of the application
that the database is being used for so that you and I don't end up doing
a "yes-but" ping pong game any further.







--
A: Yes.
> Q: Are you sure?
>> A: Because it reverses the logical flow of conversation.
>>> Q: Why is top posting frowned upon?

--
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse+owner@xxxxxxxxxxxx

< Previous Next >
Follow Ups
References