From: | "Fernando Papa" <fpapa(at)claxson(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | tuplestore: write failed |
Date: | 2002-10-16 16:37:02 |
Message-ID: | CB94A4924490EC4A81EDA55BA378B7BA28366E@exch2k01.buehuergo.corp.claxson.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All!
I'm working on postgres for the last 3 weeks. I'm trying to port several
applications from oracle to postgres. I load all the tables and now I'm
testing performance issues. Today, when I execute a very heavy query,
the query abort (no message on client) in about 20/30 minutes. In
server's logfile I found this:
2002-10-16 11:53:25 ERROR: tuplestore: write failed
I run again the query an I get the same error.
I check the disk space... everithing ok.
I did several modifications on postgres.conf:
tcpip_socket = true
shared_buffers = 16384
wal_buffers = 16
sort_mem = 512
vacuum_mem = 16384
wal_files = 4 # range 0-64
checkpoint_segments = 3
fsync=false
enable_seqscan = true
enable_indexscan = true
enable_tidscan = true
enable_sort = true
enable_nestloop = true
enable_mergejoin = true
enable_hashjoin = true
geqo = true
geqo_selection_bias = 2.0
geqo_threshold = 11
geqo_pool_size = 0
geqo_effort = 1
geqo_generations = 0
geqo_random_seed = -1
stats_start_collector = true
stats_reset_on_server_start = true
stats_command_string = true
I create several indexes after data load, and then run vacuum -z.
But I can't find any references for this error!
If anybody can guide me...
thanks in advance
--
Fernando
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-10-16 16:47:04 | Re: transactions |
Previous Message | Ross J. Reedstrom | 2002-10-16 16:10:32 | Re: [ADMIN] Fast Deletion For Large Tables |