Benjamin Krajmalnik wrote:
What can be causing this growth? Not vacuuming often enough?
The is exactly the reason.
I hav
pg_autovacuum running every 60 seconds. These tables have 10-15
insert/update statements per second.
You should probably run VACUUM FULL to get the table back to a
Hi,
On Sun, 23 Jul 2006, Benjamin Krajmalnik wrote:
snipp/
The actual number of physical rows in this table is 3404. Row width is
361. Table size = 639 MB.
What can be causing this growth? Not vacuuming often enough? I hav
pg_autovacuum running every 60 seconds. These tables have 10-15
Peter Eisentraut [EMAIL PROTECTED] writes:
Benjamin Krajmalnik wrote:
What can be causing this growth? Not vacuuming often enough?
The is exactly the reason.
I hav
pg_autovacuum running every 60 seconds. These tables have 10-15
insert/update statements per second.
You should probably
Hello,
I see some OS files (50+ GB total) but cannot see
anything in psql -l.
There seem to be some big tables there.
I wonder if there are some tools that would dump the
tables in text.
or, how to make PostgreSQL connect to these files
again?
Thanks in advance!
psql -V
psql (PostgreSQL) 7.2.2
Hello,
Can anyone recommend good reference text, web or other, for general
PostgreSQL DBA tasks.
Stuff like:
* Things to do to clean up periodically (CLUSTER, VACUUM FULL, etc)
* How to analyse queries to optimise data retrieval (Use of EXPLAIN,
etc)
* etc ...
We are running Debian
Hello friend,
Well, I have not a tutorial at hand now, but i can say to you some
tasks i remember, and these can make you spent a long time learning
about how to do.
I think that the tasks essentially you must to know are:
- Install database
- Configure the two most important files
On Mon, Jul 24, 2006 at 08:43:15AM +1000, Mark Matthews wrote:
Can anyone recommend good reference text, web or other, for general
PostgreSQL DBA tasks.
The PostgreSQL documentation is a good place to start. See Server
Administration, especially the chapters concerning routine maintenance,