On Sun, Dec 6, 2009 at 12:09 PM, Andres Freund wrote:
> I know of several instances running with a larger fsm_pages - you could try to
> reduce the fsm_relations setting - I dont know if there are problems lurking
> with such a oversized value.
I run a db with 10M max_fsm_pages and 500k max_fam_r
On Sunday 06 December 2009 19:20:17 Andreas Thiel wrote:
> Hi Andres,
>
> Thanks a lot for your answers. As bottom line I think the answer is I
> have to rethink my DB structure.
Can't answer that one without knowing much more ;)
> > Could you please properly quote the email? The way you did it i
Hi Andreas,
Could you please properly quote the email? The way you did it is quite
unreadable because you always have to guess who wrote what.
On Sunday 06 December 2009 17:06:39 Andreas Thiel wrote:
> > I'm going to work on the table size of the largest table (result_orig)
> > itself by elimina
Craig Ringer wrote:
### My Issue No. 1: Index Size
Is such disk usage for indexes expected? What can I do to optimize? I
could not run yet a VACUUM on result_orig, as I hit into max_fsm_pages
limit
You'll like 8.4 then, as you no longer have to play with max_fsm_pages.
The fact that you're hitt
On 5/12/2009 7:03 AM, Andreas Thiel wrote:
Hi All,
Maybe some questions are quite newbie ones, and I did try hard to scan
all the articles and documentation, but I did not find a satisfying
answer.
### My Issue No. 1: Index Size
Is such disk usage for indexes expected? What can I do to optim
On Fri, Dec 4, 2009 at 4:03 PM, Andreas Thiel wrote:
> Hi All,
>
> Maybe some questions are quite newbie ones, and I did try hard to scan
> all the articles and documentation, but I did not find a satisfying
> answer.
>
> I'm running PostgreSQL 8.3.6 on a 32-Bit Centos 4 machine (which I
> probabl
Hi,
On Saturday 05 December 2009 00:03:12 Andreas Thiel wrote:
> I'm running PostgreSQL 8.3.6 on a 32-Bit Centos 4 machine (which I
> probably should update to 64 Bit soon)
How much memory?
> I'm going to work on the table size of the largest table (result_orig)
> itself by eliminating columns,
Hi All,
Maybe some questions are quite newbie ones, and I did try hard to scan
all the articles and documentation, but I did not find a satisfying
answer.
I'm running PostgreSQL 8.3.6 on a 32-Bit Centos 4 machine (which I
probably should update to 64 Bit soon)
I have some tables which tend