segmentation fault

On Wed, 9 Mar 2005 14:28:55 -0300 (ART), marcelo Cortez
<jmdc_marcelo@yahoo.com.ar> wrote:

hello to all
I have the following problem, when making massive
update of a table, I received the message
"segmentation fault" without no other data of the
error in log.
Some idea of because it gives east message?
I am using
gentoo
postgres 7.4.6
dual processor HP proliant
5 gigabyte of ram
147 gigabytes of hd.
47 free .

BTW the column to update is the one of indice gist of
FTS and the table has 22 million registries.
any clue?

You're doing this from within psql or elsewhere? What logging level
are you using? How 'massive' is this update? What kind of parameters
have you set for this database?

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org

Lonni , folks

configuration data: sorry for long response ;)

Linux sume 2.6.9-gentoo-r1 #1 SMP Mon Feb 21 10:46:46
Local time zone
must
be set--see zic i686 Intel(R) Xeon(TM) CPU 2.80GHz
GenuineIntel
GNU/Linux

postgres:
"PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by
GCC gcc (GCC) 3.3.4
20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2,
pie-8.7.6)"

postgresql.conf:

# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
# name = value
#
# (The '=' is optional.) White space may be used.
Comments are
introduced
# with '#' anywhere on a line. The complete list of
option names and #
allowed values can be found in the PostgreSQL
documentation. The #
commented-out settings shown in this file represent
the default values.
#
# Any option can also be given as a command line
switch to the
# postmaster, e.g. 'postmaster -c log_connections=on'.
Some options #
can
be changed at run-time with the 'SET' SQL command.
#
# This file is read on postmaster startup and when the
postmaster
# receives a SIGHUP. If you edit the file on a running
system, you have
#
to SIGHUP the postmaster for the changes to take
effect, or use
# "pg_ctl reload".

#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------

# - Connection Settings -

#tcpip_socket = false
max_connections = 100
# note: increasing max_connections costs about
500 bytes of
shared
# memory per connection slot, in addition to costs
from
shared_buffers # and max_locks_per_transaction.
#superuser_reserved_connections = 2
#port = 5432
#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777 # octal
#virtual_host = '' # what interface to
listen on; defaults
to
any #rendezvous_name = '' # defaults to the
computer name

# - Security & Authentication -

#authentication_timeout = 60 # 1-600, in seconds
#ssl = false
#password_encryption = true
#krb_server_keyfile = ''
#db_user_namespace = false

#---------------------------------------------------------------------------
# RESOURCE USAGE (except WAL)
#---------------------------------------------------------------------------

# - Memory -

shared_buffers = 8192 # min 16, at least
max_connections*2,
8KB
each sort_mem = 8192 # min 64, size in
KB
#vacuum_mem = 8192 # min 1024, size in KB

# - Free Space Map -

#max_fsm_pages = 20000 # min
max_fsm_relations*16, 6 bytes
each
#max_fsm_relations = 1000 # min 100, ~50 bytes
each

# - Kernel Resource Usage -

#max_files_per_process = 1000 # min 25
#preload_libraries = ''

#---------------------------------------------------------------------------
# WRITE AHEAD LOG
#---------------------------------------------------------------------------

# - Settings -

fsync = false # turns forced
synchronization on or
off
#wal_sync_method = fsync # the default varies
across platforms:
# fsync, fdatasync,
open_sync, or
open_datasync
wal_buffers = 40 # min 4, 8KB each

# - Checkpoints -

checkpoint_segments = 9 # in logfile segments,
min 1, 16MB each
#checkpoint_timeout = 300 # range 30-3600, in
seconds
#checkpoint_warning = 30 # 0 is off, in seconds
#commit_delay = 0 # range 0-100000, in
microseconds
#commit_siblings = 5 # range 1-1000

#---------------------------------------------------------------------------
# QUERY TUNING
#---------------------------------------------------------------------------

# - Planner Method Enabling -

#enable_hashagg = true
#enable_hashjoin = true
#enable_indexscan = true
#enable_mergejoin = true
#enable_nestloop = true
#enable_seqscan = true
#enable_sort = true
#enable_tidscan = true

# - Planner Cost Constants -

effective_cache_size = 4000 # typically 8KB each
#random_page_cost = 4 # units are one
sequential page fetch
cost
#cpu_tuple_cost = 0.01 # (same)
#cpu_index_tuple_cost = 0.001 # (same)
#cpu_operator_cost = 0.0025 # (same)

# - Genetic Query Optimizer -

#geqo = true
#geqo_threshold = 11
#geqo_effort = 1
#geqo_generations = 0
#geqo_pool_size = 0 # default based on
tables in statement,
# range 128-1024
#geqo_selection_bias = 2.0 # range 1.5-2.0

# - Other Planner Options -

#default_statistics_target = 10 # range 1-1000
#from_collapse_limit = 8
#join_collapse_limit = 8 # 1 disables
collapsing of explicit
JOINs

#---------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#---------------------------------------------------------------------------

# - Syslog -

#syslog = 0 # range 0-2; 0=stdout;
1=both; 2=syslog
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'

# - When to Log -

#client_min_messages = notice # Values, in order of
decreasing
detail:
# debug5, debug4,
debug3, debug2,
debug1, # log, info, notice, warning,
error

#log_min_messages = debug5 # Values, in order of
decreasing
detail:
# debug5, debug4,
debug3, debug2,
debug1, # info, notice, warning, error,
log, fatal, # panic

#log_error_verbosity = verbose # terse, default, or
verbose messages

#log_min_error_statement = panic # Values in order of
increasing
severity:
# debug5, debug4,
debug3, debug2,
debug1, # info, notice, warning, error,
panic(off)

#log_min_duration_statement = -1 # Log all statements
whose
# execution time
exceeds the value, in
#
milliseconds. Zero prints all queries. #
Minus-one disables.

#silent_mode = false # DO NOT USE without
Syslog!

# - What to Log -

debug_print_parse = true
debug_print_rewritten = true
debug_print_plan = true
debug_pretty_print = true
log_connections = true
log_duration = true
log_pid = true
log_statement = true
log_timestamp = true
log_hostname = true
log_source_port = true

#---------------------------------------------------------------------------
# RUNTIME STATISTICS
#---------------------------------------------------------------------------

# - Statistics Monitoring -

#log_parser_stats = false
#log_planner_stats = false
#log_executor_stats = false
#log_statement_stats = false

# - Query/Index Statistics Collector -

#stats_start_collector = true
#stats_command_string = false
#stats_block_level = false
#stats_row_level = false
#stats_reset_on_server_start = true

#---------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#---------------------------------------------------------------------------

# - Statement Behavior -

#search_path = '$user,public' # schema names
#check_function_bodies = true
#default_transaction_isolation = 'read committed'
#default_transaction_read_only = false
#statement_timeout = 0 # 0 is disabled, in
milliseconds

# - Locale and Formatting -

#datestyle = 'iso, mdy'
#timezone = unknown # actually, defaults
to TZ environment
setting #australian_timezones = false
#extra_float_digits = 0 # min -15, max 2
#client_encoding = sql_ascii # actually, defaults
to database
encoding

# These settings are initialized by initdb -- they may
be changed
lc_messages = 'C' # locale for system
error message
strings
lc_monetary = 'C' # locale for monetary
formatting
lc_numeric = 'C' # locale for number
formatting
lc_time = 'C' # locale for time
formatting

# - Other Defaults -

#explain_pretty_print = true
#dynamic_library_path = '$libdir'
#max_expr_depth = 10000 # min 10

#---------------------------------------------------------------------------
# LOCK MANAGEMENT
#---------------------------------------------------------------------------

#deadlock_timeout = 1000 # in milliseconds
#max_locks_per_transaction = 64 # min 10,
~260*max_connections bytes
each

#---------------------------------------------------------------------------
# VERSION/PLATFORM COMPATIBILITY
#---------------------------------------------------------------------------

# - Previous Postgres Versions -

#add_missing_from = true
#regex_flavor = advanced # advanced, extended,
or basic
#sql_inheritance = true

# - Other Platforms & Clients -

#transform_null_equals = false

machine:

processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2785.226
cache size : 512 KB
physical id : 0
siblings : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8
apic sep mtrr pge
mca
cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss
ht tm pbe cid xtpr
bogomips : 5488.64

processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2785.226
cache size : 512 KB
physical id : 0
siblings : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8
apic sep mtrr pge
mca
cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss
ht tm pbe cid xtpr
bogomips : 5488.64

processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2785.226
cache size : 512 KB
physical id : 0
siblings : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8
apic sep mtrr pge
mca
cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss
ht tm pbe cid xtpr
bogomips : 5488.64

processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2785.226
cache size : 512 KB
physical id : 0
siblings : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8
apic sep mtrr pge
mca
cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss
ht tm pbe cid xtpr
bogomips : 5488.64

memory:

total used free shared
buffers
cached
Mem: 4933972 4930596 3376 0
51848
4318812
-/+ buffers/cache: 559936 4374036
Swap: 1003656 24800 978856

___________________________________________________________
250MB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar

Lonni , folks

You're doing this from within psql or elsewhere?

from putty terminal from windows statiom

What logging level

default i' guest

are you using? How 'massive' is this update?

full , the update statement not have filter clause.

kind of parameters

the update statement call fts function.

have you set for this database?

next email y send this information.
best regards
MDC

___________________________________________________________
250MB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar

From your postgresql.conf it look like you're running with a default
config, which is very likely unsuitable for the dataset and/or usage
patterns that you have. Granted that should not cause a seg fault,
but who knows what kind of weirdness is going on behind the scenes.

I didn't see any info from you on what kind of 'massive' update you're
performing that triggers this behavior, or even confirmation of where
you're seeing it (in psql or elsewhere?). Are you updating all of the
millions of rows at once? What kind of data is this that you're
updating?

On Wed, 9 Mar 2005 16:22:39 -0300 (ART), marcelo Cortez
<jmdc_marcelo@yahoo.com.ar> wrote:

Lonni , folks

configuration data: sorry for long response ;)

Linux sume 2.6.9-gentoo-r1 #1 SMP Mon Feb 21 10:46:46
Local time zone
must
be set--see zic i686 Intel(R) Xeon(TM) CPU 2.80GHz
GenuineIntel
GNU/Linux

postgres:
"PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by
GCC gcc (GCC) 3.3.4
20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2,
pie-8.7.6)"

postgresql.conf:

# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
# name = value
#
# (The '=' is optional.) White space may be used.
Comments are
introduced
# with '#' anywhere on a line. The complete list of
option names and #
allowed values can be found in the PostgreSQL
documentation. The #
commented-out settings shown in this file represent
the default values.
#
# Any option can also be given as a command line
switch to the
# postmaster, e.g. 'postmaster -c log_connections=on'.
Some options #
can
be changed at run-time with the 'SET' SQL command.
#
# This file is read on postmaster startup and when the
postmaster
# receives a SIGHUP. If you edit the file on a running
system, you have
#
to SIGHUP the postmaster for the changes to take
effect, or use
# "pg_ctl reload".

#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------

# - Connection Settings -

#tcpip_socket = false
max_connections = 100
# note: increasing max_connections costs about
500 bytes of
shared
# memory per connection slot, in addition to costs
from
shared_buffers # and max_locks_per_transaction.
#superuser_reserved_connections = 2
#port = 5432
#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777 # octal
#virtual_host = '' # what interface to
listen on; defaults
to
any #rendezvous_name = '' # defaults to the
computer name

# - Security & Authentication -

#authentication_timeout = 60 # 1-600, in seconds
#ssl = false
#password_encryption = true
#krb_server_keyfile = ''
#db_user_namespace = false

#---------------------------------------------------------------------------
# RESOURCE USAGE (except WAL)
#---------------------------------------------------------------------------

# - Memory -

shared_buffers = 8192 # min 16, at least
max_connections*2,
8KB
each sort_mem = 8192 # min 64, size in
KB
#vacuum_mem = 8192 # min 1024, size in KB

# - Free Space Map -

#max_fsm_pages = 20000 # min
max_fsm_relations*16, 6 bytes
each
#max_fsm_relations = 1000 # min 100, ~50 bytes
each

# - Kernel Resource Usage -

#max_files_per_process = 1000 # min 25
#preload_libraries = ''

#---------------------------------------------------------------------------
# WRITE AHEAD LOG
#---------------------------------------------------------------------------

# - Settings -

fsync = false # turns forced
synchronization on or
off
#wal_sync_method = fsync # the default varies
across platforms:
# fsync, fdatasync,
open_sync, or
open_datasync
wal_buffers = 40 # min 4, 8KB each

# - Checkpoints -

checkpoint_segments = 9 # in logfile segments,
min 1, 16MB each
#checkpoint_timeout = 300 # range 30-3600, in
seconds
#checkpoint_warning = 30 # 0 is off, in seconds
#commit_delay = 0 # range 0-100000, in
microseconds
#commit_siblings = 5 # range 1-1000

#---------------------------------------------------------------------------
# QUERY TUNING
#---------------------------------------------------------------------------

# - Planner Method Enabling -

#enable_hashagg = true
#enable_hashjoin = true
#enable_indexscan = true
#enable_mergejoin = true
#enable_nestloop = true
#enable_seqscan = true
#enable_sort = true
#enable_tidscan = true

# - Planner Cost Constants -

effective_cache_size = 4000 # typically 8KB each
#random_page_cost = 4 # units are one
sequential page fetch
cost
#cpu_tuple_cost = 0.01 # (same)
#cpu_index_tuple_cost = 0.001 # (same)
#cpu_operator_cost = 0.0025 # (same)

# - Genetic Query Optimizer -

#geqo = true
#geqo_threshold = 11
#geqo_effort = 1
#geqo_generations = 0
#geqo_pool_size = 0 # default based on
tables in statement,
# range 128-1024
#geqo_selection_bias = 2.0 # range 1.5-2.0

# - Other Planner Options -

#default_statistics_target = 10 # range 1-1000
#from_collapse_limit = 8
#join_collapse_limit = 8 # 1 disables
collapsing of explicit
JOINs

#---------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#---------------------------------------------------------------------------

# - Syslog -

#syslog = 0 # range 0-2; 0=stdout;
1=both; 2=syslog
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'

# - When to Log -

#client_min_messages = notice # Values, in order of
decreasing
detail:
# debug5, debug4,
debug3, debug2,
debug1, # log, info, notice, warning,
error

#log_min_messages = debug5 # Values, in order of
decreasing
detail:
# debug5, debug4,
debug3, debug2,
debug1, # info, notice, warning, error,
log, fatal, # panic

#log_error_verbosity = verbose # terse, default, or
verbose messages

#log_min_error_statement = panic # Values in order of
increasing
severity:
# debug5, debug4,
debug3, debug2,
debug1, # info, notice, warning, error,
panic(off)

#log_min_duration_statement = -1 # Log all statements
whose
# execution time
exceeds the value, in
#
milliseconds. Zero prints all queries. #
Minus-one disables.

#silent_mode = false # DO NOT USE without
Syslog!

# - What to Log -

debug_print_parse = true
debug_print_rewritten = true
debug_print_plan = true
debug_pretty_print = true
log_connections = true
log_duration = true
log_pid = true
log_statement = true
log_timestamp = true
log_hostname = true
log_source_port = true

#---------------------------------------------------------------------------
# RUNTIME STATISTICS
#---------------------------------------------------------------------------

# - Statistics Monitoring -

#log_parser_stats = false
#log_planner_stats = false
#log_executor_stats = false
#log_statement_stats = false

# - Query/Index Statistics Collector -

#stats_start_collector = true
#stats_command_string = false
#stats_block_level = false
#stats_row_level = false
#stats_reset_on_server_start = true

#---------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#---------------------------------------------------------------------------

# - Statement Behavior -

#search_path = '$user,public' # schema names
#check_function_bodies = true
#default_transaction_isolation = 'read committed'
#default_transaction_read_only = false
#statement_timeout = 0 # 0 is disabled, in
milliseconds

# - Locale and Formatting -

#datestyle = 'iso, mdy'
#timezone = unknown # actually, defaults
to TZ environment
setting #australian_timezones = false
#extra_float_digits = 0 # min -15, max 2
#client_encoding = sql_ascii # actually, defaults
to database
encoding

# These settings are initialized by initdb -- they may
be changed
lc_messages = 'C' # locale for system
error message
strings
lc_monetary = 'C' # locale for monetary
formatting
lc_numeric = 'C' # locale for number
formatting
lc_time = 'C' # locale for time
formatting

# - Other Defaults -

#explain_pretty_print = true
#dynamic_library_path = '$libdir'
#max_expr_depth = 10000 # min 10

#---------------------------------------------------------------------------
# LOCK MANAGEMENT
#---------------------------------------------------------------------------

#deadlock_timeout = 1000 # in milliseconds
#max_locks_per_transaction = 64 # min 10,
~260*max_connections bytes
each

#---------------------------------------------------------------------------
# VERSION/PLATFORM COMPATIBILITY
#---------------------------------------------------------------------------

# - Previous Postgres Versions -

#add_missing_from = true
#regex_flavor = advanced # advanced, extended,
or basic
#sql_inheritance = true

# - Other Platforms & Clients -

#transform_null_equals = false

machine:

processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2785.226
cache size : 512 KB
physical id : 0
siblings : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8
apic sep mtrr pge
mca
cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss
ht tm pbe cid xtpr
bogomips : 5488.64

processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2785.226
cache size : 512 KB
physical id : 0
siblings : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8
apic sep mtrr pge
mca
cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss
ht tm pbe cid xtpr
bogomips : 5488.64

processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2785.226
cache size : 512 KB
physical id : 0
siblings : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8
apic sep mtrr pge
mca
cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss
ht tm pbe cid xtpr
bogomips : 5488.64

processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2785.226
cache size : 512 KB
physical id : 0
siblings : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8
apic sep mtrr pge
mca
cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss
ht tm pbe cid xtpr
bogomips : 5488.64

memory:

total used free shared
buffers
cached
Mem: 4933972 4930596 3376 0
51848
4318812
-/+ buffers/cache: 559936 4374036
Swap: 1003656 24800 978856

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org

On Wed, 9 Mar 2005 16:26:53 -0300 (ART), marcelo Cortez
<jmdc_marcelo@yahoo.com.ar> wrote:

Lonni , folks

You're doing this from within psql or elsewhere?

from putty terminal from windows statiom

That doesn't really answer the question. How are you interfacing with
the database? Are you using a client, such as psql, or something
else? putty just means that you're ssh'ing to the server, but once
you're there, how are you connecting to the DB and issuing this
update?

What logging level

default i' guest

From your postgresql.conf i think i saw a debug5 for min_messages.
That is not typically a default for most people. Admittedly your word
wrap in your MUA is rather narrow (like 35 chars) so parsing through
it wasn't the easiest in the world.

are you using? How 'massive' is this update?

full , the update statement not have filter clause.

Full meaning all the rows are being updated? What kind of data is
this that you're updating?

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org

Lonni , folks

Full meaning all the rows are being updated? What
kind of data is
this that you're updating?

the fts engine using one tsvector field indexing with
gist index

the statement is something like this
update from veryLargeTable
set field = to_tsvector( coleace(field1) );
any indication to improve the one configuration the
DB.
thanks for your support.
best regards
MDC

___________________________________________________________
250MB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar