On Mon, Jun 12, 2006 at 11:26:23AM +0530, Gourish Singbal wrote:
> Where is the pgsql_tmp folder present ?. i am unable to see it in the data
> directory of postgresql.
It will be under the *database* directory, under $PGDATA/base. SELECT
oid,* FROM pg_database; will tell you what directory to lo
Where is the pgsql_tmp folder present ?. i am unable to see it in the data directory of postgresql.
~gourish
On 6/9/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
On Fri, Jun 09, 2006 at 02:23:04PM +0200, Domenico - Sal. F.lli Riva wrote:> Hello,>> During insert or update, potgresql write in pg
On Fri, Jun 09, 2006 at 02:23:04PM +0200, Domenico - Sal. F.lli Riva wrote:
> Hello,
>
> During insert or update, potgresql write in pgsql_tmp directory and so
> performance are very poor.
pgsql_tmp is used if a query runs out of work_mem, so you can try
increasing that.
> My configuration is:
>
Hello,
During insert or update, potgresql write in pgsql_tmp directory and so
performance are very poor.
My configuration is:
Work mem10240
Effective_cache_size 3
Shared buffers 9000
Max_fsm_pages 35000
Wal Buffers
