2014-10-21 10:57 GMT-02:00 :
>
>
> Hi all,
>
> I'm experimenting with table partitioning though inheritance. I'm testing
> a query as follows:
>
> explain (analyze, buffers)
> select response.id
> from claim.response
> where response.account_id = 4766
> and response.expire_timestamp is null
> and
Hi all,I'm experimenting with table partitioning though inheritance. I'm testing a query as follows:explain (analyze, buffers)select response.idfrom claim.responsewhere response.account_id = 4766and response.expire_timestamp is nulland response.create_timestamp >= DATE '2014-08-01'order by create_t
Hi,
I assume you have reposted because you have just signed up to the list.
If this is the case, can you please read the archives or replies to your original post
about this question.
It did make it onto the archives and myself and others did reply with a few ideas and
questions.
If you could
Hi, I have just installed 8.0.0beta1 and I noticed
that some query are slower than 7.4.2 queries.
After a FULL VACUUM ANALYZE
***With 7.4.2***
explain analyze SELECT count(*) FROM "SNS_DATA"
WHERE "Data_Arrivo_Campione" BETWEEN '2004-01-01 00:00:00' AND '2004-01-31
23:59:59' AND "Cod_Pa
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> I am going to assume that one of the sc.cpfcnpj's above is really rc.cpfcnpj
> since that corresponds to the explain below.
No, actually the explain plan corresponds to the sc.cpfcnpj = sc.cpfcnpj
condition. I didn't twig to the typo until I started t
On Fri, Aug 20, 2004 at 13:25:30 -0300,
Danilo Mota <[EMAIL PROTECTED]> wrote:
>
> And the following tables:
> TABLES
>
> --
> == r_cliente: 75816 records
>
"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 d
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
