Louis
what if you create one wrapper function immutable?
some thing like this.
CREATE OR REPLACE FUNCTION myextract(timestamp )
RETURNS date AS
$BODY$
BEGIN
return extract(date from $1) ;
END;
$BODY$
LANGUAGE 'plpgsql' IMMUTABLE
best regards
mdc
--- Louis-David Mitterrand
Sorry forgot to mention
later try
CREATE UNIQUE INDEX visit_idx ON visit_buffer(
id_session, id_story ,myextract(created_on));
best regards
Louis
what if you create one wrapper function
immutable?
some thing like this.
CREATE OR REPLACE FUNCTION myextract(timestamp )
RETURNS
hi folks
i've tried to install ispell for
CREATE TEXT SEARCH DICTIONARY spanish_ispell (
TEMPLATE = ispell,
DictFile = spanish,
AffFile = spanish,
StopWords = spanish
);
sentence, but, one error ocurrs
ERROR: syntax error at line 432 of affix file
Teodor
i've tried with openoffice.org but whitout success,
:)
ERROR: invalid byte sequence for encoding UTF8:
0xe16261
HINT: This error can also happen if the byte sequence
does not match the encoding expected by the server,
i've tried too with
convmv -f iso-8859-1 --notest -t utf-8
Thanks Teodor
for quick response,and your work
That's right, but you should convert dictionary and
affix file in UTF8 encoding.
how to i can do it?
best regards
MDC
Yahoo! Encuentros.
Ahora encontrar pareja es mucho más fácil, probá el nuevo Yahoo! Encuentros
Thanks Alvaro
iconv -f iso-8859-1 -t utf-8 es_ES.dict es.dict
works!!
--- Alvaro Herrera [EMAIL PROTECTED]
escribió:
marcelo Cortez escribió:
i've tried too with
convmv -f iso-8859-1 --notest -t utf-8
es_ES.dic
whitout success too.
convmv only recodes the name
folks
the follow queries work in postgres 8.2 but
in 8.3beta don't work
SELECT c.* FROM c WHERE c.numero LIKE '1%';
i think automatic conversion of numeber to text is
the problem , in 8.3beta don't work
numero field is integer type
any ideas?
best regards
mdc
ps:PostgreSQL
( not
manual code here).
there any way simulate previous behavior? (automatic
conversion), create cast can help?
best regards.
mdc
Regards
Pavel Stehule
On 10/01/2008, marcelo Cortez
[EMAIL PROTECTED] wrote:
folks
the follow queries work in postgres 8.2 but
in 8.3beta don't work
Alvaro
--- Alvaro Herrera [EMAIL PROTECTED]
escribió:
marcelo Cortez escribió:
Pavel
--- Pavel Stehule [EMAIL PROTECTED]
escribió:
Hello,
it isn't bug. You have to cast to string before.
http://www.postgresql.org/docs/8.3/static/release-8-3.html
E.1.2.1
Alvaro
--- Alvaro Herrera [EMAIL PROTECTED]
escribió:
marcelo Cortez escribió:
Pavel
--- Pavel Stehule [EMAIL PROTECTED]
escribió:
Hello,
it isn't bug. You have to cast to string before.
http://www.postgresql.org/docs/8.3/static/release-8-3.html
E.1.2.1
Folks
i received the follow message from backend ,it's this
a bug?
best regards
and happy new year
MDC
pd: any clue are welcomed.
*** glibc detected *** postgres: postgres richelet
201.235.11.133(2504) SELECT: double free or corruption
(!prev): 0x0845d7e8 ***
=== Backtrace:
8.3beta3 on i686-pc-linux-gnu, compiled by
GCC gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.0.1)
i'ts correct GCC version?
best regards.
MDC
pd: gdb can help? ( for debugging my own code)
links about howto debug?
--- Tom Lane [EMAIL PROTECTED] escribió:
marcelo Cortez [EMAIL PROTECTED] writes
Folks
select chr(165);
ERROR: requested character too large for encoding:
165
it's one old scrip if not remember wrong works
postgres in 8.2.4
any clue?
best regars
mdc
info:
select version().
PostgreSQL 8.3beta3 on i686-pc-linux-gnu, compiled by
GCC gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.0.1)
folks
i've installed 8.3beta but at start up receive
FATAL: invalid value for parameter
timezone_abbreviations: Default
any clue?
best regards.
MDC
info:
Linux richelet-internet 2.6.21.6 #9 SMP Sun Dec 2
17:52:20 ART 2007 i686 Pentium III (Coppermine)
GenuineIntel GNU/Linux
gp_config
Alvaro ,folks
--- Alvaro Herrera [EMAIL PROTECTED] escribió:
marcelo Cortez escribió:
folks
i've installed 8.3beta but at start up receive
FATAL: invalid value for parameter
timezone_abbreviations: Default
Do you have a file named Default on the
share/timezonesets dir
Felipe
--- Felipe de Jesús Molina Bravo
[EMAIL PROTECTED] escribió:
Hi
You are rigth, the output of show lc_ctype; is C.
Then I did is:
prueba1=# show lc_ctype;
lc_ctype
-
es_MX.ISO8859-1
(1 row)
and do it
% initdb -D /YOUR/PATH -E LATIN1 --locale
hi all
i'm using postgresql 8.2.4 and install tsearch2 , but
i need spanish idiom.
following
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/README.gendict
and downloading
http://snowball.tartarus.org/algorithms/spanish/stemmer.html
stem.c and stem.h
./config.sh -n pt -s -p
Hi all
has anybody created using Gendict generate
dictionary in spanish successful ?.
__
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
Tom
Thanks works fine!
best regards
mdc
--- Tom Lane [EMAIL PROTECTED] escribió:
marcelo Cortez [EMAIL PROTECTED] writes:
i downloaded postgres8.2.4 sources , expand and
./configure and install with success.
Now i need one module from contrib directory ,
fuzzystrmatch
cd
hi all
i downloaded postgres8.2.4 sources , expand and
./configure and install with success.
Now i need one module from contrib directory ,
fuzzystrmatch
cd /postgres/contrib/fuzzymatchstr [ ok ]
make
throws
make
Makefile:15: ../../src/Makefile.global: No such file
or directory
Magnus , folks
The only caveat i found in winxp64 is with psqlODBC
my application dont work very well on it into xp64
platform, the work around was change odbc profile in
favor of dns file , with dns file my application
return to work, ok.
BTW i using linux server without problems, but my
folks
i need help with libpq program ,i made on C program
for
wrapper libpq.dll program , the routine failing is
copy from stdin interface.
PQputCopyData return 1 (AKA ok)
PQputCopyEnd return 1 (AKA ok)
but nothing is append to database.
tailing log file
invalid input syntax for integer:
not match the delimiter from your
copy statement.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of marcelo Cortez
Sent: Saturday, June 16, 2007 9:04 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] help with libpq program
Hi Jhon
Diferent distros put file in diferent path
try
/usr/local/pgsql/initdb bla bla bla
or
/var/lib/postgres/bin/initdb bla bla bla
or
locate initdb
for locate that file
best regards
mdc
--- John K Masters [EMAIL PROTECTED]
escribió:
I feel somewhat embarrassed to post this
Folks
I am confused ,
way planer it does not use the partial index?
query:
SELECT cliente_base.* FROM cliente_base
WHERE (cliente_base.inst_class_ = 'Cliente' ) ORDER
BY cliente_base.nombre ASC
plan:
QUERY PLAN
Folks
I am confused ,
way planer it does not use the partial index?
any help be appreciated
pd: sorry for my english.
data:
table definition:
-- Table: cliente_base
CREATE TABLE cliente_base
(
id_ integer NOT NULL,
activo boolean,
numero integer,
categ character
this, even psqlodb
installed.
Any suggestion will be appreciated?
best regards
MDC
--- Magnus Hagander [EMAIL PROTECTED] escribió:
On Mon, May 14, 2007 at 08:46:23PM -0300, marcelo
Cortez wrote:
hi all
there any was successful with connect to postgres
with psqlodbc in dsn less mode
at least for ADODB.
DAO had it like this:
ODBC;Driver=PostgreSQL
UNICODE;DATABASE=X1;SERVER=X2;PORT=X3;UID=X4;PWD=X5;X6;
marcelo Cortez schrieb:
Hi folks
Magnus thanks for respond, but i can't success
full
with this.
Hi think it's string connection mater, but can't
connect
hi all
there any was successful with connect to postgres
with psqlodbc in dsn less mode? It's wrong list for
this subject? any pointer be appreciated
best regards
mdc
__
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y
folks
I need help
my client application need to save rtf text format,
i'm codding string data into bytea format by hand
but without success need some body check this
input sample data:
'{\rtf1\ansi
}'
output codding
Thanks Tom!
this works.
best regards
MDC
--- Tom Lane [EMAIL PROTECTED] escribió:
Bill Moran [EMAIL PROTECTED] writes:
marcelo Cortez [EMAIL PROTECTED] wrote:
I need to save data on rtf format but , postgres
refuses to storage for backslah or character's
problem's any idea
Folks
I need to save data on rtf format but , postgres
refuses to storage for backslah or character's
problem's any idea or vice are welcomed best
regards
mdc
pd: sample off data to save ( from postgres log)
UPDATE plbrecord SET documentation =
on a Fat32 partition and gave the data
directory path to an NTFS
partition. I have not set any file permissions.
Installing as a default
postgres user.
Paul Lambert-2 wrote:
marcelo Cortez wrote:
hi there
same things occurs to me.
Any body install win32 version with success
:/Archivos de programa/PostgreSQL/8.2/data
note path is truncated in message ???
file not exists i delete directory
one more time thanks
best regardsd
mdc
--- Paul Lambert [EMAIL PROTECTED]
escribió:
marcelo Cortez wrote:
Magnus
I have NTFS only , i don't have FAT partitions
at
all
hi there
same things occurs to me.
Any body install win32 version with success???
best regards
MDC
--- RPK [EMAIL PROTECTED] escribió:
When I run the setup of PGSQL 8.2.3, it displays
error while initializing
database cluster. Error displayed is: Failed to
execute initdb. Unable to
folks
I can't install postgresql on winxp profesional
Installer fail ( creating cluster)
Installer with out cluster . ok
creating cluster on hand .fail
initdb
The files belonging to this database system will be
owned by user postgres.
This user must also own the server process.
The
Hi there
--- Peter Eisentraut [EMAIL PROTECTED] escribió:
dfx wrote:
I have some fiel name with character with accent
(à, ò...) but when I
make a plain backup of schema (file.sql) that
characters are
converted to strange sequence of two (or more?)
characters.
This sounds to me
oblfolks
I can't install postgresql on winxp profesional
Installer fail ( creating cluster)
Installer with out cluster . ok
creating cluster on hand .fail
initdb
The files belonging to this database system will be
owned by user postgres.
This user must also own the server process.
[EMAIL PROTECTED] escribió:
This might help you:
select encode(col1,'escape') from tblBytea;
where col1 is of type bytea...
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/24/07, marcelo Cortez
[EMAIL PROTECTED] wrote:
folks
help me ,i cant read bytea
hi Markus ,folks
Are you sure you tested with a real bytea field?
Yeah , i store bytea using encode function , how you
say .
The field of my table is bytea type , and store real
bytea data in this field.
My problem is , i can't convert this field to text
anymore, not function receiving
folks
my table
CREATE TABLE pblfield
(
id_ integer NOT NULL,
value_field bytea,
name character varying(128),
osset integer,
length integer,
version_ integer,
inst_class_ character varying(128),
CONSTRAINT pblfield_pkey PRIMARY KEY (id_)
)
insert into pblfield( id_ ,
ok my mistake ,
insert into pblfield( id_ , value_field )
values(1 ,encode(E'\\000\\001', 'escape') ::bytea
) ;
best regards
mdc
__
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo
Richard
H i'm understood now!,
sorry for the noise.
thanks very, very much
best regards
mdc
--- Richard Huxton dev@archonet.com escribió:
marcelo Cortez wrote:
ok my mistake ,
insert into pblfield( id_ , value_field )
values(1 ,encode(E'\\000\\001', 'escape')
::bytea
People
In my experience work very well con tables with
172.000.000 of records ( 172 millions).
In fact is not too large number of records for
postgresql.
important aspect of this installation is your .conf
file, take care of this, check old email with config
subject.
Best regards
mdc
---
folks
help me ,i cant read bytea type field's.
how to convert bytea to text or varchar ?
when using bytea types?
any clue be appreciated
best regards
mdc
__
Preguntá. Respondé. Descubrí.
Todo lo que
folk
the pg_statistics show too many lock table ( fron my
app.) and all of them is in waiting state.
the only way to go out from this situation is restart
the cluster.
where is the way to investigate lock's table tree ?
any clue?
best regards
MDC
Michael ,list
You are you are right, thanks a lot for your help and
tinme.
best regards
MDC
--- Michael Fuhr [EMAIL PROTECTED] escribió:
On Tue, Aug 22, 2006 at 02:37:19PM -0300, marcelo
Cortez wrote:
This isn't a trigger function. Are you sure
trigger is the
word you meant
folks
I think my trigger need transaction ,but the pgsql
compiler refuse to compile 'begin .. commit ' sequence
I use the perform , to do the works
i'm wrong?
tia.
any help be appreciated.
MDC
code below ( note (*) for perform instruction)
CREATE OR REPLACE FUNCTION
Micheal
This isn't a trigger function. Are you sure
trigger is the
word you meant?
yes i do
CREATE TABLE actlocat
(
id_actlocal numeric(2) NOT NULL,
d_actlocal char(8) NOT NULL,
f_novedad float8 NOT NULL,
ordenado_por char(18) NOT NULL,
CONSTRAINT pk_actlocat PRIMARY KEY
Tom
thanks for to respond quickly, see below
marcelo Cortez [EMAIL PROTECTED] writes:
Then i've created normal tables but the wal
file
generated by this tables grows and grows.
The WAL files shouldn't grow indefinitely unless
you've got some
fairly serious problem
folks
I have a asp application connected with postgres.
The postgres temporary tables is useless because i
need remain this tables between sessions, perfomance
reasons.
This tables are created on the fly and remain between
session but asp server finalize connection and
temporary table are
Tom
thanks for to respond quickly, see more below
marcelo Cortez [EMAIL PROTECTED] writes:
Then i've created normal tables but the wal
file
generated by this tables grows and grows.
The WAL files shouldn't grow indefinitely unless
you've got some
fairly serious problem
Hi all
there any way to isolate the transaction log for some
tables?
the temporary tables generate transaction's log's i
want to islotate this , for backups propouses, any
sugestion are welcomed.
best regards
MDC
folks
i´ts is my first procedure/function
the pgadmin show 10 secs in execute it
any pointer be apreciated
CREATE OR REPLACE FUNCTION fs_getstring() RETURNS TEXT
AS '
DECLARE
DECLARE
curs1 CURSOR FOR select id_reparticion
::varchar || chr(1) || codigo_reparticion
Jorge
my test, i created one utf8 database but don´t work
ideas?
testutf8=# \set
VERSION = 'PostgreSQL 8.1.0 on i386-pc-linux-gnu,
compiled by GCC cc (GCC) 3.3.5
(Debian 1:3.3.5-13)'
AUTOCOMMIT = 'on'
VERBOSITY = 'default'
PROMPT1 = '%/%R%# '
Tom , folks
I've recreated the database with --locale=es_AR
keyword
and all works fine
thanks a lot.
best
MDC
--- Tom Lane [EMAIL PROTECTED] escribió:
marcelo Cortez [EMAIL PROTECTED] writes:
testutf8=# \set
...
ENCODING = 'UTF8'
HISTSIZE = '500'
testutf8=# select upper('ñ
folks
select ucase( 'ñ'); - 'ñ'
i want this statemen return 'Ñ'
any ideas?
best regards
mdc
_
Horóscopos, Salud y belleza, Chistes, Consejos de amor:
el contenido más divertido para tu celular está en Yahoo!
formatting
lc_time = 'es_AR' #
locale for time formatting
but the upper function fail for me.
what is your settings?
BTW the database is SQL_ASCII
any pointer be appreciated
best regards
MDC
--- Jorge Godoy [EMAIL PROTECTED] escribió:
marcelo Cortez [EMAIL
Tom , Michael
Thanks for your responses,
there any procedure for fix fts installation?
any advice will be appreciated
Tia.
best regards.
MDC
--- Tom Lane [EMAIL PROTECTED] escribió:
marcelo Cortez [EMAIL PROTECTED] writes:
the follow error:
Warning: pg_query(): Query failed
Folks
the follow error:
Warning: pg_query(): Query failed: ERROR: no existe
la columna oid
the column oid don't exists in english.
CONTEXT: sentencia SQL: select oid from
public.pg_ts_cfg where locale = $1
using php4 call the pgsql.so
with follow query:
COPY caratult(actuacion_car,
Folks
the follow error:
Warning: pg_query(): Query failed: ERROR: no existe
la columna oid
CONTEXT: sentencia SQL: select oid from
public.pg_ts_cfg where locale = $1
using php call the pgsql.so with follow query:
COPY caratult(actuacion_car,
folks
i have problems with encodings
the scenario is:
database: CREATE DATABASE testLatin
WITH OWNER = owner1
ENCODING = 'LATIN9';
test table:
CREATE TABLE test
( nombre varchar(20))
WITH OIDS;
ALTER TABLE test OWNER TO marcelo;
data:
nombre
-
maricón
ñañoso pícaro
test
--- Tom Lane [EMAIL PROTECTED] escribió:
marcelo Cortez [EMAIL PROTECTED] writes:
i have problems with encodings
You need to make sure that the database locale
matches what you want,
not only the encoding.
See the Localization chapter in the docs:
http://www.postgresql.org/docs/8.1
hi Tom , folks
how do i You need to make sure that the database
locale
matches what you want, ?
any pointer by appreciated
sorry for silly questions ;)
best
___
1GB gratis, Antivirus y
hi folks
the lastest postgres odbc driver don't work into
winxp64 ( AKA Windows Vista) Operative System.
The installer fail, i'm try to register dll manually
but still fail at add conection time into control
panel
any ideas
best regards
mdc
hi Richard ,folks
Question: is normal this locks ?
which is the reason of this?
thanks for your time
best regards
MDC
--- Richard Huxton dev@archonet.com escribió:
marcelo Cortez wrote:
Richard
Sorry for a delay
question the select * from pg_stat_activity
74274|52800||30186|AccessShareLock|t
this queries show locks into 30816 pid or a'im wrong?
best regards
MDC
--- Richard Huxton dev@archonet.com escribió:
marcelo Cortez wrote:
Hi Richard , folks
the query is:
SELECT c.actuacion_car AS c_actuacion,
c.comentario1
--- Richard Huxton dev@archonet.com escribió:
marcelo Cortez wrote:
Hi Richard , folks
the query is:
SELECT c.actuacion_car AS c_actuacion,
c.comentario1 || ' ' || c.comentario2 || ' ' ||
c.comentario3 AS c_comentario
FROM caratult AS c INNER JOIN extractt AS t1 ON
...etc
Hello all,
does anyone know, whether there is a
Debian Package for postgresql 8.x for stable version?
Thanks in advance.
MDC
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu cuenta ya! -
hi all
I have a lock problem, one select query freeze my
application, the query in question is on complex
select , with many join's, but select all of them.
The select * from pg_catalog.pg_locks show many rows
while the query freeze my aplication.
the aplication use ODBC .
any ideas?.
any help
-linux-gnu, compiled by
GCC 2.95.4
kernel: Linux serverf 2.4.26-1-686-smp #1 SMP Fri Aug
20 19:39:10 CEST 2004 i686 unknown
Distro: Debian
--- Richard Huxton dev@archonet.com escribió:
marcelo Cortez wrote:
hi all
I have a lock problem, one select query freeze my
application, the query
hi guys , Richad
you are right!, my apologies
profile data:
postgres: PostgreSQL 7.4.3 on i386-pc-linux-gnu,
compiled by GCC 2.95.4
HP proliant
processor: Dual Xeon 3.40 Ghz.
HD:250 Gigabytes hard disk storage.
responses:
Comment 4 - you apply a LIMIT without an ORDER BY.
Are
hi guys
i need advice for query optimization,take too long
time.
any coments are welcomed :).
best
MDC
SELECT c.actuacion_car AS c_actuacion,
c.comentario1 || ' ' || c.comentario2 || ' ' ||
c.comentario3 AS c_comentario
FROM caratult AS c INNER JOIN extractt AS t1 ON
folks
what is preferible value for
stats_reset_on_server_start ?
what is default value?
best regards
MDC
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar
hi folks
the query:
SELECT P.ACT_INCORPORADA, P.FECHA_INICIO,
P.OBSERVACIONES1
FROM PASEST AS P
WHERE
P.FECHA_INICIO between '1999-08-22
00:00:00.00'::timestamp AND '1999-12-22
23:59:00.00'::timestamp
ORDER BY P.ACT_INCORPORADA
make table scan ,
hi folks
the follow script fail
select to_tsquery('hello world ');
- ERROR: syntax error
how to catch this error, any clue?
best regards
mdc
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu
hi
any pointer's to install xml on debian be
appreciated.
best regards
mdc
___
A tu celular ¿no le falta algo?
Usá Yahoo! Messenger y Correo Yahoo! en tu teléfono celular.
Más información en http://movil.yahoo.com.ar
folks
the server log message is
LOG: invalid message length
any clue?
best regards
mdc
pd: where to found the foot print header messages for
bki protocol?
___
A tu celular ¿no le falta algo?
Usá Yahoo! Messenger y Correo Yahoo! en tu
folks
the server log message is
LOG: invalid message length
any clue?
best regards
mdc
pd: where can i find header format messages for
bki protocol?
___
A tu celular ¿no le falta algo?
Usá Yahoo! Messenger y Correo Yahoo! en
Folks
I am a little confused, I am trying to implement md5
autentication protocol,
as the field is used salt?
is hash of md5 algorithm?
how build the key?
the server log say:
'Password authentication failed for user'
is algun example of as it is the protocol?
best regards
mdc
hi folks
the postgres fail with follow mwssage
pg_dump: dumpClasses(): SQL command failed
pg_dump: Error message from server: ERROR: xlog flush
request 190/3F08779C is not satisfied --- flushed only
to 190/3FD0
CONTEXT: writing block 268606 of relation 17142/17501
any clue?
best
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
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
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
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
hello to all
Soon time I am going to face a migration of a DBII
database our dear postgresql .
I will thank for any advice that can give me, in
addition this migration
will have 20 million records.
20 million record is to large instalation, exist some
tips for this type of facilities?
Tia .
hello to all
Soon time I am going to face a migration of a DBII
database our dear poststoneware. I will thank for any
advice that can give me, in addition this migration
will have 20 million records.
20 million record is to large instalation, exist some
tips for this type of facilities?
Tia .
hello to all
the scene is following:
/psql someDatabase
vaccum full verbose;
but nothing informs.
in which cases vacuum do not inform anything?
postgresql 7.4 on red hat 9.0
any clue be appreciate.
best regards
klingon
PS: the application has problems for that reason it
wanted to
88 matches
Mail list logo