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
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
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
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
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
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
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
> ---
>
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
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
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
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
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
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
13 matches
Mail list logo
