[GENERAL] Help about physical page layout in PostgreSQL:

Hi,   I was trying to modify the physical page layout in PostgreSQL. I understand the source code for physical page organization is located at bufpage.c but I wonder what is the external interface for this physical page organization. Interface like InsertRecToPage, DeleteRecFromPage, GetAttr, GetR

Re: [GENERAL] Hardware related question: 3ware 9500S

A... good point.Why oh why does tyan have two boards with the same prefix ;)!!!AlexOn 4/15/06, Guy Rouillier < [EMAIL PROTECTED]> wrote:Alex Turner wrote:> Raid 5 on the 9550SX is supposed to be significantly better than the > 9500 series.>> I would be carefull of benchmarks listed out there.  

Re: [GENERAL] Hardware related question: 3ware 9500S

I have the time to do it, but not the $$s ;)AlexOn 4/15/06, Francisco Reyes <[EMAIL PROTECTED] > wrote:Alex Turner writes:> Suggests that the 9550SX is at least competitive with the others. Thanks for the links.> I know I like the 3ware/AMCC cards because of their very good RAID 10> performance.Rai

Re: [GENERAL] Google Summer of Code (Fix aggregate operators & Implement features such as Data Cubes and Skyline)

Hi, Myself and a friend are PhD students at the University of California, Riverside. We would be interested in such a project if it were available. We are both experienced developers previously interning at EA Games and current system administrators for the CS department. Benjamin Arai [EMAIL PR

Re: [GENERAL] Google Summer of Code (Fix aggregate operators & Implement features such as Data Cubes and Skyline)

"Benjamin Arai" <[EMAIL PROTECTED]> writes: > A good project for the Google summer of code would be to solve the aggregate > problems in PostgreSQL. In addition, add some of the more complex operators > such as rollup and etc. That seems a tad ambitious, unless the SOCcer has already done some no

[GENERAL] Google Summer of Code (Fix aggregate operators & Implement features such as Data Cubes and Skyline)

Hi,   A good project for the Google summer of code would be to solve the aggregate problems in PostgreSQL.  In addition, add some of the more complex operators such as rollup and etc.  These features can help close the gap between PostgreSQL and popular commercial offerings such as Oracle an

Re: [GENERAL] Comparing text field

You have made a wrong mistake in your SQL quary. Your quary should be look like this. SELECT id FROM table1 WHERE message like '%VAC153-683-685-131830- /O.NEW.KLWX.SV.W.0022.060413T1742Z-060413T1830Z/ BULLETIN - EAS ACTIVATION REQUESTED SEVERE THUNDERSTORM WARNING NATIONAL WEATHER SERVICE

Re: [GENERAL] Update from diferents conditions

I think it is not possible using a single SQL command. You have to issue separate SQL command for each row. --- Claudio Alejandro Ulloa Heinsohn <[EMAIL PROTECTED]> wrote: > i want update differents rows of a table, but each row with a > diferente > condition, is possible make that update? >

Re: [GENERAL] Question about selecting rows

On Sat, Apr 15, 2006 at 06:44:29PM -0400, Hrishikesh Deshmukh wrote: > I have a question about selecting rows, my table has 20,000 rows, i want to > look at rows 5000 to 10,000. See OFFSET and LIMIT in the SELECT documentation. Be sure to read the advice about using ORDER BY. http://www.postgres

Re: [GENERAL] Question about selecting rows

"Hrishikesh Deshmukh" <[EMAIL PROTECTED]> writes: > Hi All, > > I have a question about selecting rows, my table has 20,000 rows, i want to > look at rows 5000 to 10,000. There is no defined row ordering in SQL unless you use ORDER BY, so you need to specify how you want to sort it first. > How

[GENERAL] Question about selecting rows

Hi All,I have a question about selecting rows, my table has 20,000 rows, i want to look at rows 5000 to 10,000.How does one use the select statement in this case since i don't have a specific case to use where?! Thanks in advance.Hrishi

Re: [GENERAL] Hardware related question: 3ware 9500S

Alex Turner writes: Suggests that the 9550SX is at least competitive with the others. Thanks for the links. I know I like the 3ware/AMCC cards because of their very good RAID 10 performance. Raid 10 is what I used on my last server and likely what I will use on the next. I wish we coul

Re: [GENERAL] starne error from select 1!=-1

"Andrus" <[EMAIL PROTECTED]> writes: > select 1!=-1 > ERROR: operator does not exist: integer !=- integer > Isn't this a bit stange ? No. We couldn't really parse this any other way without disallowing - (and +) altogether in multi-character operator names. There's a special hack for SQL-spec

[GENERAL] starne error from select 1!=-1

select 1!=-1 causes ERROR: operator does not exist: integer !=- integer HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts. Isn't this a bit stange ? If I add space before -1 error does not appear. ---(end of broa

Re: [GENERAL] Hardware related question: 3ware 9500S

Alex Turner wrote: > Raid 5 on the 9550SX is supposed to be significantly better than the > 9500 series. > > I would be carefull of benchmarks listed out there. For instance, > whilst looking for supporting material, I came cross this gem: > http://www.gamepc.com/labs/print_content.asp?id=9550s

Re: [GENERAL] Hardware related question: 3ware 9500S

Raid 5 on the 9550SX is supposed to be significantly better than the 9500 series.I would be carefull of benchmarks listed out there.  For instance, whilst looking for supporting material, I came cross this gem: http://www.gamepc.com/labs/print_content.asp?id=9550sx4lp&cookie%5Ftest=1 They claim th

[GENERAL] Update from diferents conditions

i want update differents rows of a table, but each row with a diferente condition, is possible make that update? ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joi

Re: [GENERAL] Asking advice on speeding up a big table

[EMAIL PROTECTED] writes: I have made some minor changes and speeded things up to around 15-20 lookups/sec, good enough, but not exciting :-) hmm let me understand this. You went from 1 query 3 to 4 seconds to 45 to 60 queries in the same amount of time... 45 to 60 times faster.. and that is

Re: [GENERAL] 21 bit number for sequence

Martijn van Oosterhout writes: > If you just want to store numbers, use numeric. Why do you want to > combine numeric and a sequence? He could use a numeric column and write the default as nextval('seq')::numeric Of course, he'll be paying through the nose performance-wise for his insist

Re: [GENERAL] Hardware related question: 3ware 9500S

Merlin Moncure writes: there are reasons to go with raid 5 or other raids. where I work we often do 14 drive raid 6 plus 1 hot swap on a 15 drive tray. Raid 5 is different from raid 6 To say that there are times it's ok to use RAID 5 and then say you use raid 6... well... doesn't really s

Re: [GENERAL] Hardware related question: 3ware 9500S

Merlin Moncure writes: escalade is a fairly full featured raid controller for the price. consider it the ford taurus of raid controllers, it's functional and practical but not sexy. Their S line is not native sata but operates over a pata->sata bridge. Stay away from raid 5. Do you know if

Re: [GENERAL] Asking advice on speeding up a big table

[EMAIL PROTECTED] writes: Usage is to match data from the key and val tables to fetch the data value from the sid table. What is the relation between key and val tables? Will key.id and val.id be equal? I have never quite/fully understand the outputs of analyze, but I wonder why you have:

Re: [GENERAL] Comparing text field

On 13 Apr 2006 12:20:08 -0700, Nik <[EMAIL PROTECTED]> wrote: > I am trying to compare a large string (that has new line characters in > it) to the contents of the text field (which also has new line > characters in it) and it is not behaving as expected. > > For example I have the following record

Re: [GENERAL] HUGE Stack space is gettiing consumed

On Fri, Apr 14, 2006 at 09:13:26AM +0530, Mavinakuli, Prasanna (STSD) wrote: > Hello All, > > We are getting very strange problem .. > > > We Have one data field in some table..type of this field > Is *TEXT*. > We are storing around 1,000 (

[GENERAL] HUGE Stack space is gettiing consumed

Hello All, We are getting very strange problem .. Scenario.. We Have one data field in some table..type of this field Is *TEXT*. We are storing around 1,000 (One Thousand) lines of text In that field. If it's run though separate thread,

Re: [GENERAL] 21 bit number for sequence

Hi, On Sat, 15 Apr 2006, Shoaib Mir wrote: Actually that is the application requirment to use 21 bit numbers as porting it from Oracle where it used to work. 21 bits are no problem as bigints have 64 bits. If you mean decimal digits please explicitly say so. A bit is a binary digit. Yeah

[GENERAL] Comparing text field

I am trying to compare a large string (that has new line characters in it) to the contents of the text field (which also has new line characters in it) and it is not behaving as expected. For example I have the following record in the database: id=83 message=VAC153-683-685-131830- /O.NEW.KLWX.SV.W

Re: [GENERAL] enforce naming convention

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > Can I create a trigger that runs when a new object is created and see > if its name is in an expected format and if not reject it? Sounds like you need a database-wide trigger on DDL. PostgreSQL has nothing like that at the moment. Your best bet

[GENERAL] enforce naming convention

Hi, is it possible to enforce naming convention in pg? Can I create a trigger that runs when a new object is created and see if its name is in an expected format and if not reject it? I had to create a new schema 'zref' storing some of our tables to conceptually separate them but I want to make s

Re: [GENERAL] Curious UDP packets

On Fri, Apr 14, 2006 at 02:59:10PM +0200, Magnus Hagander wrote: > > omega kernel: Shorewall:all2all:REJECT:IN= OUT=lo SRC=x.x.x.x > > DST=x.x.x.x LEN=1016 TOS=0x00 PREC=0x00 > > TTL=64 ID=21629 DF PROTO=UDP SPT=32769 DPT=32769 LEN=996 > > The PostgreSQL stats collector uses UDP over a random loo

Re: [GENERAL] 21 bit number for sequence

Actually that is the application requirment to use 21 bit numbers as porting it from Oracle where it used to work. Yeah now i have decided to use a numeric data type in a table and use that to write my own nextval and currval functions for that purpose. Thanks for the help./ShoaibOn 4/15/06, Martij

Re: [GENERAL] 21 bit number for sequence

On Sat, Apr 15, 2006 at 12:52:49PM +0500, Shoaib Mir wrote: > Actually what i want to do is store 10010 as the maximum > value in sequence. Is there a way for it ? Is that number in binary or decimal? In binary it's easy because it's only 1048608 decimal. In decimal it would requir

Re: [GENERAL] 21 bit number for sequence

Actually what i want to do is store 10010 as the maximum value in sequence. Is there a way for it ?Thanks,ShoaibOn 4/15/06, Martijn van Oosterhout wrote:On Sat, Apr 15, 2006 at 10:24:59AM +0500, Shoaib Mir wrote: > Right now Sequence by default uses bigint which

Re: [GENERAL] 21 bit number for sequence

On Sat, Apr 15, 2006 at 10:24:59AM +0500, Shoaib Mir wrote: > Right now Sequence by default uses bigint which supports upto 19bit numbers > but I want to use a 21bit that can be supported by NUMERIC datatype. Is > there any way I can sepcify while creating a sequence what datatype to use > or if I