Hi ,
I am using pg 7.3.3 on RH 7.3,
dual Athlon
1 GB RAM.
I have 2 tables a_acc and a_vid_doc (all PK are int).
sizes:
select count(IDS) from a_acc;
count
-
1006772
select count(IDS) from a_vid_doc;
count
---
25
I have problem with the join ot this tables.
I tryed this exa
On 18 Aug 2003 at 18:52, Hannu Krosing wrote:
> My own experimentation also got numbers in 9k/sec range (on a quad
> 1.3GHz Xeons, 2GM mem, 50MB/sec raid) when doing 10-20 parallel runs of
> ~1000 inserts/transaction.
>
> Performance dropped to ~300/sec (at about 60M rows) when I added an
> index
Chris,
> My expectations of a Netra wouldn't be terribly high, either; they
> seem to exist as a product so that people that need a cheap Sun box
> have an option. They are mostly running IDE disk, and the latest
> IA-32 hardware is likely to have newer faster interface options.
Neither are ours
Hi ,
I am using pg 7.3.3 on RH 7.3,
dual Athlon
1 GB RAM.
I have 2 tables a_acc and a_vid_doc (all PK are int).
sizes:
select count(IDS) from a_acc;
count
-
1006772
select count(IDS) from a_vid_doc;
count
---
25
I have problem with the join ot this tables.
I tryed this exa
Shridhar Daithankar kirjutas E, 18.08.2003 kell 09:21:
> On 16 Aug 2003 at 11:40, Josh Berkus wrote:
>
> > Shridhar,
> >
> > > Unfortunately he can not use copy due to some constraints.
> >
> > Why not use COPY to load the table, and then apply the constraints by query
> > afterwords? It migh
pginfo <[EMAIL PROTECTED]> writes:
> I am using pg 7.3.3 on RH 7.3,
Are you certain the server is 7.3.3? This looks like a mergejoin
estimation bug that was present in 7.3 and 7.3.1, but should be fixed
in 7.3.2 and later.
If it is 7.3.3, I'd like to see the pg_stats rows for
a_acc.ids_vid_doc
On Mon, 18 Aug 2003, pginfo wrote:
> Hi ,
> I am using pg 7.3.3 on RH 7.3,
> dual Athlon
> 1 GB RAM.
>
> I have 2 tables a_acc and a_vid_doc (all PK are int).
>
> sizes:
>
> select count(IDS) from a_acc;
> count
> -
> 1006772
>
> select count(IDS) from a_vid_doc;
> count
> ---
>
Shridhar Daithankar kirjutas E, 18.08.2003 kell 19:02:
> On 18 Aug 2003 at 18:52, Hannu Krosing wrote:
> > My own experimentation also got numbers in 9k/sec range (on a quad
> > 1.3GHz Xeons, 2GM mem, 50MB/sec raid) when doing 10-20 parallel runs of
> > ~1000 inserts/transaction.
> >
> > Performan
Hi tom,
sorry for my bad.
My production server is 7.3.7, but the development is 7.3.1 and I ran the
tests on 7.3.1.
It is courios that on 7.3.1 the query is not constantly bad.
>From time to time it is running well.
regards,
ivan.
Tom Lane wrote:
> pginfo <[EMAIL PROTECTED]> writes:
> > I am usi
pginfo <[EMAIL PROTECTED]> writes:
> sorry for my bad.
> My production server is 7.3.7, but the development is 7.3.1 and I ran the
> tests on 7.3.1.
> It is courios that on 7.3.1 the query is not constantly bad.
> From time to time it is running well.
Yeah, the mergejoin estimation bug doesn't bi
Ok,
thanks for the help
and best regards.
ivan.
Tom Lane wrote:
> pginfo <[EMAIL PROTECTED]> writes:
> > sorry for my bad.
> > My production server is 7.3.7, but the development is 7.3.1 and I ran the
> > tests on 7.3.1.
>
> > It is courios that on 7.3.1 the query is not constantly bad.
> > From
On 18 Aug 2003 at 9:57, Josh Berkus wrote:
> Chris,
>
> > My expectations of a Netra wouldn't be terribly high, either; they
> > seem to exist as a product so that people that need a cheap Sun box
> > have an option. They are mostly running IDE disk, and the latest
> > IA-32 hardware is likely t
On 19 Aug 2003 at 1:16, Hannu Krosing wrote:
> Shridhar Daithankar kirjutas E, 18.08.2003 kell 19:02:
> > I was loading a geographic data couple of months back.. It was 3GB data when
> > loaded in postgresql.
>
> With or without indexes ?
Without index. Index was another 3 GB with 50% utilisati
13 matches
Mail list logo
