Am 14.11.2012 04:19, schrieb Tom Lane:
Craig Ringer writes:
On 11/14/2012 06:12 AM, Aaron Bono wrote:
Am I reading this right? Are there individual connections using over
300 MB or RAM by themselves?
If I recall correctly, RSS is charged against a PostgreSQL back-end when
it touches `shared_
Craig Ringer writes:
> On 11/14/2012 06:12 AM, Aaron Bono wrote:
>> Am I reading this right? Are there individual connections using over
>> 300 MB or RAM by themselves?
> If I recall correctly, RSS is charged against a PostgreSQL back-end when
> it touches `shared_buffers`. So that doesn't neces
On 11/14/2012 06:12 AM, Aaron Bono wrote:
>
> USER PID %CPU %MEMVSZ RSS TTY STAT START TIME COMMAND
>
> postgres 3523 0.5 1.0 426076 313156 ? Ss 08:44 2:42 \_
> postgres: myuser my_db 192.168.1.2(39786) idle
>
I have been struggling with an issue on our database server lately with
Postgres crashing our server by taking up too much RAM. To alleviate this
problem, I just upgraded from a 6 GB RAM server to a new 32 GB RAM server.
The new server is running Ubuntu 10 with nothing but PostgreSQL 8.4.14
insta
Ronit Allen wrote:
> I have the following query on pg_stat_all_tables to look at updates,
inserts, and deletes:
>
> SELECT relname, n_tup_ins, n_tup_upd, n_tup_del FROM
pg_stat_all_tables;
>
> How can I add a date range to the WHERE clause to show data from a
specified date range?
>
> I don't se
