At 12:55 PM 3/6/02 -0800, Peter Darley wrote:
What is it about FreeBSD that is going to make it faster than Linux? Any
idea where I can find some comparative benchmarks?
There are a lot of comparative benchmarks that show FreeBSD as much faster
than Linux in real-world load mixes.
-crl
> "Andy" == Andy Ruhl <[EMAIL PROTECTED]> writes:
Andy> On Wed, 6 Mar 2002, Peter Darley wrote:
>> Andy, I've got nothing against FreeBSD, except that I'm familiar
>> with Linux and not with BSD. What is it about FreeBSD that is
>> going to make it faster than Linux? Any idea where I can fin
Can't speak to tsearch2 in specific but I have learned to be very cautious -- caching
does indeed make a noticible difference on this sort of thing, especially if you have
enough RAM to hold a significant amount of the data. Either keep changing the query
target or do something violent to wipe t
On Sun, 12 May 2002, Dan Langille wrote:
>
> On 12 May 2002 at 12:49, Brian McCane wrote:
>
> > I am on FreeBSD 5.0.
>
> There is a reason why you must be on 5.0? That is not recommended for
> "sane" people.
>
> 5.0 is -current and not the best place to be running important
> applications At pr
Here is the trouble I encountered.
I got 2 tables like
create table mytable(idnop serial, other varchar,
primary key (idnop));
create table reftable(idnop integer references
mytable, primary key (idnop));
pgsql create implicitly a sequence to handle the idnop
serial.
I perfomed some insertions in
Here is the explain analyze output, funny thing, after I ran josh's
query, mine ran a lot fastermaybe it forced a caching?;
search_test=# explain analyze select count(*) from product where vector
@@ to_tsquery('oil');
Aggregate (cost=6113.09..6113.09 rows=1 width=0) (actual
time=19643.372.
Hemapriya wrote:
Hi,
Can anyone tell me how to view the different schemas
in a database. I have created a schema and some tables
in it. Also I have altered the search_path to add the
new schema.. but still /dt doesn't give me the new
schema and its tables.
you can do set search_path=schema;
\d
Hi,
Can anyone tell me how to view the different schemas
in a database. I have created a schema and some tables
in it. Also I have altered the search_path to add the
new schema.. but still /dt doesn't give me the new
schema and its tables.
Any help?
Thanks
Priya
_
while you weren't looking, Goulet, Dick wrote:
> I'd precreate all of the tables/indexes and then move the data...
If you have a lot of data, it's probably better to punt on creating
the indices until after you've moved the data. Bulk populating
indexed tables, particularly if the table has mor
Kris,
could you post 'explain analyze' output ?
Also, could you disable index usage (set enable_indexscan=off)
and rerun search using tsearch2 ?
also, could you run 'stat' function to see frequency distribution
of words. See http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_Notes
for det
Hi all. I am doing some work with tsearch2 and am not sure what to
expect out of it, performance wise. Here is my setup:
Table "public.product"
Column| Type |Modifiers
-+--+---
On Sat, 17 Feb 2001, Tom Lane wrote:
[skip]
TL> Platform: HPUX 10.20 on HPPA C180, fast wide SCSI discs, 7200rpm (I think).
TL> Minimum select(2) delay is 10 msec on this platform.
[skip]
TL> I vote for commit_delay = 0, unless someone can show cases where
TL> positive delay is significantly be
On Thu, 4 Jul 2002, Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > Shared memory pages, IIRC, are locked, meaning that they cannot be
> > swapped.
>
> Is that really how it works on *BSD? That's great if so --- it's
> exactly what Postgres wants --- but you'll pardon my paranoia a
Given the "fun" I've had with Sql*Server and it's sister Access, you'd be much better
off porting things manually. I'd precreate all of the tables/indexes and then move
the data with the aid of Access or a similar ODBC tool. As for the rest, re-write it
as Tsql is more like VB than pgplsql.
D
Dear friends,
First pls accept my apologies, because I am a new Postgres user, so my
questions could be silly.
We need to setup a database using UTF-8 encoding, however, by some way, we
have to express our need for right Greek character collation order.
I tried the default installation using pgin
15 matches
Mail list logo
