Here is some more information.
Size of database:
du -sh /var/lib/pgsql/data/base/*
4,1M/var/lib/pgsql/data/base/1
4,1M/var/lib/pgsql/data/base/10792
4,1M/var/lib/pgsql/data/base/10793
9,1M/var/lib/pgsql/data/base/16388
11M /var/lib/pgsql/data/base/19233
1,6G
A B [EMAIL PROTECTED] writes:
I'm not sure what the size acctually is... But I can't imagine that it
is 1,6 GB!!! I'd say I have 11MB of data in it...
Sounds like you've got a rather severe case of table and/or index bloat.
This is typically caused by not vacuuming often enough.
The easiest
So, it is time to improve performance, it is running to slow.
AFAIK (as a novice) there are a few general areas:
1) hardware
2) rewriting my queries and table structures
3) using more predefined queries
4) tweek parameters in the db conf files
Of these points:
1) is nothing I can do about right
1) hardware
2) rewriting my queries and table structures
3) using more predefined queries
4) tweek parameters in the db conf files
Of these points:
1) is nothing I can do about right now, but in the future perhaps.
2) will be quite hard right now since there is more code than time.
A B wrote:
So, it is time to improve performance, it is running to slow.
AFAIK (as a novice) there are a few general areas:
1) hardware
2) rewriting my queries and table structures
3) using more predefined queries
4) tweek parameters in the db conf files
Of these points:
1) is nothing I can do
A B wrote:
So, it is time to improve performance, it is running to slow.
AFAIK (as a novice) there are a few general areas:
1) hardware
2) rewriting my queries and table structures
3) using more predefined queries
4) tweek parameters in the db conf files
Of these points:
1) is nothing I can do
[EMAIL PROTECTED] (A B) writes:
So, it is time to improve performance, it is running to slow.
AFAIK (as a novice) there are a few general areas:
1) hardware
2) rewriting my queries and table structures
3) using more predefined queries
4) tweek parameters in the db conf files
Of these
You got the order slightly wrong I guess.
1) hardware
Would only come first if your RAM is really too small, or you use RAID5
on write-heavy tables, or what limits you is transaction fsync (hint :
8.3).
Adding RAM is cheap.
2) rewriting my queries and table structures
