Hi,
I'm migrating data from 7.4.2 to 8.0.0beta1 and the
process is slow (10 15 tuples per second)
Can be a type conversion issue?
RedS
On Thu, 19 Aug 2004 09:54:47 +0200, Leeuw van der, Tim
[EMAIL PROTECTED] wrote:
You asked the very same question yesterday, and I believe you got some useful
answers. Why do you post the question again?
Tim, no need to be rude here. We see this effect from time to time when
a new user sends a
Gaetano Mendola [EMAIL PROTECTED] writes:
Using a prepared query:
Without index and default stat 10 :1.12 ms
Without index and default stat 1000 : 1.25 ms
With index and default stat 10:1.35 ms
With index and default stat 1000: 1.6 ms
Could we see EXPLAIN ANALYZE EXECUTE
HI All,
I have a big performance issue concerning a PostgreSQL
database.
I have the following server configuration:
Pentium 4 2.4 GHz
1 GB RAM
36 GB SCSI
And the following tables:
TABLES
--
Danilo Mota [EMAIL PROTECTED] writes:
SELECT
rc.pkcliente
FROM r_cliente AS rc
INNER JOIN sav_cliente_lg AS sc ON sc.cpfcnpj = sc.cpfcnpj;
Surely you meant
INNER JOIN sav_cliente_lg AS sc ON rc.cpfcnpj = sc.cpfcnpj;
I would also venture that your statistics are desperately out of date,
Hi all,
the following
query is working well without the AND on WHERE clause, so I need suggestions
about how could I rewrite the query to get the same result with less cost of
time and resources.
Ive already created indexes on all foreign key
columns.
Thanks in advance.
Danilo
Have you tried
AND (sn.notafiscalnumero, sn.notafiscalserie, sn.cliente) NOT IN (
SELECT numero, serie, codigo FROM r_contrato WHERE savfonte = 'lg')
or
and not exists(select true from r_contrato where savfonte = 'lg' and numero =
sn.notafiscalnumero and serie = sn.notafiscalserie and codigo =