> The Linux server is on a cloud and has 4GB RAM and 2 CPUs and the
> same server is running both master and slave (these are separate in
> production). If you'd like any more details please ask. Here are the
> pgbench results:
Presumably you created a new cloud server for 9.2, yes? I'd guess th
Folks,
In the past, setting vacuum_freeze_min_age (vfma) really low (say to
1 or 5) would have caused lots of extra writing work due to
dirtying extra pages for freezing. This has been our stated reason to
keep vfma high, despite the obvious advantage of freezing tuples while
they're stil
(following the interest from -hackers, I'm posting this here).
Hi folks,
I've always been fascinated with genetic algorithms. Having had a chance to
implement it once before, to solve real life issue - I knew they can be
brilliant at searching for right solutions in multi dimensional space.
I basically don't have any control over the generated select statement.
I'm using Mondrian and that is the select statement that gets passed to
Postgres. You're right that if you remove the count(id), the query is
faster but I can't do that since the select statement is being executed
from Mondri
On Sat, Mar 23, 2013 at 3:27 PM, Misa Simic wrote:
> Hi Jeff,
>
> It seems my previous mail has not showed up in the list... copied/pasted
> again belloew
>
> However, you said something important:
>
> "The join to the "state" table is not necessary. Between the foreign key
> and the primary key
Hi,
I recently upgraded PostgreSQL from 9.0.12 to 9.2.3 on a test server to compare
performance. I'm using pgbench to measure which results in around a 60%
reduction.
The non-default configuration remains identical between versions except
archive_command (different location) and custom_variab
