Re: [GENERAL] no. of functions

Sandeep Joshi writes: >So, can I write all the 'C' functions in a single '.so' file and load > it once? There will be in all 90 functions. Yes. > Is there any limit on how many functions can be loaded? None besides running out of oids, memory, etc. > do they need to be in separate file?

[GENERAL] no. of functions

Hi, I have 30 tables and I want to write BEFORE trigger for INSERT, DELETE and UPDATE opeation on all the tables. So, can I write all the 'C' functions in a single '.so' file and load it once? There will be in all 90 functions. Is there any limit on how many functions can be loaded? do the

Re: [GENERAL] red hat/mysql fiasco

Alvaro Herrera wrote: > On Thu, 21 Dec 2000, Alessio Bragadini wrote: > Mandrake packages for Postgresql are also flawed, in 7.2 at least. When > you cast some strings as timestamps, you can get weird values ("0:10:00" > -> "0:09:60"). It's also a compiler problem. > Fortunately, Postgresql-pack

Re: [GENERAL] red hat/mysql fiasco

On Thu, 21 Dec 2000, Alessio Bragadini wrote: > "The MySQL packages shipped with Red Hat Linux 7 contained buggy > assembler code. When compiled with optimization enabled, this code > caused the database server to return bad results. Also, a case where > you can crash the database by a specific,

Re: [GENERAL] red hat/mysql fiasco

On Thu, Dec 21, 2000 at 11:23:32AM -0500, Mike Sears wrote: > > [Actually, the beta version of the gcc compiler that RH is now shipping > > with doesn't have this particular long long bug, but the latest official > > release of gcc does.] > > actually I had that problem w/ assembler errors in my

Re: [GENERAL] Could somebody EXPLAIN? :-)

[EMAIL PROTECTED] writes: > All this figures confuse me. Which one should i use for > comparison? The reading of your stopwatch ;-) The first line's "cost" value is the system's attempt to estimate total runtime, but it would be foolish to take this as gospel. Especially so with a pre-7.0 rele

[GENERAL] want to leave the mailinglist

Hi! Can anyone help me how i can leave the mailinglist? lg Manfred

Re: [GENERAL] Very slow select

Stefano Bargioni <[EMAIL PROTECTED]> writes: > SELECT FROM t WHERE a='my string'; works very fast. The same select > made on b is very slow (2 or 3 seconds), as if no index exists for > column b. What does EXPLAIN say about the two queries? regards, tom lane

Re: [GENERAL] red hat/mysql fiasco

> On Thu, Dec 21, 2000 at 11:46:33AM +0200, Alessio Bragadini wrote: > > "The MySQL packages shipped with Red Hat Linux 7 contained buggy > > assembler code. When compiled with optimization > >enabled, this code caused the database server to return bad results. > > > P.S. RedHat chose to ship

Re: [GENERAL] 7.1 Beta 1 & table size calculation

"Dale Anderson" <[EMAIL PROTECTED]> writes: > Is the relpages counts under 7.1 no longer valid of the physical page > storage? It's still valid, but you need to include the associated TOAST table as well as the primary relation. Keep in mind also that TOAST can do inline compression. If you mad

Re: [GENERAL] red hat/mysql fiasco

On Thu, Dec 21, 2000 at 11:46:33AM +0200, Alessio Bragadini wrote: > "The MySQL packages shipped with Red Hat Linux 7 contained buggy > assembler code. When compiled with optimization >enabled, this code caused the database server to return bad results. > P.S. RedHat chose to ship a beta vers

RE: [GENERAL] Off topic? - Solution for a delimiter problem

I think (I could be miss-reading the sed line) you're assuming that every field is a text field. I receive many files with both text and numeric fields. The numberic fields are not double quoted; so automating the pairing of double quotes as you have done becomes more complicated. The algorithm

[GENERAL] 7.1 Beta 1 & table size calculation

I am looking at 7.1 beta 1 to see how my application (currently on 7.0.3) will operate under 7.1. To calculate used space, in 7.0.3, I lookup the relpages count for the table in pg_class and multiply it by 8 (8k is my block size). In my testing of 7.1 beta 1, I created a record of length

[GENERAL] Could somebody EXPLAIN? :-)

Hi all. I wanted to compare the performances of 2 ways of writing a query, one using a cartesian join, one using a subselect, to see which one was the faster. I used the EXPLAIN command to understand how Postgres planned to execute them, but the results are a little obscure. Can somebody shed

RE: [GENERAL] Off topic? - Solution for a delimiter problem

Isn't this overkill? Something like: sed -e 's/\" \"/^I/g' -e 's/\"//g' would do the job nicely. I'm sure people on this list can suggest even simpler ways (note: the "^I", or tab character, in the example is created by typing Ctrl-V then Ctrl-I). Sed has been (and is) my friend for many

Re: [GENERAL] Best way to replicate a DB between two servers (master/slave)

Mirko Zeibig wrote: > > Hello everybody, > I know there was an announcement on www.postgresql.com, that sometime in the > future there will be a sort of replication mechanism for PostgreSQL. > > Now the problem: > > I have two servers, one providing content for a website (using PHP), > anothero

[GENERAL] red hat/mysql fiasco

We should be nice and professional on holiday season but sorry, I couldn't help myself: at we can read "The MySQL packages shipped with Red Hat Linux 7 contained buggy assembler code. When compiled with optimization enabled, this code cause

[GENERAL] Very slow select

I defined a table with two indexed text columns, a and b, of variable length. This table contains 287195 rows. SELECT FROM t WHERE a='my string'; works very fast. The same select made on b is very slow (2 or 3 seconds), as if no index exists for column b. I'd like to know why. Note that b contain