"vinita bansal" <[EMAIL PROTECTED]> writes:
> Also, a particular query which was taking a min or less with postgres 7 is
> taking 15 mins now.
> Here is the query plan for the query both for postgres 7.4.6 and postgres 8:
It's hard to say anything about this when you only provided EXPLAIN and
not
"vinita bansal" <[EMAIL PROTECTED]> writes:
> Can you please provide details on the relationship between work_mem and
> maintenance_work_mem (Postgres doc specifies that the value for maintenance
> work_mem should be larger but I am not clear on why that should be so)
Because the other way doesn
all settings, I am not too sure on
why it should be a problem and how in any way it can affect me?
Also can you clarify what max_fsm_pages,bg_writer actually is since it is
not clear from the documentation. Won't turning bg_writer on affect my
overall run. I am too bothered about that since I
"vinita bansal" <[EMAIL PROTECTED]> writes:
> Do these settings seem fine or I am making some mistake. These settings when
> used with Postgres 7.4 gave me good results but they don't seem to work with
> Postgres 8.0. Am I missing out on something??
Define "don't seem to work", please.
Offhand
On Thu, 10 Mar 2005 09:58:02 +, vinita bansal <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a 64 bit Opteron m/c with 32GB RAM and ~500GB HardDrive. The database
> size is ~45GB.
>
I've got a similar box, but with only 16G RAM. What is the storage
subsystem, fibre channel or SCSI? Also, what
