From: | Jason Slagle <raistlin(at)tacorp(dot)net> |
---|---|
To: | Tim Perdue <perdue(at)raccoon(dot)com> |
Cc: | "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>, pgsql-sql(at)hub(dot)org |
Subject: | Re: [SQL] Performance |
Date: | 1999-03-10 03:24:05 |
Message-ID: | Pine.LNX.4.03.9903092222480.27247-100000@tacorp.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
What, if anything, are you using as an index.
I have 1,400,000 entries (200MB) I'm inserting into a database. Radius
detail files as a matter of fact. Apart from COPY taking forever to load
that (probably due to my several indexes), it seems the select is VERY
slow. Any tips?
How CPU intensive is a select?
Jason
---
Jason Slagle
Network Administrator - Toledo Internet Access - Toledo Ohio
- raistlin(at)tacorp(dot)net - jslagle(at)toledolink(dot)com - WHOIS JS10172
On Tue, 9 Mar 1999, Tim Perdue wrote:
> It searches the bodies, not the subjects or authors. I don't see why anyone
> needs to search for a particular author. But if it's requested enough, it
> would be trivial to implement.....
>
> Tim
>
>
> -----Original Message-----
> From: D'Arcy J.M. Cain <darcy(at)druid(dot)net>
> To: perdue(at)raccoon(dot)com <perdue(at)raccoon(dot)com>
> Cc: pgsql-sql(at)hub(dot)org <pgsql-sql(at)hub(dot)org>
> Date: Tuesday, March 09, 1999 9:10 PM
> Subject: Re: [SQL] Performance
>
>
> >Thus spake Tim Perdue
> >> Some time back I sent out a message asking if PGSQL would be able to
> handle
> >> my mailing list archive at http://www.geocrawler.com/ , and whether it
> would
> >> scale up to 100MB.
> >
> >Cool. We now have a searchable archive for PostgreSQL. However, I
> >tried a search and it didn't seem to work. In pgsql-hackers I entered
> >"niladic" (I tried "Niladic" just in case) and it failed to find any
> >messages, even though I could see a few on the list of recent messages.
> >Any ideas?
> >
> >--
> >D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
> >http://www.druid.net/darcy/ | and a sheep voting on
> >+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Karl Denninger | 1999-03-10 03:30:40 | Re: [SQL] Performance |
Previous Message | Tim Perdue | 1999-03-10 03:13:30 | Re: [SQL] Performance |