On 12/08/2011 8:03 AM, Waldo Nell wrote:
I have PostgreSQL 8.4.8 on Ubuntu Linux x64. Server is a Core i7 950 with 6GB
of RAM. 2GB of RAM us used by Java, some small amount by the kernel / services
and the rest is available to PostgreSQL. Hard drive is a single 7200 RPM SATA
1TB Caviar Blac
On 08/11/2011 07:35 PM, Waldo Nell wrote:
Please explain why the system is slower with the recommended values for these
two settings?
If the other parameters are at their defaults, the server is probably
executing a checkpoint every few seconds running your test. I'd wager
your log is fille
On 2011-08-11, at 17:18 , k...@rice.edu wrote:
> One guess is that you are using the defaults for other costing parameters and
> they
> do not accurately reflect your system. This means that it will be a crap
> shoot as
> to whether a plan is faster or slower and what will affect the timing.
O
On Thu, Aug 11, 2011 at 04:35:34PM -0700, Waldo Nell wrote:
> I have PostgreSQL 8.4.8 on Ubuntu Linux x64. Server is a Core i7 950 with
> 6GB of RAM. 2GB of RAM us used by Java, some small amount by the kernel /
> services and the rest is available to PostgreSQL. Hard drive is a single
> 7200
I have PostgreSQL 8.4.8 on Ubuntu Linux x64. Server is a Core i7 950 with 6GB
of RAM. 2GB of RAM us used by Java, some small amount by the kernel / services
and the rest is available to PostgreSQL. Hard drive is a single 7200 RPM SATA
1TB Caviar Black HDD. No other applications / processes a
I have PostgreSQL 8.4.8 on Ubuntu Linux x64. Server is a Core i7 950 with 6GB
of RAM. 2GB of RAM us used by Java, some small amount by the kernel / services
and the rest is available to PostgreSQL. Hard drive is a single 7200 RPM SATA
1TB Caviar Black HDD. No other applications / processes a
Hi all,
I'm testing Streamin replication with one hot standby node and I'm
experiencing high delay of hot standby node.
When I reach aprox. 50 transactions per second where every transaction
includes only simple "UPDATE status SET number = number + 1 WHERE name =
'iterations'", the standby ser
Grzegorz Blinowski wrote:
> A small followup regarding the suggestion to turn off compression
> - I used:
>
> ALTER TABLE archive_tender ALTER COLUMN subject SET STORAGE
> EXTERNAL
>
> to turn off compression, however I get an impression that "nothing
> happend". When exactly this alteration t
A small followup regarding the suggestion to turn off compression - I used:
ALTER TABLE archive_tender ALTER COLUMN subject SET STORAGE EXTERNAL
to turn off compression, however I get an impression that "nothing happend".
When exactly this alteration takes effect? Perhaps I should reload the
enti
