Hi,
I have a read heavy application. I would want it to read from memory as
database latency has to be in low milliseconds.
The database is not too big in size and can be fully contained in memory.
With Postgres, if I cache all the tables (by pre-emptive querying such as
select * from tables); i
On 09/19/2012 09:36 AM, A J wrote:
Hi,
I have a read heavy application. I would want it to read from memory
as database latency has to be in low milliseconds.
The database is not too big in size and can be fully contained in memory.
With Postgres, if I cache all the tables (by pre-emptive quer
We've had a system in operation for a few years that makes use of a substantial
amount of partitioning. The parent table now has over 4,000 children tables.
Within the last couple of days the server started giving "out of shared memory"
errors with the suggestion to increase the max_locks_per_tr
Michael Holt writes:
> We've had a system in operation for a few years that makes use of a
> substantial amount of partitioning. The parent table now has over 4,000
> children tables. Within the last couple of days the server started giving
> "out of shared memory" errors with the suggestion to
Thanks Tom. In the original plan a query of this sort was never supposed to
happen, but it looks like some coding issues may have allowed it.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: September-19-12 2:04 PM
To: Michael Holt
Cc: pgsql-admin@postgresql.org
Subje
Hi, I'm using PostgreSQL 9.0.4, with the replication activated to one server.
About 3 weeks ago, we have a disk space problem on both servers. I recovered
the DB but since then (or at least had not noticed before), in 10 executions
of functions that generate temporary tables, 3 returns the foll
=?iso-8859-1?Q?Rub=E9n_Crespo_Flores?= writes:
> Hi, I'm using PostgreSQL 9.0.4, with the replication activated to one server.
> About 3 weeks ago, we have a disk space problem on both servers. I recovered
> the DB but since then (or at least had not noticed before), in 10 executions
> of funct
We have a database of around 700Gb ... its fairly busy with a lot of small
transactions.
We generate some times near 100Gb of WAL files per day, this seems like a
lot !! We are looking at a secondary data center for DR so the connection
would need a large amount of bandwidth based on this volume.
On 09/20/2012 12:36 AM, A J wrote:
Hi,
I have a read heavy application. I would want it to read from memory as
database latency has to be in low milliseconds.
The database is not too big in size and can be fully contained in memory.
With Postgres, if I cache all the tables (by pre-emptive queryi