Bruce Momjian wrote:
> Greg Smith wrote:
> > Kevin Grittner wrote:
> > > I assume that we send a full
> > > 8K to the OS cache, and the file system writes disk sectors
> > > according to its own algorithm. With either platters or BBU cache,
> > > the data is persisted on fsync; why do you see a ri
I think this might be a game changing feature.
For the first time after 10 years I have reason to consider MySQL, as the
cost per performance in such scenario is amazing. Morever I wont have to run
it in single mod or loose other functionality by using this feautre. as I
can access the ordinary int
On Wed, 22 Dec 2010 14:17:21 +0100, Michael Ben-Nes
wrote:
Thanks, it is most interesting
--
Michael Ben-Nes - Internet Consultant and Director.
http://www.epoch.co.il - weaving the Net.
Cellular: 054-4848113
-
Hi.
I install auto_explain module for monitoring queries.
By the way, is any tool to tune planner automatically ?
pasman
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-per
=?ISO-8859-2?Q?pasman_pasma=F1ski?= writes:
> Thanks for reply.
> I tested random changes and query runs fastest after:
> set seq_page_cost = 0.1;
> set random_page_cost = 0.1;
> cpu_operator_cost = 0.01
As a general rule, "optimizing" those settings on the basis of testing a
single query is a g
Guillaume Cottenceau wrote:
> If I'm correct, you're basically telling postgresql that your
> disk is unusually fast compared to your CPU. Even if some queries
> will run faster from a side-effect of these settings, you're
> likely to create other random problems...
If this is set globally and
On Wed, Dec 22, 2010 at 6:28 AM, tuanhoanganh wrote:
> As far as i know, Pgbouncer can help to minimum connect to postgresql, I
> want tool can open and keep 200 connect to postgresql (be cause start new
> connect to postgresql in windows very slow, i want it open 200 connect in
> first time and
As far as i know, Pgbouncer can help to minimum connect to postgresql, I
want tool can open and keep 200 connect to postgresql (be cause start new
connect to postgresql in windows very slow, i want it open 200 connect in
first time and my application connect to this tool)
Is there any tool like th
On Tue, Dec 21, 2010 at 11:09, Michael Ben-Nes wrote:
> Just stumbled on the following post:
> http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-story-for.html
>
> The post claim that MySQL can do more qps then MemCahed or any other NoSQL
> when doing simple queries like: SELECT
pasman pasmański writes:
> Thanks for reply.
> I tested random changes and query runs fastest after:
>
> set seq_page_cost = 0.1;
> set random_page_cost = 0.1;
> cpu_operator_cost = 0.01
If I'm correct, you're basically telling postgresql that your
disk is unusually fast compared to your CPU. Ev
Thanks for reply.
I tested random changes and query runs fastest after:
set seq_page_cost = 0.1;
set random_page_cost = 0.1;
cpu_operator_cost = 0.01
pasman
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://
On Tue, Dec 21, 2010 at 2:09 AM, Michael Ben-Nes wrote:
> Hi,
>
> Just stumbled on the following post:
> http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-story-for.html
>
> The post claim that MySQL can do more qps then MemCahed or any other NoSQL
> when doing simple queries lik
Do you mean I should use PREPARE?
Currently I use PHP to access the DB which use libpq. Is that cosidered a
fast call API ? if not, can you please refer me to the right info.
PHP pg_pconnect command open a persistent PostgreSQL connection. Is it
enough or I better use PgPool2 or something sim
13 matches
Mail list logo
