[GENERAL] sql expert full time help wanted

[Vic Cekvenich]

http://seeker.dice.com/jobsearch/servlet/JobSearch?op=101&engine=2&dockey=xml/7/4/[EMAIL
 PROTECTED]&source=19&FREE_TEXT=keibi

.V

[GENERAL] repost(gmane): sql update max smartries

[Vic Cekvenich]

I am trying to write a sigle command to update the max number from detail.
Something like:
update group set max_msgid=max(c.msgid)
from group g, content c
where g.id=c.g_id
So group is master, content is detail. I want group to stroe 
max(msgid) from content.

Syntax help plz?
.V

---(end of broadcast)---
TIP 8: explain analyze is your friend

[GENERAL] sql update max smartries

[Vic Cekvenich]

I am trying to write a sigle command to update the max number from detail.
Something like:
update group set max_msgid=max(c.msgid)
from group g, content c
where g.id=c.g_id
So group is master, content is detail. I want group to stroe max(msgid) 
from content.

Syntax help plz?
.V
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] repost(gmane): sql update max smartries

[Vic Cekvenich]

Vic Cekvenich wrote:
I am trying to write a sigle command to update the max number from 
detail.

Something like:
update group set max_msgid=max(c.msgid)
from group g, content c
where g.id=c.g_id
So group is master, content is detail. I want group to stroe 
max(msgid) from content.

Syntax help plz?
.V


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[GENERAL] pre-sroted table (w/ index)

[Vic Cekvenich]

In TransacSQL, we used to have the tabled sorted by marking an index for 
example by create_date.

This way we did not need to do an order by or at least it was faster.
Is there a way to force the table to be physicaly stroed sorted by a 
certain index?

tia,
.V
---(end of broadcast)---
TIP 8: explain analyze is your friend

[GENERAL] OS X Mac pgAdmin equivalent?

[Vic Cekvenich]

What can I run on OS X as a pgAdmin equivalment (other than the Java 
solutions)?
.V
--
Please post on Rich Internet Applications User Interface (RiA/SoA) 


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] Text Search vs MYSQL vs Lucene

[Vic Cekvenich]

It be at least dual opteron 64 w 4 gigs of ram runing fedora with a huge 
raid striped drives as single volume.
A similar system and types of querries would be this:
http://marc.theaimsgroup.com

So I guess a table scan.
.V
Shridhar Daithankar wrote:
On Thursday 09 Sep 2004 6:26 pm, Vic Cekvenich wrote:
 

What would be performance of pgSQL text search vs MySQL vs Lucene (flat
file) for a 2 terabyte db?
   

Well, it depends upon lot of factors. There are few questions to be asked 
here..
- What is your hardware and OS configuration?
- What type of data you are dealing with? Mostly static or frequently updated?
- What type of query you are doing. Aggregates or table scan or selective 
retreival etc.

Unfortunately there is no one good answer. If you could provide details, it 
would help a lot..

Shridhar
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
 


--
Please post on Rich Internet Applications User Interface (RiA/SoA) 
<http://www.portalvu.com>

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Text Search vs MYSQL vs Lucene

[Vic Cekvenich]

What would be performance of pgSQL text search vs MySQL vs Lucene (flat 
file) for a 2 terabyte db?
thanks for any comments.
.V
--
Please post on Rich Internet Applications User Interface (RiA/SoA) 


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly

[GENERAL] Text search performance vs MY SQL

[Vic Cekvenich]

What is the performance or other benefits of text search on pgSQL vs 
mySQL on large dbs?
thanks for any comments,

.V
--
Please post on Rich Internet Applications User Interface (RiA/SoA) 


---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

[GENERAL] news server question

[Vic Cekvenich]

This is not a postgreSQL question:

How do you syncronize the news server with the mail list?

Vic


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]